Why parameters add user-driven flexibility in Tableau - Business Case Study

Scenario Mode

👤 Your Role: You are a business analyst at a retail company.

📋 Request: Your manager wants an interactive sales dashboard where users can choose which product category to analyze and set a sales target to compare actual sales against.

📊 Data: You have monthly sales data including Product Category, Sales Amount, and Month.

🎯 Deliverable: Create a Tableau dashboard with parameters that let users select a product category and input a sales target. The dashboard should show sales trends for the selected category and highlight if sales meet or exceed the target.

Sample Data

Month	Product Category	Sales Amount
Jan	Electronics	12000
Jan	Clothing	8000
Jan	Home Goods	6000
Feb	Electronics	15000
Feb	Clothing	7000
Feb	Home Goods	6500
Mar	Electronics	13000
Mar	Clothing	9000
Mar	Home Goods	7000

1

Step 1: Create a parameter named 'Select Category' with data type String and list of values: Electronics, Clothing, Home Goods.

In Tableau, right-click in Data pane > Create Parameter > Name: Select Category > Data type: String > Allowable values: List > Add values: Electronics, Clothing, Home Goods.

Expected Result

A parameter 'Select Category' appears in the Data pane with the three product categories as options.

2

Step 2: Create a parameter named 'Sales Target' with data type Integer and a current value of 10000.

Right-click in Data pane > Create Parameter > Name: Sales Target > Data type: Integer > Current value: 10000 > Allowable values: All.

Expected Result

A parameter 'Sales Target' appears in the Data pane with default value 10000.

3

Step 3: Create a calculated field named 'Filtered Sales' that shows sales only for the selected category.

IF [Product Category] = [Select Category] THEN [Sales Amount] ELSE NULL END

Expected Result

The 'Filtered Sales' field returns sales amounts only for the category chosen by the user.

4

Step 4: Create a calculated field named 'Sales vs Target' to compare sales to the target and return 'Met' or 'Not Met'.

IF SUM([Filtered Sales]) >= [Sales Target] THEN 'Met' ELSE 'Not Met' END

Expected Result

The 'Sales vs Target' field shows 'Met' if sales meet or exceed the target, otherwise 'Not Met'.

5

Step 5: Build a line chart with Month on Columns and SUM of 'Filtered Sales' on Rows.

Drag 'Month' to Columns shelf, drag 'Filtered Sales' to Rows shelf, set aggregation to SUM.

Expected Result

A line chart showing monthly sales trend for the selected product category.

6

Step 6: Add 'Sales vs Target' as a color mark to highlight if sales met the target each month.

Drag 'Sales vs Target' to Color on Marks card.

Expected Result

The line chart colors points green if sales met the target and red if not.

7

Step 7: Show both parameters 'Select Category' and 'Sales Target' on the dashboard for user interaction.

Right-click each parameter > Show Parameter Control.

Expected Result

Users can select product category and enter sales target to update the chart dynamically.

Final Result

Monthly Sales Trend Dashboard

[Select Category ▼]  [Sales Target: 10000]

Month: Jan  Feb  Mar
Sales:  |----|-----|----|
Color:  Green=Met, Red=Not Met

(Line chart showing sales trend for chosen category with color indicating if target met)

✓Parameters let users pick which product category to analyze without changing the data source.

✓Users can set their own sales target to see if sales meet expectations.

✓The dashboard updates instantly based on user choices, making it flexible and interactive.

Bonus Challenge

Add a parameter to select the aggregation level: Monthly or Quarterly sales view.

Show Hint

Create a parameter with values 'Monthly' and 'Quarterly', then use a calculated field to group months into quarters when 'Quarterly' is selected.