Course catalog
Found: 1 course · 15 in the catalog
Tagged power-bi · Remove the tag
Version 1.0.1, 4 October 2026
level: intermediate
A preparation course for Microsoft exam PL-300 (Microsoft Power BI Data Analyst), written for senior developers in Big 4 and other professional-services firms who already think in SQL and code — and keep getting surprised by DAX. The course follows the official skills outline (April 2026 revision) with its four domains and weights: prepare the data (25–30%), model the data (25–30%), visualize and analyze the data (25–30%), and manage and secure Power BI (15–20%). It covers what the 2026 updates added: Direct Lake, calculation groups, visual calculations, DAX query view and Copilot in Power BI. The spine of the course is the shift from SQL thinking to DAX thinking: filter context, row context, CALCULATE and context transition, taught with small models you can compute in your head before you check them in Power BI Desktop. Every topic follows the same order: the pain, the solution, and what it costs — memory, refresh time, query latency, licences or security risk. Labs run in Power BI Desktop (free) on a synthetic Aldervane Advisory LLP dataset — timesheets, invoices with three role-playing dates, month-end WIP balances and a nested JSON export — published on GitHub. Service features (workspaces, apps, RLS, refresh) are shown step by step, with a free route to a sandbox tenant and a read-the-screenshots path for learners whose corporate tenant blocks publishing. Practice uses the formats of the real exam: single and multiple choice, matching, Yes/No statement sets, "what does this measure return in this cell" and DAX completion. Isotype-style pictures summarise one idea each. Optional units cover PBIP/TMDL and Git, a SQL-to-DAX phrasebook, client-confidentiality patterns and the bridge to Microsoft Fabric.
28 units · ~51 h without the optional units, ~59 h with them · material in English · author: Andrey Kuralekh