- Course
- Data
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
About the author
Nikola has multi-year experience working with various flavors of data, predominantly with Microsoft BI stack. Started with SQL Server, then brushed himself with SSAS Multidimensional, SSIS, SSRS, Power BI, Azure, etc. Nikola is really curious by nature and always trying to learn something new.