Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services (color)

— —

Alberto Ferrari Marco Russo

Optimizing DAX

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

Alberto Ferrari, Marco Russo

$212.95 $169.98

Hardback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Sqlbi Corp.
30 April 2024

Data capture & analysis; Data mining; Database software

Summary
Details

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.

By: Alberto Ferrari, Marco Russo
Imprint: Sqlbi Corp.
Edition: 2nd ed.
Dimensions: Height: 235mm, Width: 191mm, Spine: 43mm
Weight: 1.601kg
ISBN: 9781735365244
ISBN 10: 1735365246
Pages: 818
Publication Date: 30 April 2024
Audience: General/trade , ELT Advanced
Format: Hardback
Publisher's Status: Active