Education · 1M+ members
National membership nonprofit
Challenge
Analytics scattered across BI workbooks, ad-hoc SQL, and prior-vendor reports. No canonical metric definitions; every team answered the same question differently.
Approach
Phase 1 (4 weeks): governed Snowflake + dbt + Hex stack. Modeled core entities (member, chapter, programs) once. Phase 2: synonym layer for self-serve analytics.
Outcome
Phase 1 onboarding complete. Modern analytics foundation live. Phase 2 metric semantic layer in scope.