From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Create fact tables and dimension tables

Create fact tables and dimension tables - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Create fact tables and dimension tables

“

- [Instructor] In this sub lesson, we are going to create fact tables and dimension tables. Alright, so what is dimensional modeling? It is a data modeling methodology that centers around measuring business processes. The business processes are known as facts. And when we measure business processes, we need ways to describe those measurements. Dimensions are used as report labels and/or filters. And the combination of facts and dimensions is known as a star schema or a dimensional model. Okay, so here is an example of a star schema. So in the middle of the star schema is our fact table. So this contains the items are trying to measure sum, average, min, max, or count, and the tables around the edges are our dimension tables. And those are different ways that we're going to use to describe those measurements in our fact tables. In this case here, this is referred to as a star schema because there's only one table out from the fact table. To contrast that, let's go ahead and show you…

Contents