The Definitive Guide to DAX
Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI

Authors:

Language: English
Cover of the book The Definitive Guide to DAX

Subject for The Definitive Guide to DAX

Approximative price 48.26 €

In Print (Delivery period: 14 days).

Add to cartAdd to cart
Publication date:
592 p. · Paperback

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need.
 

Foreword
Introduction

Chapter 1: What is DAX?
Chapter 2: Introducing DAX
Chapter 3: Using basic table functions
Chapter 4: Understanding evaluation contexts
Chapter 5: Understanding CALCULATE and CALCULATETABLE
Chapter 6: DAX examples
Chapter 7: Time intelligence calculations
Chapter 8: Statistical functions
Chapter 9: Advanced table functions
Chapter 10: Advanced evaluation context
Chapter 11: Handling hierarchies
Chapter 12: Advanced relationships
Chapter 13: The VertiPaq engine
Chapter 14: Optimizing data models&
Chapter 15: Analyzing DAX query plans
Chapter 16: Optimizing DAX

Index