Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
09-05-2017 15:17 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;
Marketing activities
Promotional insights
Inventory management
Sales forecasting
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/
Chrs
Sam McKay, CFA
Founder, Enterprise DNA
eyJrIjoiMzZlMDE2ZmEtM2Y4ZC00ODgxLWJjODEtZGY4ZmQ1NGM4NzA0IiwidCI6ImJkM2ZjNmFlLWE0NTUtNGFlYS1hM2RiLTI4NzlkMjI1MzM4NiIsImMiOjEwfQ
ddd
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.
Awesome report Sam.. It certainly gets my vote.
Great, thanks
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
Thanks Henk, that's great.
Great Report, My vote for you, Where can i downlaod this PBIx file from ?
Regards
Sohail
Please review the description
Thansk Registred 🙂