The process of creating a complicated semantic 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 semantic model is about simplifying the disarray. A star schema is one way to simplify a semantic model, and you 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 learn about improving performance with your Power BI semantic models.
In this module, you will:
- Create common date tables
- Configure many-to-many relationships
- Resolve circular relationships
- Design star schemas