Optimize Enterprise-scale Data Models - DP-500
This course will teach you how to design optimal enterprise-scale data models to support efficient business decision-making.
What you'll learn
You’ve built an enterprise data solution and now struggling with performance. In this course, Optimize Enterprise-scale Data Models - DP-500, you’ll learn to design optimal data models to support large enterprises. First, you’ll explore various areas for performance improvement. Next, you’ll discover how to leverage different external tools to fine-tune your data model. Finally, you’ll learn how to apply some advanced concepts, such as incremental refresh and denormalization. When you’re finished with this course, you’ll have a foundational understanding of performance optimization in Power BI that will enable you to design optimal enterprise-scale data models and get you ready for the DP-500 exam.
Table of contents
- Identifying Performance Bottlenecks in Data Model 3m
- Identifying Bottlenecks in Queries and Visualizations 3m
- Demo: Performance Analyzer 2m
- Demo: Performance Optimization Techniques for Report Visuals 3m
- Understanding External Tools in Power BI 2m
- Demo: Troubleshooting DAX Performance with DAX Studio 8m
- Summary 1m
- Understanding XMLA Endpoint 6m
- Demo: Optimizing Data Model by Using Tabular Editor 2 6m
- Understanding Cardinality 3m
- Demo: Identifying Column Cardinality with VertiPaq Analyzer 3m
- Improving Cardinality Levels through Summarization 2m
- Demo: Improving Cardinality Levels through Summarization 3m
- Summary 2m
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