Microsoft Fabric Analytics Engineer: Implement and Manage Semantic Models
Designing scalable and performant semantic models is one of the key requirements in enterprise-grade environments. This course will teach you how to implement and manage optimal semantic models to support efficient business decision-making.
What you'll learn
There is a huge difference between semantic models that just work and semantic models that work efficiently. In this course, Microsoft Fabric Analytics Engineer: Implement and Manage Semantic Models, you’ll learn to design optimal semantic models to support large enterprises. First, you’ll explore various data modeling concepts and techniques. Next, you’ll discover how to leverage different advanced concepts to enhance your semantic models. Finally, you’ll learn how to leverage external tools to improve the performance of semantic models. When you’re finished with this course, you’ll have a foundational understanding of advanced data modeling concepts and techniques in Microsoft Fabric that will enable you to design optimal enterprise-scale semantic models and get you ready for the DP-600 exam.
Table of contents
- Understanding Different Storage Modes for Power BI Semantic Models 3m
- Understanding Direct Lake Semantic Mode in Microsoft Fabric 5m
- Demo: Creating Direct Lake Semantic Model 3m
- Implementing a Star Schema for Semantic Model 2m
- Demo: Implementing a Star Schema with Power Query 4m
- Understanding Relationships in Semantic Models 4m
- Demo: Implementing Relationships in Semantic Models 5m
- Enhancing Semantic Model with DAX Variables and Iterator Functions 4m
- Enhancing Semantic Model with DAX Window and Information Functions 6m
- Implementing Calculation Groups 6m
- Implementing Field Parameters 6m
- Implementing Dynamic Format Strings 4m
- Designing a Large Format Semantic Model 6m
- Understanding Composite Models and Aggregations 6m
- Demo: Implementing and Managing Aggregations 9m
- Implementing and Validating Dynamic Row-level Security 6m
- Implementing and Validating Object-level Security 3m
- Implementing Performance Improvements in Queries and Report Visuals 4m
- Demo: Optimizing Performance of Report Visuals 2m
- Demo: Improving DAX Performance with DAX Studio 7m
- Demo: Optimizing a Semantic Model by Using Tabular Editor 4m
- Understanding Incremental Refresh 5m
- Demo: Implementing Incremental Refresh 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