SaaS Revenue Analytics Platform
Analytics engineering stack for MRR, churn analysis, and cohort modeling.
Problem Statement
Finance and product teams lacked a unified definition of recurring revenue metrics.
Architecture Diagram
Billing Data→ELT Pipeline→dbt Models→Metrics Layer→Dashboards
Tech Stack
dbtPostgreSQLSnowflakeSQLBI Dashboards
Data Flow Explanation
Data Flow Explanation
Subscription, invoice, and customer activity records are normalized into conformed dimensions and fact tables. The metrics layer defines MRR, expansion, contraction, churn, and retention cohorts with clear lineage and testing.
Delivery Outcome
- Unified KPI definitions across teams.
- Reliable board-level reporting for monthly performance reviews.
- Faster insight cycles for pricing and retention experiments.
Screenshots
