Tools and References for Power BI and Tabular Data Model Developers (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 learning


Intro to Data Modeling for Power BI

Introducing DAX

DAX Tools Video Course
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 (multi-part series)with Brian Grant of CSG Pro

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