Category: Variance Analysis

May 11, 2026
Price Volume Mix (PVM) Analysis in Excel: Step-by-Step Guide with Formulas & Examples
Learn how to do price volume mix (PVM) analysis in Excel with step-by-step formulas, a real example, and a free downloadable template.
October 29, 2025
Power BI Variance Analysis: What It Is and How to Get Started 
Variance analysis in Power BI can help you gain a better understanding of your financial data. Here's how to do it as effectively as possible.
November 30, 2022
Your ultimate guide to Price Volume Mix analysis in Power BI 
Find out how to perform a Price Volume Mix Analysis in Power BI to see how price, volume and product mix changes affect your revenue.
October 19, 2022
Cost Variance Table in Excel (PY-AC-FC-PL)
Next-level visualization of different costs with three comparison measures in one table: the previous year (PY), forecast (FC), and plan (PL). Add dynamic comments for more insights.
October 19, 2022
Cost Variance Table in Excel (PY-AC-PL)
Display different costs with absolute and relative variance. Compare the actual (AC) value with the previous year (PY) and plan (PL) in the same table and add dynamic comments for more insights.
October 19, 2022
Cost Variance Table in Excel (PY-AC and AC-PL)
Show different costs compared to the previous year or plan. Use custom calculations or not, display dynamic comments, and visualize variances for more insights.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (PY-AC-FC-PL)
The most advanced template for monthly sales variance report featuring 3 comparisons in the same waterfall or column chart: previous year, forecast, and plan compared to the actual value.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (AC-FC-PL)
On one page you can compare the actual (AC) sales performance over months to the plan (PL) and forecast (FC) with Zebra BI Charts. Automatically calculated variances are also visualized together with dynamic comments for more insights.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (AC-PY-PL)
On one page you can compare the actual (AC) sales performance over months to the plan (PL) and previous year (PY) with Zebra BI Charts. Automatically calculated variances are also visualized together with dynamic comments for more insights.