Turn Events Into a Star Schema
Design a simple star schema by declaring fact grain and dimension context.
Raw signup events need to become a reliable marketing conversion model across channel, plan, country, and week. Declare fact grain first; then attach dimensions that describe that grain. The common trap is building dashboards straight from raw event JSON. Each dashboard then becomes its own hidden model of channel, country, and plan. Declare grain fact_signup has one row per completed signup event. This makes counts additive. Every row contributes exactly one signup, and the table does not mix events with snapshots or account states. Identify measures signup_count = 1, trial_started flag, initial_mrr if available at signup time. Measures belong in…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in