Beskrivning

Background

• This course will teach you how to optimize model performance and build efficient solutions.
• You’ll gain the ability to improve the efficiency of your Power BI reporting solution.
• You’ll explore how to reduce the data model size by removing unnecessary columns and rows.
• Next, you’ll discover the importance of the column cardinality and how it can affect data model performance. You’ll also understand the benefits of using aggregation features to make things running faster.
• Finally, you’ll learn how to identify and resolve poorly performing report elements, such as measures and visuals.
• When you’re finished with this course, you’ll have the foundational understanding of data model optimization techniques that will enable you to build more efficient Power BI solutions, and get you ready for the new PL-300 exam.

Audience

This training is for professional data analysts and BI specialists who want to improve their knowledge of tuning, optimizing and design Power BI data models that delivers excellent

Prerequisites

Experience with Power BI.

Course Topics

• Understand Core Concepts of Performance Optimization
• Optimize Data Model Performance by Improving Cardinality Levels
• Optimize DAX Functions
• Understanding, Creating and managing Aggregations
• Identify Poorly Performing Report Elements
• 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.

Kursen levereras i samarbete med

Kontakta oss om denna kurs