we learn Power BI From the ground up to advanced DAX
Four lessons built in order, each divided into short topics with a self-test and full solutions. Alongside them, a consolidated question bank that gathers all 693 questions in one place, and a function reference for working time.
To the course homepage · SQL · Python · PandasMicrosoft releases a new version every month. For every update there's a full lesson here: an executive summary, why the feature was built, the technical details with code, known bugs with workarounds, and a 12-question quiz.
for updates June · July · AugustThe learning track
Power BI basics
From the world of BI to building a polished report: the ecosystem, data loading, visuals, design and publishing.
to the lesson Lesson quiz · 30 questionsData modeling
the engine under the hood and how a star schema works: VertiPaq, relationships, Star Schema and cardinality.
to the lesson Lesson quiz · 40 questionsHands-on practice and tools
Capstone assignment · AdventureWorks
A complete sales dashboard from scratch: 13 DAX measures (including RANK, WINDOW, OFFSET and INDEX), four cards, four charts and a country traffic-light. 25 exercises, each on a separate page with a full solution and a downloadable data file.
for the taskSummary assignment · NBA
A star schema for the NBA league: 14 measures including three window functions, two dashboard pages and conditional formatting using two techniques. 28 exercises within Lesson 1, each on its own page with a full solution.
for the taskCapstone assignment · Space launches
A star schema with 32 tables and 100,000 rows: 14 measures including three window functions, two dashboard pages and conditional formatting with two techniques. 27 exercises, each on a separate page with a full solution and downloadable data.
for the taskCapstone assignment · Champions League
A star schema with 32 tables and 100,000 rows: 14 measures including three window functions, two dashboard pages and conditional formatting with two techniques. 27 exercises, each on a separate page with a full solution and downloadable data.
for the taskSummary assignment · Retail sales
A star schema with three fact tables and two snowflake branches: 14 measures including three window functions, two dashboard pages and conditional formatting with two techniques. 27 exercises with a full solution and downloadable data.
for the taskSummary assignment · Telecom
A pure star schema — one fact table with 30,000 rows and seven dimensions: 14 measures including three window functions, eleven dashboard pages and a channel profitability insight. 29 exercises with a full solution and downloadable data.
for the taskCapstone assignment · Logistics
A pure star schema — one fact table with 28,400 shipment rows and seven dimensions: 14 measures including three window functions, eleven dashboard pages, and the insight of the carrier that isn't profitable. 29 exercises with full solutions and downloadable data.
for the taskCapstone assignment · Educational Institution
A pure star schema — one fact table with 28,640 log rows and seven dimensions: 14 measures including three window functions, eleven dashboard pages, and a trap of cancelled rows carrying unrealized revenue. 29 exercises with a full solution and downloadable data.
for the taskCapstone assignment · Pharma Industry
A pure star schema — one fact table with 28,400 sales rows and seven dimensions: 14 measures including three window functions, eleven dashboard pages, and a trap of voided rows carrying nine percent of phantom revenue. 29 exercises with full solutions and downloadable data.
for the taskThe centralized question bank
All 693 questions from the four lessons in one place - M and DAX syntax, Power Query, and modeling. Filter by lesson and topic, free search, practice mode, and exam mode with a score.
To the question bankDAX function reference
122 functions across ten categories: in-depth explanations, full syntax, every parameter, copy-paste examples and common pitfalls. With live search.
for referencePower BI updates
A full lesson for every Microsoft monthly update: an executive summary, the business rationale behind every feature, the technical details with code, known bugs with workarounds, and a self-test. June, July and August 2026.
for updates