Tag: Scenario Analysis

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

Enterprise DNA Learning Summit – Session 3 Preview

Two sessions been and gone, with one more to go. The final session of the Enterprise DNA Learning Summit is tomorrow. Big thank you to everyone who has been involved. Have covered an immense amount about Power BI already with more to come tomorrow. Today we went through a wide array of analytical techniques inside

Continue reading

Layering Multiple ‘What If’ Scenarios Using DAX in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading