AutoPVM project aims at conducting the Price Variance Mix analysis automatically. The main purpose of PVM analysis is to provide a high-level overview view into the past, and to break down the change in revenue or margins into some key components or categories.
polars price by volume extension
dbt models on DuckDB that decompose a budget-to-actual revenue variance into price, volume, and mix effects that sum to the total exactly, with the tie-out enforced as a dbt test. Outputs a tidy waterfall and ranked drivers for BI.
Production Power BI report decomposing YoY sales into Price-Volume-Mix drivers, diagnosing root causes by category/customer/salesperson, and tracking sales quality vs budget. Built on SAP HANA with dynamic DAX text cards that auto-generate plain-English summaries.
Margin and mix bridge: SKU/channel contribution, price-volume-mix, and gross margin walk. Sample Excel file.
To associate your repository with the price-volume-mix topic, visit your repo's landing page and select "manage topics."