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.
This title is in stock with our Australian supplier and should arrive at our Sydney warehouse within 2 - 3 weeks of you placing an order.
Once received into our warehouse we will despatch it to you with a Shipping Notification which includes online tracking.
Please check the estimated delivery times below for your region, for after your order is despatched from our warehouse:
ACT Metro: 2 working days
NSW Metro: 2 working days
NSW Rural: 2-3 working days
NSW Remote: 2-5 working days
NT Metro: 3-6 working days
NT Remote: 4-10 working days
QLD Metro: 2-4 working days
QLD Rural: 2-5 working days
QLD Remote: 2-7 working days
SA Metro: 2-5 working days
SA Rural: 3-6 working days
SA Remote: 3-7 working days
TAS Metro: 3-6 working days
TAS Rural: 3-6 working days
VIC Metro: 2-3 working days
VIC Rural: 2-4 working days
VIC Remote: 2-5 working days
WA Metro: 3-6 working days
WA Rural: 4-8 working days
WA Remote: 4-12 working days
Share This Book: