Revenue Intelligence Dashboard
Executive view of sales, margin, and growth by market and SKU.
YoY growth
Top movers
Margin bridge
Problem
Leaders lacked a unified view of sales and profitability. Definitions drifted, reports conflicted, and decisions slowed.
Data and Sourcing
- ERP, CRM, and eCommerce exports unified in a conformed metric layer
- Power Query / dbt or SQL transforms with versioned definitions
- Cohort and retention tables for churn and LTV analysis
Approach
- Metric layer with clear ownership and semantic consistency
- Cohort analysis, LTV modeling, and time-intelligence measures
- Attribution views to compare channels and campaigns
Results and Impact
- Faster reviews and earlier trend detection
- Clarity on channel performance and CAC payback
- Consistent numbers across stakeholders
What I Did
- Designed the executive dashboard and metric layer
- Defined cohorts, churn, and margin metrics
- Implemented checks for data freshness and schema drift
Stack
Power BI
DAX
Power Query
SQL
Python
Postgres
BigQuery