Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Implement Scenario Analysis in Tableau

Cody Schneider••6 min read

Thinking about the future of your business shouldn't be a shot in the dark. With scenario analysis in Tableau, you can transform your static dashboards into interactive, forward-looking tools that model potential outcomes of your decisions. This article will show you exactly how to build a what-if analysis in Tableau using parameters and calculated fields to test different assumptions and see their impact on your data instantly.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

What is Scenario Analysis?

Scenario analysis is a powerful technique for understanding the potential impact of different variables on your business outcomes. Instead of just looking at historical data - what has happened - you can create interactive models to see what could happen if certain conditions change. For example, you could model:

  • How a 15% increase in marketing spend might affect new sign-ups.
  • How a 5% price drop could impact overall revenue and profit margins.
  • How hitting 80% versus 110% of your sales quota changes team commissions.

In Tableau, this isn't a static report, it’s a dynamic dashboard where you can use a slider or dropdown to change a variable and watch your charts update in real-time. This turns your dashboard from a simple reporting tool into a strategic planning powerhouse.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

The Building Blocks: Parameters and Calculated Fields

To build a "what-if" model in Tableau, you only need two key features: Parameters and Calculated Fields. Here’s what they are and how they work together:

  • Parameters: Think of a parameter as a variable that you, the user, can control. It's a placeholder value - like a number, percentage, or text - that isn't part of your original data source. You can create a slider, a dropdown list, or a text box that allows you or your audience to input a value directly into the dashboard.
  • Calculated Fields: This is where the logic lives. A calculated field is a formula that takes the value from your parameter and uses it to modify your existing data. For example, a calculated field could take your Sales Revenue measure and multiply it by a "Sales Lift %" parameter to calculate a Projected Revenue.

When you change the parameter's value, the calculated field instantly recomputes, which then updates your entire visualization. This dynamic connection is what makes scenario analysis possible in Tableau.

Step-by-Step Guide: Modeling a Change in Customer Acquisition Cost

Let's walk through a common business example: seeing how a change in your average Customer Acquisition Cost (CAC) affects your overall marketing profitability. We'll build a simple dashboard an e-commerce store might use.

Imagine your data source has the following fields: Month, New Customers, Revenue, and Marketing Spend.

Step 1: Create a Basic Profit Calculation

First, we need a baseline to compare against. Let's create two calculated fields for our current situation: one for Customer Acquisition Cost (CAC) and one for Marketing Profit.

  1. Right-click in the Data pane and select Create Calculated Field.
  2. Name it "Current CAC". The formula is your total spend divided by new customers:
  3. Create another calculated field named "Current Profit". This will be revenue minus spend:

Now you have a baseline. You can build a simple bar chart showing "Current Profit" by "Month" to see how you've performed.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Step 2: Create a Parameter for Your "What-If" Scenario

Next, we will create the user-controlled variable. We want to model how a percentage change in Marketing Spend would affect profit.

  1. Right-click in the Data pane and select Create Parameter.
  2. A configuration window will pop up. Let's set it up like this:

Click OK. You'll now see "Spend Adjustment %" listed in the Parameters section at the bottom of your Data pane. It doesn't do anything yet - for that, we need to connect it to a calculation.

Step 3: Create 'Projected' Calculated Fields

Now let's use the parameter to build our projected metrics. We'll create a "Projected Marketing Spend" and a "Projected Profit."

  1. Create a new calculated field named "Projected Marketing Spend".
  2. The formula will take our original spend and adjust it by the parameter's value:
  3. Create another calculated field named "Projected Profit". We'll subtract our new projected spend from the revenue:

Step 4: Build Your Interactive Visualization

This is where it all comes together. Let's make a dual-axis chart to compare our current profit with our modeled projection.

  1. Drag Month to the Columns shelf.
  2. Drag Current Profit to the Rows shelf. You'll see one bar chart.
  3. Drag Projected Profit to the Rows shelf. You now have two separate charts.
  4. Right-click on the Projected Profit pill in the Rows shelf and select Dual Axis.
  5. Right-click on the right-hand axis and select Synchronize Axis to make sure both charts use the same scale.
  6. On the Marks card, you can adjust the chart types. Maybe leave Current Profit as bars and change Projected Profit to a line or a differently colored bar to make the comparison clear.

Step 5: Show the Parameter Control

The last step is to make the parameter visible and interactive on your dashboard.

  1. In the Data pane, find your "Spend Adjustment %" parameter.
  2. Right-click it and select Show Parameter.

A slider will appear on the right side of your worksheet! Now, when you move the slider from -50% to +50%, you will see the "Projected Profit" line on your chart move up and down in real-time, instantly showing you the potential financial impact of adjusting your ad spend.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Final Thoughts

By pairing parameters with calculated fields, you can build powerful and intuitive scenario analysis models directly within your Tableau dashboards. This technique allows stakeholders to move beyond static reporting and actively engage with the data to inform strategy, set goals, and make better-informed decisions. It transforms a simple dashboard into a conversational planning tool.

Mastering Business Intelligence tools like Tableau is a valuable skill, but often the path to getting answers involves a learning curve and hours of manual setup. For teams that need to connect multiple data sources - like your ad platforms, sales CRM, and Shopify store - and get insights quickly without the technical overhead, we've built a faster way. With Graphed, you can use plain English to generate entire dashboards in seconds. Instead of building calculated fields and parameters, you can just ask, "Show me how a 20% increase in Facebook Ads spend would affect my Shopify revenue and profitability last month," and get a live, interactive dashboard instantly.

Related Articles