Advanced Scenario Analysis Techniques For Power BI w/DAX

Review how to run simple and advanced scenario analysis techniques in Power BI. In this example we run through how you can dynamic 'shock' pricing and see how that impacts sales

*****Video Details*****
0:16 - Introduction
2:24 - Total Sales Using SUM vs Total Sales Using SUMX
4:20 - Creating A Supporting Table To Show Price Changes
5:42 - Harvesting The Price Change Percentage Selected
6:56 - Calculating Scenario Sales
7:52 - Showing All Sales Impact Of Selected Products
9:32 - Showing Results Of Selected Products
10:45 - Working Out The Master Calculation
12:37 - Branching Out Into More Measures
12:37 - Branching Out Into More Measures For More Insights
14:44 - Creating Compelling Visualizations To Showcase The Results
16:43 - Conclusion

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Using Multi-Layered Scenario Analysis in Power BI
https://blog.enterprisedna.co/layering-multiple-what-if-scenarios-using-dax-in-power-bi/
Scenario Analysis Techniques Using Multiple 'What If' Parameters
https://blog.enterprisedna.co/scenario-analysis-techniques-using-multiple-what-if-parameters-advanced-dax/
Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis
https://blog.enterprisedna.co/layering-multiple-what-if-parameters-for-advanced-analytics-in-power-bi/

***** Related Course Modules *****
Scenario Analysis Series
http://portal.enterprisedna.co/p/scenario-analysis-series
Solving Analytical Scenarios w/Power & DAX
http://portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax
Advanced Data Transformations & Modeling
http://portal.enterprisedna.co/p/advanced-data-transformation-and-modeling

***** Related Support Forums *****
Advice On Data Modeling
https://forum.enterprisedna.co/t/advice-on-data-modeling/4343
Data Modelling?
https://forum.enterprisedna.co/t/data-modelling/1296
Multiple Conditions Scenario Analysis
https://forum.enterprisedna.co/t/multiple-conditions-scenario-analysis/5576
For more data model queries to review see here…..
https://forum.enterprisedna.co/search?q=data%20model

Видео Advanced Scenario Analysis Techniques For Power BI w/DAX канала Enterprise DNA