One single source of truth for revenue
Three teams were reporting different revenue numbers for the same question. The work was to model until only one right answer was left.
Problem
Finance, growth, and product each calculated “monthly revenue” in subtly different ways — parallel spreadsheets, manual joins, different rounding. Every meeting started with ten minutes spent agreeing on whose number was correct.
Approach
Dimensional modeling from scratch in dbt: one staging layer per source, a single fact model for revenue with documented business rules, and automated tests covering cases that had silently broken before.
- Reconciliation between teams
- from days to minutes
- Divergent revenue sources
- 3 → 1
- Test coverage on the fact model
- 100%