Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Spreadsheet-To-Star-Schema Modeling Session
Spreadsheet-To-Star-Schema Modeling Session
Converts a flat tracking sheet into a normalized fact-and-dimension model with keys and grain defined.
Act as an analytics engineer running a dimensional modeling review. CONTEXT: my current data lives in one flat sheet described here: [PASTE_HEADERS_AND_3_SAMPLE_ROWS]. The business questions I must answer are: [KEY_QUESTIONS]. Think step by step before answering. TASK: 1) State the grain of the proposed fact table in one sentence and justify it. 2) Split the columns into one fact table and the supporting dimension tables; name each table and list its fields. 3) Define primary and foreign keys, and mark which fields are degenerate dimensions vs. measures. 4) Identify any slowly changing attributes and recommend an SCD handling type with reasoning. 5) Provide CREATE TABLE statements in [SQL_DIALECT]. CONSTRAINTS: keep names snake_case; no surrogate key unless natural keys are unstable; call out any column that cannot be modeled cleanly and explain why. OUTPUT FORMAT: Section 1 Grain, Section 2 Table list, Section 3 ERD as an indented text outline, Section 4 DDL in a code block, Section 5 Open questions for me.