Power BI lessons
Power Query, the data model, DAX, and the PL-300 exam. 21 lessons across 4 tracks, each ending with a short self-check.
21lessons
175mtotal
4tracks
42checks
Data import & transformation
Connecting to sources, Power Query, cleaning, merging and appending.
How Power BI fits togetherDesktop, Service, and the three engines you are actually using.Import, DirectQuery and composite modelsThe storage mode decision, and what each mode costs you.Shaping data in Power QueryApplied steps, the M language underneath, and the transformations you use daily.The M languageReading and writing M when the UI is not enough.Navigating Power QueryApplied steps, the query pane, and why the step order matters.Merging and appending queriesJoining and stacking in Power Query, and when to do it in the model instead.
Data modelling & relationships
Star schema, relationships, calendar tables and role-playing dimensions.
Star schema and why it mattersThe model shape Power BI is built for, and what goes wrong without it.Relationships and filter directionCardinality, cross-filter direction, and the ambiguity traps.Measures vs. calculated columnsWhen each evaluates, what each costs, and how to choose.Active and inactive relationshipsRole-playing dimensions, and activating a relationship inside a measure.Building a calendar tableWhy time intelligence needs one, and how to build it properly.
DAX calculations
Measures, filter context, CALCULATE, logical functions and time intelligence.
Filter context and CALCULATEThe single most important idea in DAX, and the function that manipulates it.Time intelligenceYear-to-date, prior period, and rolling windows — with the prerequisites that make them work.DAX patterns worth memorisingRanking, variables, safe division, and the functions you will reach for constantly.FILTER, ALL and ALLEXCEPTRemoving and replacing filter context deliberately.
Visualisation & sharing
Visuals, drill-through, bookmarks, publishing and security.
Designing report pagesVisual selection, interactions, and the features that make a report navigable.Workspaces, apps and refreshPublishing, workspace roles, gateways, and scheduled refresh.Row-level securityStatic and dynamic roles, USERPRINCIPALNAME, and testing before release.Preparing for PL-300What the Power BI Data Analyst exam covers and how to study for it.Drill-down and drill-throughMoving between levels and between pages.Bookmarks and navigationSaved states, the selection pane, and building custom navigation.