Tools and References for Power BI and Tabular Data Model Developers

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

This is just a sampling of tools available from SQLBI

DAX Guide

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

Power BI Helper from RADACAD

Free video learning

Intro to Data Modeling for Power BI

Introducing DAX


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

Introducing Microsoft Power BI
by Alberto Ferrari and Marco Russo

Power BI from Rookie to Rock Star
by Reza Rad


DAX Patterns from SQLBI

The code used to apply DAX in several typical business scenarious. There is a companion book, also.