I really wanted to showcase here how incredible Power BI is as an analytical tool. You can achieve so much that you might never have thought possible. Developing scenario analysis logic within Power BI models is probably my favorite technique to use, mainly because it can be so valuable to the business.
Rather than just looking backward and reporting on historical information, what you can do with scenario analysis is almost predict the future. You can pull levers in your metrics and across your data and see how it impacts the final results. The opportunities become endless!
Almost any dataset that looks to explore information over time can use this technique or a form of the techniques that I go through in the video.
I also go into measure branching, how to use parameter tables, how to insert variables into measures, and much more.
This is quite advanced but very achievable. It just takes a lot of practice and also really putting your mind into your data, and thinking hard about the sort of insights you want to test around your future results. Try to identify the variables sitting in your datasets or calculations that you could ‘shock’ or tweak to review their impact on your underlying performance.
Good luck with this one. Be sure to try to get some of these techniques into your models so you embed the concepts in your mind and take them even further.