What you'll learn

Organizations rely on clean, efficient, and high-performing data models to deliver accurate insights. Many Power BI users struggle with structuring their data, writing effective calculations, and ensuring models perform at scale.

In this course, Microsoft Power BI Data Analyst (PL-300): Model the Data, you’ll gain the ability to design, implement, and optimize high-quality data models in Power BI.

First, you’ll explore how to design and implement a relational data model, including creating fact and dimension tables, defining relationships, and implementing role-playing dimensions.

Next, you’ll discover how to create model calculations with DAX, from basic aggregations to advanced time intelligence.

Finally, you’ll learn how to optimize model performance by reducing unnecessary data, diagnosing bottlenecks, and applying performance tuning.

When you’re finished with this course, you’ll have the skills and knowledge of Power BI data modeling needed to build scalable, high-performing models — and to succeed on the ‘Model the Data’ section of the PL-300 certification exam.