Power BI lessons

Power Query, the data model, DAX, and the PL-300 exam. 14 lessons across 6 tracks, each ending with a short self-check.

14lessons

131mtotal

6tracks

28checks

Foundations

The three engines inside Power BI and how they fit together.

2 · 17m

How Power BI fits togetherDesktop, Service, and the three engines you are actually using.beginner8m Import, DirectQuery and composite modelsThe storage mode decision, and what each mode costs you.intermediate9m

Power Query

Getting data in and shaping it before it reaches the model.

2 · 19m

Shaping data in Power QueryApplied steps, the M language underneath, and the transformations you use daily.beginner10m The M languageReading and writing M when the UI is not enough.advanced9m

Data modeling

Star schemas, relationships, and why the model decides everything.

2 · 20m

Star schema and why it mattersThe model shape Power BI is built for, and what goes wrong without it.intermediate10m Relationships and filter directionCardinality, cross-filter direction, and the ambiguity traps.advanced10m

DAX

From measures to filter context and time intelligence.

4 · 40m

Measures vs. calculated columnsWhen each evaluates, what each costs, and how to choose.beginner9m Filter context and CALCULATEThe single most important idea in DAX, and the function that manipulates it.advanced12m Time intelligenceYear-to-date, prior period, and rolling windows — with the prerequisites that make them work.intermediate10m DAX patterns worth memorisingRanking, variables, safe division, and the functions you will reach for constantly.intermediate9m

Reports & visuals

Building report pages people can actually use.

1 · 9m

Designing report pagesVisual selection, interactions, and the features that make a report navigable.beginner9m

Service & governance

Workspaces, refresh, row-level security, deployment.

3 · 26m

Workspaces, apps and refreshPublishing, workspace roles, gateways, and scheduled refresh.intermediate9m Row-level securityStatic and dynamic roles, USERPRINCIPALNAME, and testing before release.advanced9m Preparing for PL-300What the Power BI Data Analyst exam covers and how to study for it.intermediate8m