Course Preview
Course Materials
Course Features
Duration
Self-paced
Level
Beginner
Language
English
Mode
Online
Business Intelligence
Power BI Master Course — From Raw Data to Interactive Dashboards
Become a confident Power BI practitioner in this comprehensive online master course. Starting from zero, you will learn to connect to Excel, SQL Server, Azure, and SharePoint; clean and reshape data with Power Query; build star-schema data models; write DAX from basics to time intelligence (YTD/QTD/MTD); design interactive dashboards with KPIs, slicers, and drill-through; and publish to Power BI Service with Row-Level Security and collaboration. Includes 1:1 mentorship and mock interview preparation throughout.
Last updated March 2026
Next cohort starts Oct 1st
$1,200.00
$1,500.00
Save 20% - Limited Time Offer!
Turn data into decisions with Power BI. Build reliable models, write powerful DAX, and design interactive dashboards that scale from desktop to cloud.
- Connect: Excel/CSV, SQL Server, Web, Azure & SharePoint sources
- Transform: Power Query for typing, missing data, merge/append, unpivot
- Model: relationships, star vs snowflake schemas
- DAX: measures & columns, CALCULATE, IF/SWITCH, time intelligence (YTD/QTD/MTD)
- Visualize: core charts, tables/matrices, filters/slicers, drill-down & drill-through
- Advanced: KPIs, cards, waterfall/gauge/donut, maps, bookmarks & buttons
- Cloud: publish to Power BI Service, workspaces, apps, sharing & collaboration
- Security & scale: Row-Level Security, performance optimization
- Extras: Excel integration, Mobile layouts, Q&A and AI visuals
Finish with a final project: import → transform → model → visualize → publish → share, following best practices end-to-end.
1:1 Personalized Mentorship
Mock Interview Preparation
Connecting to Excel/CSV/SQL/Web/Azure/SharePoint
Power Query: cleaning, typing, merge/append, unpivot
Data modeling: relationships, star vs snowflake
DAX: measures/columns, CALCULATE, IF/SWITCH
Time intelligence: YTD/QTD/MTD
Core visuals: bar/line/pie, tables & matrices
Filters & slicers; drill-down & drill-through
Advanced visuals: waterfall, gauge, donut, maps, KPIs & cards
Dashboard design with bookmarks & buttons
Power BI Service: publish, workspaces, apps
Sharing & collaboration
Row-Level Security (RLS)
Excel integration
Power BI Mobile
Q&A and AI visuals (Key Influencers, Decomposition Tree)
Performance optimization
Final end-to-end project
Introduction to Power BI
4 lessons • Weeks 1
Overview of Business Intelligence & Power BI
Power BI Ecosystem: Desktop, Service, Mobile
Navigating Power BI Desktop
Installing Power BI Desktop
Connecting to Data Sources
4 lessons • Weeks 2
Introduction to Data Sources
Loading & Importing Data
DirectQuery vs Import Mode
Azure & SharePoint Connections
Power Query: Fundamentals
3 lessons • Weeks 3
Introduction to Power Query Editor
Changing Data Types & Handling Missing Data
Removing/Sorting Rows & Columns
Power Query: Advanced Transformations
3 lessons • Weeks 4
Unpivoting Data
Merging Queries
Appending Queries
Data Modeling & Relationships
3 lessons • Weeks 5
Understanding Relationships
Creating & Managing Relationships
Star vs Snowflake Schema
DAX I: Fundamentals
3 lessons • Weeks 6
Overview of DAX
Calculated Columns vs Measures
Basic DAX: SUM, COUNT, AVERAGE
DAX II: Advanced
3 lessons • Weeks 7
Logical Functions: IF, SWITCH
CALCULATE & Filters
Time Intelligence: YTD, QTD, MTD
Building Visualizations
3 lessons • Weeks 8
Bar/Line/Pie, Tables & Matrices
Customizing Visuals: Colors, Titles, Labels
Tooltips, Legends & Data Labels
Filters & Slicers
3 lessons • Weeks 9
Applying Filters to Visuals
Creating Slicers
Hierarchical Filters & Interactions
Drill-Down & Drill-Through
3 lessons • Weeks 10
Enabling Drill-Down
Cross-Filtering Between Visuals
Setting Up Drill-Through Pages
Advanced Visualizations
3 lessons • Weeks 11
Advanced Visual Gallery
KPIs & Cards
Creating Custom Visuals
Dashboard Design
2 lessons • Weeks 12
Dashboard Design Principles
Bookmarks & Buttons for Navigation
Power BI Service I
3 lessons • Weeks 13
Power BI Service Overview
Publishing Reports to Service
Navigating Workspaces
Sharing & Collaboration
3 lessons • Weeks 14
Creating Workspaces & Managing Access
Power BI Apps for Distribution
Sharing Reports & Dashboards
Row-Level Security (RLS)
3 lessons • Weeks 15
Introduction to RLS
Creating Roles in Desktop
Applying RLS in Service
Excel Integration
3 lessons • Weeks 16
Importing Data from Excel
Analyzing Power BI Reports in Excel
Using PowerPivot in Excel
Power BI Mobile
2 lessons • Weeks 17
Introduction to Power BI Mobile
Designing Mobile-Friendly Reports
Q&A and AI Visuals
3 lessons • Weeks 18
Using Power BI Q&A
Key Influencers
Decomposition Tree
Performance Optimization
3 lessons • Weeks 19
Optimizing Data Models
Improving Report Performance
Reducing Data Load Times
Final Project: End-to-End Power BI
3 lessons • Weeks 20
Building an End-to-End Report
Publishing & Sharing the Final Report
Q&A and Best Practices
Project: Final Project