back

0% Complete

Contents
Data Modelling: Star and Snowflake Schema

Prev Next
Data Modelling: Star and Snowflake Schema

Topics covered in this session,

  1. What is star schema? → https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
  2. What is the snowflake schema? → https://docs.microsoft.com/en-us/power-bi/guidance/star-schema#snowflake-dimensions
  3. Query Folding →https://docs.microsoft.com/en-us/power-query/power-query-folding
  4. Connect fact and dimension tables. This is also called data modelling
  5. What is one to one and one to many relationship?
  6. Why many to many relationship should be avoided? https://docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many#:~:text=Generally%2C we don't recommend, the Order table OrderID column.