I live in Excel
Your roleKeep the formulas you know. Learn how the same ideas look in a database.
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
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.
Choose the work you do. Each card lists the guides to read, in order.
Keep the formulas you know. Learn how the same ideas look in a database.
Find the right tables, join them and pull a clean extract.
Fix headers, types, dates and account codes before you analyze.
Write the measures behind your visuals and get the totals right.
Build the facts and dimensions for budget against actual and the statements.
Test every journal entry, payment and vendor record, not a sample.
Work down the path once. Come back to any step when a project needs it.
The sample database guides can go with any step. Use them as practice projects.
Two short guides for people who have not written a query yet. Read them first, then pick a track.
Read, join and summarize data with SQL. Every example runs on the sample databases.
Clean and reshape data before it reaches a report: the steps you click, and the M code behind them.
Clean finance data with clicks, and see the steps each click creates.
Queries, let and in, lists and records: the M you will see in the editor.
Columns, merges, groups, pivot and unpivot on real tables.
Your own functions, a date table, running totals and a worked example.
Query folding, common errors, and when to use M instead of SQL or DAX.
Facts, dimensions and relationships. A good model makes every measure simple and every total correct.
Facts and dimensions for a general ledger and budget against actual.
Star schemas, one-to-many filters, role-playing dates and security.
Connection details and a star-schema recipe for each sample database.
Common table shapes, the database that teaches each, and Power BI limits.
Measures, filter context, CALCULATE and time intelligence, with Power BI and Excel's Data Model.
Model view, parameters, row-level security, publishing and PBIP projects.
The Excel Data Model: relate tables, write measures, build PivotTables.
Measures versus columns, row and filter context, and your first measures.
The most important DAX function: add, remove and keep filters.
Year to date, prior year, rolling 12 months and fiscal calendars.
SUMX, RANKX, TOPN and when to use each one.
Percent of total, Pareto, budget variance and calculation groups.
Standard sales, finance and operations layouts and their measures.
Why a measure is slow, common error messages, and how to debug a wrong number.
A quick reference of the DAX functions, grouped by purpose.
How the engines work, context transition and reading query plans.
Finance questions worked end to end: aging, trial balance, budget variance, controls and close work.
Aging, trial balance, duplicates and accruals, answered in SQL.
Income statement, balance sheet and variance measures with correct signs.
Bank exports, trial balances, monthly folders and account mapping.
Ledger to dashboard: connect, shape, model, measure and lay out a finance pack.
Journal entry tests, duplicate payments, vendor checks and Benford's law.
A guide to each practice database: what is in it, how the tables connect, and questions to try.
Clients, engagements, time, billing and WIP for a small CPA firm.
Donors, pledges, grants and fund accounting for a regional nonprofit.
86 messy tables for practicing Power Query recipes.
Devices, energy, sensor readings and bills for one connected home.
311 requests, permits, a water utility and fund accounting for a city.
Star and snowflake schemas, slowly changing dimensions and snapshots.
25 million manufacturer order lines and how to query them at scale.
Work orders, purchase orders, invoices and billing for a utility.
Addresses on a map, and a fiscal calendar in every lab database.
Finished files and practice material, so you can open a model and see how the pieces fit.
Advanced DAX Patterns, CALCULATE and Filter Context, DAX Basics and more: a complete model, measures and report pages to dissect.
Real data with questions and an answer key, for PivotTables and Power Pivot.
The patterns you will use most, on one printable page.
The guides in a sensible order, with time estimates.
Connect an assistant that knows these guides and can check your formulas.
Plain-English definitions: filter context, star schema, measure and more.