Design semantic models for scale in Microsoft Fabric

Module
8 Units

Intermediate

Data Analyst

Data Engineer

Microsoft Fabric

Power BI

Design semantic models for scale in Microsoft Fabric. Choose the right storage mode, design star schema relationships for clarity and performance, create scalable calculation patterns, and configure settings that support large datasets and concurrent consumption.

Learning objectives

By the end of this module, you'll be able to:

Choose a storage mode based on data freshness, performance, and source location.
Design star schema relationships for clarity and performance in a semantic model.
Design calculations that stay performant and maintainable as data volumes and team size grow.
Configure semantic model settings that support large-scale consumption.

Prerequisites

Understanding of data modeling concepts, including star schema, fact tables, and dimension tables.
Experience with Microsoft Fabric and Power BI.

Introduction min
Choose a storage mode min
Design star schema for semantic models min
Design scalable calculations min
Configure settings for scale min
Exercise: Design a semantic model for scale in Fabric min
Module assessment min
Summary min

Start