Why so few
Every book here earns its place by being the reference for its subject. Read one properly rather than skimming ten.
| Area | Book | Why | Stage |
|---|---|---|---|
| Dimensional modeling | The Data Warehouse Toolkit, Ralph Kimball and Margy Ross | The source of facts, dimensions, grain and slowly changing dimensions. Everything in Power BI modeling builds on it | Developer → Architect |
| DAX mastery | The Definitive Guide to DAX, Third Edition, Marco Russo and Alberto Ferrari | How DAX really works: contexts, context transition, table functions. The book you'll reread | Developer → Senior |
| DAX performance | Optimizing DAX, Second Edition, Marco Russo and Alberto Ferrari | The storage engine, formula engine, query plans and how to make measures fast | Senior → Engineer |
| DAX problems | DAX Patterns, Second Edition, Marco Russo and Alberto Ferrari | Ready-made solutions to business problems; also free to read at daxpatterns.com | Developer → Senior |
| Data visualisation | Storytelling with Data, Cole Nussbaumer Knaflic | Choosing visuals, removing clutter, focusing attention: report design that works | Analyst → Senior |
| SQL | T-SQL Fundamentals, Itzik Ben-Gan | Thinking in sets, window functions and query logic, from the authority on T-SQL | Analyst → Engineer |
Editions are as listed by the publishers in October 2026; check SQLBI's book list for the current DAX editions.
Reading order
- Starting out: Storytelling with Data, then the first half of The Definitive Guide to DAX alongside the Beginner and Intermediate levels.
- Becoming senior: The Data Warehouse Toolkit (the first chapters cover most of what you need), the rest of The Definitive Guide to DAX, then Optimizing DAX.
- Engineering and architecture: T-SQL Fundamentals if SQL isn't already second nature, and the Kimball design tips for edge cases.
Free alternatives
If a book isn't in your budget: DAX Patterns online, DAX Guide, Microsoft's star schema guidance, and the trusted sources page cover much of the same ground.