Optimizing DAX Optimizing DAX

Optimizing DAX

Improving DAX performance in Microsoft Power BI and Analysis (second edition) Services

    • $39.99
    • $39.99

Publisher Description

This book is the state of the art of 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.

GENRE
Computers & Internet
RELEASED
2024
April 30
LANGUAGE
EN
English
LENGTH
792
Pages
PUBLISHER
SQLBI Corp.
SELLER
Marco Russo
SIZE
124.6
MB
The Definitive Guide to DAX The Definitive Guide to DAX
2015
Definitive Guide to DAX, The Definitive Guide to DAX, The
2019
Analyzing Data with Power BI and Power Pivot for Excel Analyzing Data with Power BI and Power Pivot for Excel
2017
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
2009
Expert Cube Development with SSAS Multidimensional Models Expert Cube Development with SSAS Multidimensional Models
2014
Microsoft SQL Server 2012 Analysis Services Microsoft SQL Server 2012 Analysis Services
2012