Downloads
Analyze

Analyze data with Excel, Power Pivot and Power BI

Practical guides that use the LearnSQL sample databases. Query the data in SQL, clean it in Power Query, model it, then write the measures behind your reports. Every example runs, so you can check your answers.

  1. 1Get the dataExcel, Power Query, SQL Server connection
  2. 2Query and clean itSQL joins and filters, Power Query steps
  3. 3Model itFacts, dimensions and one-to-many relationships
  4. 4Measure and reportDAX measures, time periods, Power BI visuals

Pick your starting point

Choose the work you do. Each card lists the guides to read, in order.

The learning path

Work down the path once. Come back to any step when a project needs it.

  1. Step 1 Start here What a table, a key and a query are.
  2. Step 2 SQL and Power Query Write queries and clean the data they return.
  3. Step 3 Data modeling Facts, dimensions and the relationships between them.
  4. Step 4 Power BI and DAX Measures, filters, time periods and reports.
  5. Step 5 Finance playbooks The whole process on real finance questions.

The sample database guides can go with any step. Use them as practice projects.

Start here

Two short guides for people who have not written a query yet. Read them first, then pick a track.

SQL

Read, join and summarize data with SQL. Every example runs on the sample databases.

Power Query

Clean and reshape data before it reaches a report: the steps you click, and the M code behind them.

Data modeling

Facts, dimensions and relationships. A good model makes every measure simple and every total correct.

Power BI and DAX

Measures, filter context, CALCULATE and time intelligence, with Power BI and Excel's Data Model.

Finance playbooks

Finance questions worked end to end: aging, trial balance, budget variance, controls and close work.

Sample database guides

A guide to each practice database: what is in it, how the tables connect, and questions to try.

See it working

Finished files and practice material, so you can open a model and see how the pieces fit.

Nine Power BI projects

Advanced DAX Patterns, CALCULATE and Filter Context, DAX Basics and more: a complete model, measures and report pages to dissect.

Downloads

Excel practice workbooks

Real data with questions and an answer key, for PivotTables and Power Pivot.

Downloads

DAX cheat sheet

The patterns you will use most, on one printable page.

Printable

Power BI and DAX learning path

The guides in a sensible order, with time estimates.

Learning path

Ask an AI assistant

Connect an assistant that knows these guides and can check your formulas.

Connect

Glossary

Plain-English definitions: filter context, star schema, measure and more.

Reference