Design a star or snowflake schema for analytics use cases.
#dimensional-modeling
#star-schema
#warehouse
#analytics
Prompt
Design a dimensional model for this analytics domain.
Business process: [e.g. orders, subscriptions, ad spend]
Questions to answer:
[List 3-5 BI questions]
Source systems:
[List systems]
Deliver:
1. Fact table(s) with grain and measures
2. Dimension tables with key attributes and SCD type recommendations
3. Surrogate key strategy
4. Example star-schema diagram in text/mermaid
5. Sample SQL for one core mart query
6. Trade-offs vs a wide denormalized table
Customize
Fill Variables
Details
Model
Claude 3
Category
Data Engineering
Added On
Jun 10, 2025
Prompts are starting points. Review outputs before using them in production.