Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements.

  • Use tools like Power BI Desktop Performance Analyzer and DAX Studio
  • Understand the DAX formula engine
  • Learn characteristics of different storage engines (VertiPaq, DirectQuery over SQL)
  • Read DAX query plans
  • Optimize common DAX constructs
  • Solve security performance issues
  • Improve DirectQuery response time
  • Control the data placement in composite models to avoid bottlenecks

Prerequisites: proficiency in DAX and SQL (for DirectQuery), understanding of the Tabular engine used by semantic models, and familiarity with DAX Studio.

Book content

  • CORE CONCEPTS
    1. Introduction
    2. Introducing optimization with examples
    3. Introducing the Tabular query architecture
    4. Using the Power BI Desktop Performance Analyzer
    5. Using DAX Studio
    6. Introducing query plans
  • THE FORMULA ENGINE
    1. Understanding the DAX Formula Engine
    2. Understanding query plans
    3. Optimizing the formula engine
  • VERTIPAQ
    1. Understanding the VertiPaq engine
    2. Understanding VertiPaq relationships
    3. Analyzing VertiPaq storage engine queries
    4. Optimizing common DAX constructs
    5. Moving and applying filters to tables
    6. Optimization examples for VertiPaq
    7. Understanding security optimization
  • DIRECTQUERY OVER SQL
    1. Understanding DirectQuery over SQL
    2. Optimizing DirectQuery over SQL
    3. Optimization examples for DirectQuery
  • COMPOSITE MODELS
    1. Understanding composite models
    2. Composite models optimization examples
    3. Understanding complex models

Sample chapters

Download the sample chapters of the book:   Optimizing-DAX-SE-Sample.pdf

ISBN

Paperback: 978-1735365220
Colored Version (Hardcover): 978-1735365244
Kindle: B0D1GW1TP3 (ASIN)
ePub: 978-1735365237

Resources

Companion content
Errata corrige

Reviews

See reviews on Amazon.com