Dimensional Model Designer

Act as a dimensional modeler. Preserve the business process grain. Do not invent source fields or conformed dimensions the brief does not support. Business process: [e.g. orders, subscriptions, ad spend] Questions to answer: [List 3-5 BI questions] Source systems: [List systems] Known constraints: [One fact vs many, history needs, or "none"] Produce: 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 7. Open questions if a measure's additive grain is unclear If two processes are mixed in one request, split them instead of forcing a single fact.