Tag: Scenario Analysis

Running Sensitivity Analysis For Power BI Using DAX

Have you ever thought it would be nice to work out what the most optimal outcome is from your scenario analysis work that you’re doing inside of Power BI? In this tutorial, I show you exactly how you can discover this and also include sensitivity analysis techniques to your what-if parameter and scenario analysis work.

Continue reading

Multiple What If Parameters In Power BI

Do you want to see how advanced you can get with Power BI? In this tutorial, I want to show you my favourite way to use Power BI. You can do some amazing work around scenario analysis by integrating what if parameters in Power BI — things like sales, profits, or transactions. Not just because

Continue reading

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters

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

Power BI Analytics: Run Scenario Analysis On Average Order Size

In this tutorial, we dive into the power of Power BI analytics. I’m going to go through something quite practical for a retailer who sells goods at a high frequency. When you are a business that sells a lot of goods – say an online retailer – if you can analyse how much you would

Continue reading

Counting Customers Over Time Using DISTINCTCOUNT In Power BI

In this blog post, I’m going to run through how you can calculate how many customers you sell to through time using a few functions such as DISTINCTCOUNT inside of Power BI. There are actually a few ways you can calculate it, which is why I wanted to create a short tutorial on it to

Continue reading