Design a data model in Power BI 

Intermediate
Data Analyst
Power BI
Microsoft Power Platform

The process of creating a complicated data model in Power BI is straightforward. If your data is coming in from more than one transactional system, before you know it, you can have dozens of tables that you have to work with. Building a great data model is about simplifying the disarray. A star schema is one way to simplify a data model, and you’ll learn about the terminology and implementation of them in this module. You will also learn about why choosing the correct data granularity is important for performance and usability of your Power BI reports. Finally, you’ll learn about improving performance with your Power BI data models.

Learning objectives

In this module, you will:

  • Create common date tables
  • Configure many-to-many relationships
  • Resolve circular relationships
  • Design star schemas

Prerequisites

None