Every Power BI user should be familiar with the star schema concept and its application. However, for analysts who are not data engineers, implementing this concept might seem challenging.

In this session, I will introduce the theory of the star schema (also known as Dimensional Modeling) and demonstrate its application in real-world scenarios.

I will utilize Power Query to achieve the following:

- Create a Sales Fact table by combining Order header and Order details, incorporating facts and IDs to Dimension tables.
- Appropriately allocate Order Freight amounts from the Order table to their respective detail lines, addressing granularity issues.
- Develop a bridge table to resolve many-to-many relationship challenges.

If there is time, I will show you how to manage historical data by creating a Customer Dimension table with surrogate keys, implementing both SCD0 and SCD2 methods.

I'll be using a publicly accessible ODATA version of the Northwind traders database as my source system for transactions.