08-25-2017 22:37 PM
Running product discounting scenarios across your entire retail business.
First select any time frame and any region to set up the modelling scenario.
Then run dynamic scenarios (using the new what if functionality) based on which products you want to discount and then potential follow up demand to your stores & sales that could be created.
Immense amount of opportunities and possibilities to analyse.
To be used with for;
and much more.
The simple dashboard design sits on top of quite complex logic..where you need to isolate the products you are discounting versus the ones you are not. Really showcases the incredible analytical power of using DAX within Power BI.
I will be running a webinar on how this was built. You can sign up for the webinar here - https://enterprisedna.lpages.co/scenario-analysis-patterns-webinar-registration-page/
Sam McKay, CFA
Founder, Enterprise DNA
Great content from you Sam, keep up the good work. Your work is really inspiring, when i grow up i want to be like you ;).
Thanks for the courses you set up enjoyed them a lot.
Great report. I really like how you explane things, and I enjoyed your courses. I learned a lot even though I've been working with Power BI for the last 2 years.
Kind regards Henk Hoogewerff