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

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
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
Elements of DAX (excellent, multi-part series)

Get the source files here
with Brian Grant of CSG Pro
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

Books


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
FREE!

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

Power BI from Rookie to Rock Star
by Reza Rad

Code

DAX Patterns from SQLBI

More