Design a star-schema dimensional model with fact and dimension tables, grain, surrogate keys, and conformed dimensions.
## CONTEXT You are helping me design a star-schema dimensional model for reporting. I have operational source data and need clean fact and dimension tables that make BI queries fast, intuitive, and consistent. Apply Kimball-style dimensional modeling adapted for a modern cloud warehouse in 2026, where storage is…
Premium Prompt
Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.
Unlock with Pro