Category: Scenario Analysis

New Course Release – Scenario Analysis Deep Dive

You can view details about this latest course release here – Scenario Analysis Deep Dive If you want an overview of what you can achieve with scenario analysis, you can here – Scenario Analysis intro Another month and another course release into Enterprise DNA Online. As many of you already know I’m a huge fan

Continue reading

Multiple ‘What If’ Parameter Handling In Power BI

Do you want to see how advanced you can get with Power BI? I want to show you here what would most likely be my favourite way to use Power BI. Not just because of what insights you can find, but also the ease of which you can implement this analysis compared to what it

Continue reading

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters – Advanced DAX

Power BI is an incredible tool to run scenario analysis and what-if analysis examples. I’ve actually never seen or come across an analytical tool that is as effective and intuitive to implement this type of complex analytics. The key is that you’ve got to think more analytically about the underlying elements in your datasets than

Continue reading

Developing Sensitivity Analysis Logic Using DAX in Power BI

We’re getting specific today and really showcasing the analytical power of Power BI. Sensitivity analysis, or even running some ‘what ifs’ around this, allows you to almost predict what may happen in the future with your results. In this example I want to see what will happen to my profitability if I am able to

Continue reading