Tabular Data Model Developer – Tools and References for Power BI / SSAS Tabular, etc. (including DAX)

See the T-shirt version
Thanks, Chris Wagner at Kratos BI
Software ToolsFree video learningBooksCodeMore

These references apply to the development of Power Pivot data models in Excel, SSAS Tabular data models, and Power BI data models

From Alberto Ferrari, one of the world’s subject matter experts on the topic of DAX, “7 Reasons DAX is Not Easy“. He says, “DAX is simple, but it is not easy.”

See also my Power BI homepage on this site

Software Tools

DAX Guide

Master list of DAX functions, usage, syntax, and compatibility

Power BI Helper, now version 12, from RADACAD (I pulled the picture below directly from the RADACAD website.

Free video and self-guided learning

Intro to Data Modeling for Power BI

Introducing DAX

DAX Tools Video Course
Elements of DAX (excellent, 52-part series)

Get the source files here
with Brian Grant of CSG Pro, a gifted trainer on this material, for sure. He has other videos, as well.
Use DAX in Power BI Desktop7 Modules from Microsoft Learn
Introduction to creating measures using DAX in Power BI10 Units from Microsoft Learn
Beginning DAX Concepts with Power BI (2:54:14)by Mitchell Pearson at Pragmatic Works
Advanced DAXby Mitchell Pearson at Pragmatic Works
Evaluation Contexts in DAXby Matt Allington of Excelerator BI in Australia
DAX Measures: Filter Context Explained in Simple Terms using the I.C.A.N. Principle by Avi Singh [Part 1]
Filter Context – (1.9) Ultimate Beginners Guide to DAXby Sam McKay at Enterprise DNA in Australia
DAX Fridays YouTube channel – Curbalby Ruth Pozuelo Martinez
Stairway to DAX and Power BI – Level 1: Getting Started with PowerPivot and DAX (SQLServerCentral)This isn’t video learning, but it is by the acclaimed Bill Pearson
Season 5 – Data Model PrepSteve Campbell 3-Part YouTube Series

Data Model Prep – STAR schema Basics – Season 5 Ep.1, 1:11:07
Analyzing Data Models – Season 5 Ep.2, 1:23:09
Architecting Data Models – Season 5 Ep.3, 1:04:21

Ever wonder what are the best practices when building a data model? Then this series is for you. An incredible trainer Steve Campbell guides us through the basics of data model building.


Supercharge Power BI
Power BI is Better When You Learn to Write DAX

by Matt Allington
Click here to buy.

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
by Gil Raviv

Exam Ref 70-778,
Analyzing and Visualizing Data with Microsoft Power BI
by Daniil Maslyuk

Microsoft SQL Server 2012 Analysis Services –
The BISM Tabular Model

by Marco Russo, Alberto Ferrari, and Chris Webb

The Definitive Guide to DAX –
Second Edition

by Marco Russo and Alberto Ferrari

Expert Data Modeling with Power BI

by Soheil Bakhshi
FREE ebook!

Introducing Microsoft Power BI
by Alberto Ferrari and Marco Russo
FREE ebooks!

Power BI from Rookie to Rock Star
by Reza Rad


DAX Patterns from SQLBI