Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Gen AI | Contact Us | LBAG | Modern Data Model Course | info@zomalex.co.uk

Modern Data Modelling With Power BI - Review an existing semantic model

Inspect the Superstore semantic model and answer the following questions.

Describe the semantic model. Consider these aspects:

What design choices did the builder of this model make?

Does it meet best practices?

Are there any semantic model features that could usefully be added?

Which design is this model? Is it snowflake or star schema design or something different?

Identify the fact and dimension tables.

In what way, if any, does the model differ from a classic star schema pattern?

Specific questions about the relationships between tables in the model

  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 dimensions? 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?

Specific questions about how the model handles dates

  1. How does the model handle dates and time intelligence? Is this a good approach?
  2. What is a dates table? Why is it essential?
  3. Does this model contain a dates table?
  4. Are there any improvements you would like to make to the dates table?