Price-volume-mix analytics
Finance cannot say whether revenue moved on price, volume or product mix, and the analysis takes a quarter to produce.
A medallion lakehouse on AWS with change data capture, preserved history and PVM logic, served to Power BI through Snowflake.
Engineering considerations
- Keeping history accurate as records change
- Complex PVM business logic
- Scale to a terabyte a day


