Home / Learn / Data & AI / Power BI and DAX
All lessons

Power BI and DAX: from raw data to a dashboard managers use

Learn Power BI the way BI teams use it: clean data in Power Query, model it as a star schema, write DAX measures and time intelligence, and design a report people act on. Type and run DAX in every lesson, and watch step by step what each formula does to the data.

For students, career changers and analysts who know Excel. No coding needed to start. A Windows computer helps for the hands-on parts (Power BI Desktop is free); every DAX exercise also runs right here in the browser. Free, no sign-up. All 45 lessons, about 12.1 hours.

Try it now: DAX playground (write and run DAX on the Northbay model, no install) · download the course data · DAX cheat sheet · glossary · interview questions

What you will be able to do

  • Turn messy files into a clean model with Power Query, then shape it into a star schema with a proper date table.
  • Write the DAX that interviews ask for: measures, SUMX and row context, CALCULATE and filter context, ALL and percent of total, ranking, year to date, last year and rolling averages.
  • See what every formula does: press "Show me what happened" under any result to watch the filters flow through the relationships, rows get kept or dropped, and values add up, one step at a time.
  • Build a dashboard you can show employers: the capstone is a Northbay sales report you build yourself in Power BI Desktop, with a write-up for your portfolio.

Every lesson has a short explanation, a picture of the idea, DAX you can type and run with instant checks, practice questions and a 3-question quiz. Pair it with Data storytelling for the design side, and with From a straight line to an LLM if you want the maths of prediction.

0 of 45 lessons done

Without the tick, your progress lasts until you close this tab. Either way it stays in this browser: there is no sign-up and nothing is sent to us.

All modules

Part A: Getting data ready

1 Getting started 5 lessons

  1. 1.1 What Power BI is and what a BI developer does
  2. 1.2 Meet Northbay Goods: the data for this course
  3. 1.3 Install Power BI Desktop and find your way around
  4. 1.4 Your first report in 15 minutes
  5. 1.5 How to practise DAX in this course

2 Power Query: get and clean data 5 lessons

  1. 2.1 Power Query: applied steps you can replay
  2. 2.2 Cleaning: types, blanks, trims and splits
  3. 2.3 Merge and append: joining tables
  4. 2.4 Unpivot, pivot and group by
  5. 2.5 Reading the M code behind each step

3 Data modelling 5 lessons

  1. 3.1 Star schema: facts and dimensions
  2. 3.2 Relationships, cardinality and filter direction
  3. 3.3 A proper date table
  4. 3.4 Calculated columns or measures?
  5. 3.5 Common modelling mistakes and how to fix them

Part B: DAX

4 DAX basics 5 lessons

  1. 4.1 Your first measures: SUM, COUNTROWS, DISTINCTCOUNT
  2. 4.2 DIVIDE, ratios and percentages
  3. 4.3 Iterators: SUMX and row context
  4. 4.4 RELATED and looking things up
  5. 4.5 Variables, IF and SWITCH

5 Filter context and CALCULATE 7 lessons

  1. 5.1 Filter context: what a measure sees
  2. 5.2 CALCULATE: change the filters
  3. 5.3 ALL, REMOVEFILTERS and percent of total
  4. 5.4 FILTER and table filters
  5. 5.5 Context transition
  6. 5.6 Ranking and top N
  7. 5.7 DAX queries: EVALUATE and SUMMARIZECOLUMNS

6 Time intelligence 4 lessons

  1. 6.1 Year, quarter and month to date
  2. 6.2 Same period last year and growth
  3. 6.3 Rolling 28 days and moving averages
  4. 6.4 Pace against last year and targets

Part C: Reports people use

7 Visuals and report design 5 lessons

  1. 7.1 Picking the right visual
  2. 7.2 Slicers, cross-filtering and interactions
  3. 7.3 Drill down, drill through and tooltips
  4. 7.4 Bookmarks, buttons and navigation
  5. 7.5 Layout, themes and accessibility

8 Performance, security and sharing 5 lessons

  1. 8.1 Faster reports: Performance Analyzer and model size
  2. 8.2 Row-level security
  3. 8.3 Publishing: workspaces, apps and sharing
  4. 8.4 Scheduled refresh and gateways
  5. 8.5 Field parameters and calculation groups

9 Capstone and interviews 4 lessons

  1. 9.1 Capstone: the Northbay sales dashboard brief
  2. 9.2 Building the capstone step by step
  3. 9.3 Writing it up for your portfolio
  4. 9.4 Power BI and DAX interview questions