Optimize a model for performance in Power BI 

Intermediate
Data Analyst
Power BI
Power Platform

Data Analysis eXpression (DAX) language is a key feature of Power BI. It is used to create calculated columns, calculated tables, and measures. In this module, you will learn how to use DAX to solve typical analytics problems. You will learn about one of the most popular DAX functions, CALCULATE, and how it can override the default behavior of Power BI.

Learning objectives

By the end of this module, you will be able to:

  • Review the performance of measures, relationships, and visuals.
  • Use variables to improve performance and troubleshooting.
  • Improve performance by reducing cardinality levels.
  • Optimize DirectQuery models with table level storage.
  • Create and manage aggregations.

Prerequisites

None