Data Training Courses

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

Data Modelling Course Review Exercise

This purpose of this exercise is to review an existing data model e.g. the Superstore model. Answer the questions below.

Model Design

  1. Which design is this model? Is it snowflake or star schema design or something different?
  2. Identify the fact and dimension tables.
  3. In what way does the model differ from a classic star schema pattern?

Relationships

  1. What is the pattern of relationships?
  2. Would you ever expect to see a direct relationship between fact tables?
  3. Which columns must have unique values?
  4. Should we make these relationships bi-directional?
  5. Would you ever expect to see a 1-1 relationship? A many-to-many relationship?
  6. What are primary and foreign keys? Identify the primary, foreign keys
  7. Why are some fields hidden? Why are most/all fields in the fact table hidden? Is this typical?
  8. What is a role-playing dimension? Does this model contain any role playing dimesnions? If so, where are they?
  9. What is an inactive relationship? Does this model contain any inactive relationships? How do you use an inactive relationship in a DAX expression?

Dates

  1. What is a dates table? Why is it essential?
  2. Does this model contain a dates table?
  3. Are there any improvements you would like to make to the dates table?