Best practice for comparing census data for locations of customers

[BrianJ]

@ahmed9s,

As a supplement to @Greg’s excellent response above, you may want to take a look at the thread below which has some good information about the pros and cons of snowflake vs. star schemas.

• Brian

When to create a dimension and not

@Frede, Your question is probably the most debated issue in data modeling - snowflake (your top configuration) vs. star schema (your bottom configuration). Here’s a good summary table of the pros and cons of each: My personal view is to stick with star schema when at all possible. It makes for a simpler data model, and makes DAX easier to write and debug. But I don’t often work with really large datasets, where the denormalization in a star schema would be a bigger issue. I hope this i…