Optimize Model Performance with Power BI
Creating a Power BI report may look like an easy task, but there is a huge difference between the report that works and the report that works efficiently! This course will teach you how to optimize model performance and build efficient solutions.
What you'll learn
Congratulations! You've built your beautiful Power BI report and your charts look terrific. But, your data refresh takes forever. Or, your report renders slow when interacting with visuals.
In this course, Optimize Model Performance with Power BI, you’ll gain the ability to improve the efficiency of your Power BI reporting solution. First, 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 DA-100 exam.
Table of contents
- Understanding Cardinality 4m
- Demo: Identifying Column Cardinality with DAX Studio 3m
- Improving Cardinality Levels by Changing Data Types 3m
- Demo: Improving Cardinality Levels by Changing Data Types 2m
- Improving Cardinality Levels through Summarization 2m
- Demo: Improving Cardinality Levels through Summarization 4m
About the author
Nikola Ilic is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI - but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed "Data-Mozart". As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer's last name as part of his nickname. That'... more