Name: Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services
SKU: 57019873
Price: 2601.00 TWD
Availability: InStock
Author: Alberto Ferrari

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

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

Type

Physical Book

Author

Marco Russo

Alberto Ferrari

Publisher

Sqlbi Corp.

Language

English

Pages

818

Format

Paperback

Dimensions

23.5x19.1x4.1 cm

Weight

1.38 kg.

ISBN13

9781735365220

Edition No.

0002

Synopsis "Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services"

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 StudioUnderstand the DAX formula engine Learn characteristics of different storage engines (VertiPaq, DirectQuery over SQL)Read DAX query plansOptimize common DAX constructsSolve security performance issuesImprove DirectQuery response timeControl the data placement in composite models to avoid bottlenecksPrerequisites: proficiency in DAX and SQL (for DirectQuery), understanding of the Tabular engine used by semantic models, and familiarity with DAX Studio.

Marco Russo

(Author)

View Author's Page

Marco is a business intelligence consultant and mentor. He started working in Analysis Services in 1998, when Analysis Services was known as OLAP Services.

Marco, a veteran in comprehensive projects, wrote several books with Alberto Ferrari on Power BI, Analysis Service, and Power Pivot. They also regularly publish articles and technical papers, available at sqlbi.com. Marco is a Microsoft MVP and SSAS Master, the highest certification in Microsoft Analysis Services.

Currently, Marco dedicates his time to SQLBI clients, traveling extensively to train and provide consultancy on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.

Marco is a regular speaker at international conferences such as Microsoft Ignite, PASS Summit, and SQLbits. He also enjoys giving evening sessions at local user groups during his travels.

When not working, you can find Marco perfecting his Neapolitan pizza skills or testing electric cars.

See less

Alberto Ferrari

(Author)

View Author's Page

Alberto started working with SQL Server in 2000 and immediately became interested in business intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content on business intelligence

Alberto has published several books on Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and earned the SSAS Maestro title, the highest certification in Microsoft Analysis Services technology

Currently, Alberto focuses on delivering data modeling and DAX workshops for Power BI and Analysis Services worldwide. He offers consulting services on large and complex data warehouses for project analysis evaluation and validation or specific problem-solving

Alberto is a recognized speaker at numerous international conferences, such as PASS Summit, Sqlbits, and Microsoft Ignite. He loves participating in both large events and smaller user group meetings, exchanging ideas with other SQL and BI enthusiasts. When traveling for work, he enjoys interacting with local user groups to conduct evening sessions on his favorite topics. Therefore, you can easily meet Alberto by looking for local Power BI user groups during scheduled courses

Outside of SQLBI, Alberto spends most of his personal time playing video games, with the vain hope of eventually beating his son.

See less