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
Product details
Publisher : SQLBI Corp.; 2nd ed. edition (April 30 2024)
Language : English
Paperback : 816 pages
ISBN-10 : 173536522X
ISBN-13 : 978-1735365220
Item weight : 1.38 kg
Dimensions : 19.05 x 4.67 x 23.5 cm
Best Sellers Rank: #85,310 in Books (See Top 100 in Books)
#11 in Data Warehousing
#11 in Database Software
#27 in Data Mining
Customer Reviews: 4.9
10 ratings