Course Curriculum
11 interactive lessons with real-time autograding
Introduction to Power BI
Business intelligence ecosystem, Power BI Desktop, and data workflows.
Getting Data
Connecting to Excel, CSV, folders, web, and relational SQL databases.
Power Query
Data transformation, unpivoting, merging queries, and M language basics.
Star Schema
Fact tables, dimension tables, normalization, and dimensional modeling.
Relationships & Date Table
One-to-many relationships, active filters, and custom calendar tables.
DAX Basics
Calculated columns vs measures, SUM, COUNTROWS, and evaluation context.
DAX CALCULATE
Filter context modification, CALCULATE, FILTER, and ALL functions.
Time Intelligence
TOTALYTD, SAMEPERIODLASTYEAR, DATEADD, and moving averages.
Report Design
Visual hierarchy, layout, color palettes, KPIs, and card design.
Interactivity
Cross-filtering, slicers, drill-through pages, bookmarks, and tooltips.
Power BI Service
Workspaces, publishing reports, dashboards, scheduled refresh, and sharing.