Design a star or snowflake schema with fact and dimension tables, grain definition, slowly changing dimensions, and surrogate keys for analytics.
## CONTEXT I am building or refactoring an analytics data warehouse in 2026 and need a sound dimensional model. I will describe the business process to analyze, the metrics, the dimensions, and the source systems. I want a star (or selectively snowflaked) schema with a precise grain, well-designed fact and dimension…
Premium Prompt
Unlock this prompt — and all 25,000+ expert-crafted prompts — with Pro.
Unlock with Pro