Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (1.6k points)
edited by
What if analysis in tableau?

1 Answer

0 votes
by (3.1k points)

 What-if analysis is used to see the changes that we make in parameters affects the data. That means in What-if analysis if you propose any hypothetical scenario and want to see how it will affect the outcome of your business. For example if you want to see the how much will my profit increase or decrease if I stop doing the business with the customers where I am not getting any profit.

Step 1: Find the customers who has profit<0

 

Step 2: Create a line graph to show profit per year, segregate the profitable and non-profitable customers. And hide the non-profitable customer line.

Step 3: find the total profit (both profitable and non-profitable customers) and do the below calculation.

Step 4: Create the synchronized, dual-axis line chart by using the above calculation.

 

So as you can see there is increment in profit if we stop doing the business with the unprofitable customers or who has profit value less than zero.

 

You can check tableau training for more details.

Browse Categories

...