22-25 April 2026 
Peter ter Braake
Peter ter Braake is SQL Server MVP and MCT. He works as an independent contracter alternating his time between teaching SQL Server related courses and doing projects at customers.
Video unavailable
SQLBits 2026
Dimensional modelling for Fabric and Power BI
This session teaches you to create the best possible star schema for your Power BI reports and Fabric Semantic models. Everyone creating star schema data models will benefit from this session.
Dimensional modelling is at the heart of Power BI and Fabric Semantic models. Most people who work with Power BI or who build Fabric Semantic models know this. We have facts and dimensions, but often we do not get them right. Without proper facts and dimensions, our models and calculations become unnecessarily complex.
In this session we will discuss the steps to create a proper star schema. Starting with Kimball theory we explain facts and dimensions with lots of real-world examples.
This session is for everyone who creates star schema data models, whether in Fabric warehouse, Fabric Semantic models or Power BI. You will learn to create an optimal data model that keeps your DAX and SQL queries as simple as possible and optimizes your report performance.
After this session you will never wonder again about which the tables you need for your solution and where columns should be stored. You will be able to create simple, intuitive, yet powerful, star schema data models.
In this session we will discuss the steps to create a proper star schema. Starting with Kimball theory we explain facts and dimensions with lots of real-world examples.
This session is for everyone who creates star schema data models, whether in Fabric warehouse, Fabric Semantic models or Power BI. You will learn to create an optimal data model that keeps your DAX and SQL queries as simple as possible and optimizes your report performance.
After this session you will never wonder again about which the tables you need for your solution and where columns should be stored. You will be able to create simple, intuitive, yet powerful, star schema data models.