13 Sections
43 Lessons
8 Weeks
Expand all sections
Collapse all sections
Course 1 : Preparing Business-Ready Data using Excel
0
Key Business Questions
3
2.1
How do I clean and unify inconsistent data from multiple sources?
2.2
How do I automate reports and dashboards for recurring business needs?
2.3
Can I use Excel to model business scenarios and make data-backed decisions?
Advanced Excel for Data Structuring
3
3.1
Logical functions: IF, IFS, AND, OR
3.2
Lookup functions: VLOOKUP, INDEX, MATCH, XLOOKUP
3.3
Text & Date handling: TEXTJOIN, LEFT/RIGHT, DATEDIF
Summarizing & Visualizing Business Metrics
3
4.1
Create dynamic summaries using PivotTables & Pivot Charts
4.2
Apply business logic through Conditional Formatting and Data Validation
4.3
Build an interactive performance dashboard
Modelling Scenarios & Workflow Automation
2
5.1
Use What-If Analysis (Goal Seek, Data Tables, Scenario Manager) for forecasting
5.2
Optimize resource allocation using Solver Add-in
Projects
6
6.1
Data Cleaning & Preparation in Excel
6.2
Sales Analysis Dashboard
6.3
Bank Marketing Campaign Report
6.4
Advanced Data Filtering
6.5
Human Resource Dashboard
6.6
Project Management Analysis
Course 2 : Business Intelligence using Power BI
0
Key Business Questions
3
8.1
How can I create a real-time dashboard that tracks sales performance?
8.2
How do I build a scalable reporting system for business leaders?
8.3
How do I apply business rules to create dynamic KPIs?
Introduction to Power BI & Power Query
3
9.1
Power BI Ecosystem (Desktop, Service, Mobile)
9.2
Connect to Excel, CSV, and SQL Server data
9.3
Clean, merge, and structure data using Power Query Editor
Visualization & Report Design
3
10.1
Choosing the right visuals for your data.
10.2
Formatting, themes, and report layout.
10.3
Interactivity: Slicers, filters, bookmarks, and drill-through.
Working with DAX Functions
3
11.1
Calculated Columns vs. Measures
11.2
DAX Functions: SUM, AVERAGE, COUNT, DISTINCTCOUNT
11.3
Date, Time & Text based DAX Functions
Projects
6
12.1
Telecom Industry Churn Analysis
12.2
OLA Cabs Analysis Report
12.3
BLINKIT Analysis Report
12.4
Bike Buyer Report in Power BI
12.5
Company Cost Calculation
12.6
Employee HR Dashboard
AI with Analysis
8
13.1
AI for Data-Driven Decision-Making
13.2
From Data to Decisions: Data Cleaning and Analysis With AI
13.3
Generating structured reports for decision-making
13.4
Data Detective: Using AI for Exploratory Data Analysis (EDA)
13.5
From Data to Story: Tailoring Your Narrative
13.6
From Data to Story: Visual Storytelling
13.7
Presenting Your Data Story: From Report to Impact
13.8
AI for Problem Solving: The SOLVE Framework
Advanced Excel & Power BI
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your Website
Modal title
Main Content
Your Website
