Microsoft Fabric: Getting Started with Semantic Models

Microsoft Fabric    |    Intermediate
  • 14 videos | 2h 1m 33s
  • Includes Assessment
  • Earns a Badge
Semantic models in Fabric empower organizations to organize, analyze, and derive meaningful insights from complex data. They enable efficient data structuring, seamless integration, and optimized performance. In this course, learn the fundamentals of Fabric semantic models, including how to work with them, their structure and components, and the different storage modes. Next, discover how relationships in semantic models connect data and enable meaningful insights, how to store data using normalized or denormalized schemas, and star and snowflake schemas. Finally, discover how to create fact and dimension tables, model a star schema structure in Fabric, manage slowly changing dimensions to track historical changes, and create hierarchies. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify the use cases and components of semantic models in fabric
    Recognize how to connect to and work with semantic models
    Differentiate between the import and directquery storage modes
    Describe the advantages and limitations of the direct lake and composite storage modes
    Recognize how relationships in semantic models define connections between tables
    Outline how to implement the star schema with fact and dimension tables
  • Identify the differences between normalized and denormalized data structures
    Differentiate between the star schema and snowflake schema
    Create fact and dimension tables in a warehouse
    Create a semantic model with relationships and measures to model a star schema
    Outline the different types of slowly changing dimensions (scds)
    Create hierarchies in semantic models
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 39s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 8m 25s
    Upon completion of this video, you will be able to identify the use cases and components of semantic models in Fabric. FREE ACCESS
  • Locked
    3.  Working with Semantic Models
    6m 15s
    Through this video, you will be able to recognize how to connect to and work with semantic models. FREE ACCESS
  • Locked
    4.  Import and DirectQuery Storage Modes
    12m 17s
    After completing this video, you will be able to differentiate between the Import and DirectQuery storage modes. FREE ACCESS
  • Locked
    5.  Direct Lake and Composite Storage Modes
    11m 52s
    In this video, we will describe the advantages and limitations of the Direct Lake and Composite storage modes. FREE ACCESS
  • Locked
    6.  Table Relationships in Semantic Models
    11m 42s
    Through this video, you will be able to recognize how relationships in semantic models define connections between tables. FREE ACCESS
  • Locked
    7.  The Star Schema
    11m 38s
    Upon completion of this video, you will be able to outline how to implement the star schema with fact and dimension tables. FREE ACCESS
  • Locked
    8.  Normalized and Denormalized Data
    7m 34s
    After completing this video, you will be able to identify the differences between normalized and denormalized data structures. FREE ACCESS
  • Locked
    9.  Star Schema vs. Snowflake Schema
    5m 53s
    In this video, we will differentiate between the star schema and snowflake schema. FREE ACCESS
  • Locked
    10.  Creating Fact and Dimension Tables
    9m 48s
    Learn how to create fact and dimension tables in a warehouse. FREE ACCESS
  • Locked
    11.  Setting Up Semantic Modeling of a Star Schema
    11m 35s
    In this video, find out how to create a semantic model with relationships and measures to model a star schema. FREE ACCESS
  • Locked
    12.  Slowly Changing Dimensions (SCDs)
    8m 4s
    Upon completion of this video, you will be able to outline the different types of slowly changing dimensions (SCDs). FREE ACCESS
  • Locked
    13.  Creating Hierarchies in Models
    12m 45s
    During this video, discover how to create hierarchies in semantic models. FREE ACCESS
  • Locked
    14.  Course Summary
    2m 7s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Emerging Data Trends: Unveiling the Power of Practical Data Fabric
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Mastering Microsoft Fabric: SAASification of Analytics
Course Microsoft Fabric: Introducing Data Warehouses
Rating 4.8 of 5 users Rating 4.8 of 5 users (5)