Start here
Lessons and reference
Look things up
Start here
SQL
Power Query
Data modeling
Power BI and DAX
Finance playbooks
Run queries
Build and check
Not sure where to start? Pick the path closest to your job and follow the steps in order.
You will be able to: Write SELECT, WHERE, JOIN and GROUP BY queries with confidence.
You will be able to: Pull live data into Excel, shape it with Power Query and summarize it with PivotTables and Power Pivot.
You will be able to: Build a model, write time-intelligence and percent-of-total measures, and design a report with drillthrough and security.
You will be able to: Analyze receivables, payables and the ledger from accounting-system tables.
You will be able to: Clean messy extracts, reshape them, combine tables and write your first M functions.
You will be able to: Report on realization, WIP and aging for a CPA firm, and on donors, grants and funds for a nonprofit.
You will be able to: Plot addresses on a map, measure distances, and chart by fiscal year, quarter and period.
You will be able to: Recognize star, snowflake, slowly changing, snapshot and bridge patterns, model them in Power BI, and handle very large tables.
You will be able to: Answer budget, service-level, public-safety and revenue questions for a small city, and map them.
You will be able to: Answer maintenance-cost, backlog, vendor-payment, billing and outage questions for a utility, and build the report in Excel or Power BI.
You will be able to: Work with 1.6 million sensor readings, reconcile solar, battery and grid energy, and explore events, automations and trips.
You will be able to: Connect Claude or another MCP assistant and have it explain data, check your SQL and help with DAX.