Power to the user – Parameters part 2 – WHAT IF ANALYSIS

In my previous and first blog post about parameters I gave an introduction and an explanation about why parameters are useful and how we can use them, focusing on “threshold control”. Here the blog post about it.

In this second part, I am going to write about “What if analysis” using parameters. But first, let’s give a definition and explain the meaning of it!

What is a “What if analysis”?

It is the process of changing one (or more) variable value(s) – such as a factor, a constant – to see how those changes will affect the outcome. It is very useful to simulate different scenarios, whether positive or negative, in order to make decisions.

I will do a simple example of what if analysis with parameters in Tableau.

SALES FORECAST

I am using Sample Superstore.

I want to do a what if analysis on Sales by product subcategory.

  1. Let’s start to build a view showing sales by product sub-category as below:sales-by-sub-category
  2. Create a parameter and set the options as below:

Parameter_%_sales_forecast.PNG

[ This will generate a parameter that can vary between -100% (specified as -1) and 100% (as 1) with a step size of 5% (0.05). ]

3. You will need then to create a calculation to activate the parameter and generate the Sales Forecast field. The calculation will look like

[Sales]*(1+[Sales forecast % value])

Basically, when Sales forecast % value parameter will be set up at 0, this would means that Sales Forecast=Sales.

4. Now, drag Sales Forecast field on Sales axis and this will generate Measure Names and Measure Values. You will get the view below:

sales-forecast

5. To finish just a bit of formatting and clean up (for example, you could remove the grid lines and also hide the detail Sales, Sales Forecast on the left hand side that is quite repetitive and only keep the colour legend.

Below the final view:

What-if analysis.PNG

I hope you enjoyed this post!

 

Advertisements

2 thoughts on “Power to the user – Parameters part 2 – WHAT IF ANALYSIS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s