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.
finance sql forecasting dbt financial-analysis data-modeling data-quality variance-analysis analytics-engineering duckdb price-volume-mix fp-and-a
-
Updated
Jul 28, 2026 - SQL