DATA-MODELING5 MIN READ
Should You Snowflake the Product Hierarchy?
Decide when a snowflaked product hierarchy is warranted and when a flat dimension is the better serving design.
You are designing a product dimension for sales analytics. Brand, category, and subcategory change rarely and analysts query them constantly. What is the strongest move?
Read the full lesson
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in