Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services - Paperback

Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services - Paperback

$111.28
Sale price  $111.28 Regular price 
Skip to product information
Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services - Paperback

Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services - Paperback

$111.28
Sale price  $111.28 Regular price 

by Alberto Ferrari (Author), Marco Russo (Author)

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.

Number of Pages: 818
Dimensions: 1.62 x 9.25 x 7.5 IN
Publication Date: April 30, 2024

Intentional design

We make things that work better and last longer. Our products solve real problems with clean design.

Quality first

We obsess over the details and strive to deliver the best products at the best prices, every time.

Customer care

We're always on your side: keeping our loyal customers happy is our top priority and number one goal.

Feature 1

Made with care and unconditionally loved by our customers, this signature bestseller exceeds all expectations.

Feature 2

Made with care and unconditionally loved by our customers, this signature bestseller exceeds all expectations.

At the heart of every product lies a unique story, driven by our passion for quality and innovation. Each item enhances your everyday life and sparks joy.