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 fact and dimension tables that make BI queries fast and intuitive. Apply Kimball-style dimensional modeling adapted for a modern cloud warehouse in 2026, where storage is cheap and wide…
Premium Prompt
Unlock this prompt — and all 25,000+ expert-crafted prompts — with Pro.
Unlock with Pro