DP-600: Designing and building Robust Semantic Models in Microsoft Fabric (Video 7 of 10)

Показать описание

In this video, we dive deep into designing and building semantic models in Microsoft Fabric, a critical step for creating effective, high-performance data analysis solutions.

Google classroom community:

We explore essential elements like storage modes along with star schema implementation and setting up complex relationships. You’ll also learn how to write efficient DAX calculations using variables, iterators, and filters.

Highlights:
Choosing storage modes, including Direct Lake
Implementing a star schema with bridge tables and many-to-many relationships
Writing efficient DAX calculations with variables, iterators, and filtering
Implementing calculation groups, dynamic format strings, and field parameters
Best practices for large-format semantic models and composite models

Agenda: Video 7
00:00 Module 3 - Implement and manage semantic models - Overview and Course Roadmap
01:34 Agenda for this video
02:48 Semantic models storage modes matrix
08:43 Star schema implementation in COVID 19 data model
16:15 DAX Variables and functions - Concept and DEMO in COVID 19 Data model
31:44 Implement calculation groups, dynamic strings, and field parameters. - DEMO in COVID 19 data model
42:07 Composite models concept
43:39 Identify use cases for and configure large semantic model storage format
45:51 Summary

#DP600 #microsoftfabric