Nccnsg5gqv8dletwax6s
SkillsCast

DAX Optimization Examples - Level 400

14th March 2019 in London at CodeNode

This SkillsCast was filmed at Power BI March Meetup

How do you optimize a DAX expression? In this session we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them. As you will see, most optimizations are the direct application of best practices, but the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and the improvement you might expect from learning how to optimize the model and the code.

YOU MAY ALSO LIKE:

Thanks to our sponsors

DAX Optimization Examples - Level 400

Alberto Ferrari

Alberto started working with SQL Server in 2000 and immediately focused his interest in the Business Intelligence area. He and Marco Russo created the sqlbi.com, where they publish their thoughts and topics about BI. He published several books about SSAS Tavìbular, Multidimensional and Power Pivot. He is a Microsoft MVP and he achieved the SSAS Maestro title, the highest level of certification on Microsoft SSAS technology.

SkillsCast

How do you optimize a DAX expression? In this session we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them. As you will see, most optimizations are the direct application of best practices, but the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and the improvement you might expect from learning how to optimize the model and the code.

YOU MAY ALSO LIKE:

Thanks to our sponsors

About the Speaker

DAX Optimization Examples - Level 400

Alberto Ferrari

Alberto started working with SQL Server in 2000 and immediately focused his interest in the Business Intelligence area. He and Marco Russo created the sqlbi.com, where they publish their thoughts and topics about BI. He published several books about SSAS Tavìbular, Multidimensional and Power Pivot. He is a Microsoft MVP and he achieved the SSAS Maestro title, the highest level of certification on Microsoft SSAS technology.