Design and manage semantic models in Microsoft Fabric

  • Learning Path
  • 5 Modules

At a glance

Create semantic models that serve reliable, governed analytics at scale — from initial DAX logic through performance optimization, data access control, and automated lifecycle management.

Prerequisites

  • Experience building reports in Power BI
  • Familiarity with DAX syntax including measures and calculated columns
  • Understanding of dimensional data modeling design concepts

Modules in this learning path

Create DAX calculations in semantic models

Adding DAX calculations to Power BI semantic models allows you to define custom logic within your data model, to enable deeper analysis and data-driven business decisions.

Design semantic models for scale in Microsoft Fabric

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.

Optimize semantic model performance

Diagnose and fix semantic model and report performance issues. Use Performance analyzer to identify bottlenecks, optimize DAX calculations, reduce cardinality, and implement aggregations to improve query speed.

Enforce semantic model security

Implement row-level security (RLS), object-level security (OLS), and dynamic security patterns to protect sensitive data in semantic models while enabling appropriate access for different user groups.

Manage the semantic model development lifecycle

Manage semantic models through their full development lifecycle. Create reusable assets, version-control with Git, inspect and validate with the XMLA endpoint and SemPy, deploy through pipelines, and maintain with monitoring and impact analysis.

Start