Price-Volume-Mix variance analysis for Power BI and Excel

Webinar recording
Price-Volume-Mix Variance Analysis in Power BI and Excel

Join this session to see why is The Price-Volume-Mix (PVM) variance analysis an excellent tool that every analyst should add to his toolbox and see how to successfully implement it to add value to your dashboards and reports!

What's included

						
Full video recording

PBIX example used in the webinar

Step-by-step written instructions

Enjoy & thank you for watching! Don't hesitate to reach out if you have any questions — write to us at [email protected]!

Presenter

Andrej Lapajne

Founder & CEO at Zebra BI

Watch the Video

Get PBIX Example

Download the PBIX example we used at the webinar along with Excel calculations & the data file.

Access the materials

(0:00) - Introduction by Andrej Lapajne
(2:11) - Variance example
(3:32) - What exactly is Mix?
(7:21) - Webinar overview
(12:44) - PVM in Excel
(13:17) - Data requierments
(16:53) - The "Mix Change" method
(23:14) - Seperate Volume and Mix effects
(29:58) - Method #2
(38:52) - Small multiples
(41:18) - PVM in Power BI
(42:23) - PowerQuery (creating Products table).
(44:37) - Relationships view
(45:25) - Price variance
(47:41) - Volume variance
(48:20) - Mix variance
(49:09) - Unpivot measures
(52:21) - Q&A
(55:52) - Including profits into the analysis
(59:05) - Definitions
(1:06:01) - PVM and customers
(1:08:46) - Conclusion

Your Questions

Here are some of the questions that came up during our live session. Thank you for being such a proactive audience. Have more questions? Drop us a note at [email protected]!

Is it possible to include subtotals in waterfall charts?

Yes, you can definitely do that. Actually, it is very easy with the Zebra BI visual. Check the webinar recording to see exactly how to do it!

Is it possible to get profits into the analysis?

Absolutely. Watch how Andrej does it in the recording.

Prefer written step-by-step instructions?

Read the Article

Ready to start uncovering actionable insights from your data?

Explore Zebra BI for Office and Power BI, or start a trial instantly and test our tools on your data. You can also contact us to help you build your first test report and create a custom package for your business.

Try Zebra BI now

Contact sales

More Trending Webinars

Webinar

September 12, 2024

Master Cost Management: Elevate Reporting, Tracking, and Efficiency

Watch now

New

Power BI

Excel

PowerPoint

Webinar

September 12, 2024

Master Cost Management: Elevate Reporting, Tracking, and Efficiency

Master cost management with Zebra BI. Discover advanced techniques to optimize financial reporting, enhance budgeting accuracy, and make smarter, data-driven business decisions for long-term success.

Watch now

Power BI

Webinar

May 23, 2024

Mastering Brand and Product Portfolio Analysis in Power BI

Unlock the power of product portfolio analysis with Zebra BI in Power BI. Learn to visualize and analyze product performance, identify growth opportunities, and drive strategic business decisions with data-driven insights.

Watch now

Power BI

Webinar

April 18, 2024

Commentary Revolution: Transforming Power BI Dashboards with Dynamic Comments

Join our webinar to explore the easiest way so far to do dynamic commentary in Power BI for clearer insights, quicker decisions, and smoother meetings.

Watch now

New

PowerPoint

Webinar

October 26, 2023

How to create board meeting PowerPoint slide decks like a consultant in 2023

After gathering all the data you need it's time to present it effectively to your managers. And this doesn't mean using many different shapes and colors that tell nothing. Learn practical tips for a professional-looking and actionable PowerPoint slide deck.

Watch now

Power BI

Webinar

September 14, 2023

From Data to Decisions: Real-Life Fortune 500 Financial Analysis with Power BI

This webinar is all about financial analysis in Power BI. Take a look at the performance of some of the biggest Fortune 500 companies and use these practical examples to apply them to your data. Don't just create reports, generate insights.

Watch now

Browse All Resources

Trusted by