0% Complete

Data Modelling: Star and Snowflake Schema

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.