Why filtering focuses analysis in Tableau - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants you to analyze sales performance but only for the East region to understand its trends better.

📊 Data: You have sales data including Region, Month, Product Category, and Sales Amount for the last year.

🎯 Deliverable: Create a Tableau dashboard that shows total sales by month for the East region only, using filters to focus the analysis.

Sample Data

Region	Month	Product Category	Sales Amount
East	Jan	Electronics	1200
West	Jan	Electronics	900
East	Feb	Furniture	1500
North	Feb	Furniture	700
East	Mar	Clothing	1100
South	Mar	Clothing	1300
East	Apr	Electronics	1400
West	Apr	Electronics	1000
East	May	Furniture	1600
North	May	Furniture	800
East	Jun	Clothing	1300
South	Jun	Clothing	1200

1

Step 1: Connect your Tableau workbook to the sales data source containing Region, Month, Product Category, and Sales Amount.

No formula needed; just connect the data source.

Expected Result

Data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a filter on the Region field to include only 'East'.

Drag 'Region' to Filters shelf, select only 'East', and apply.

Expected Result

Only data rows where Region is East are included in the analysis.

3

Step 3: Build a line chart showing total Sales Amount by Month for the East region.

Drag 'Month' to Columns, drag SUM(Sales Amount) to Rows.

Expected Result

Line chart displays total sales for each month, filtered to East region only.

4

Step 4: Add Product Category as a color detail to see sales by category within the East region.

Drag 'Product Category' to Color on Marks card.

Expected Result

Line chart lines are colored by product category, showing category trends in East region.

5

Step 5: Add a dashboard and place the line chart on it with the Region filter visible for user interaction.

Create new dashboard, drag worksheet in, add Region filter as a quick filter.

Expected Result

Dashboard shows sales trends for East region by month and category, with filter allowing region change.

Final Result

Dashboard: Sales Trends by Month (East Region)

Month -> Jan  Feb  Mar  Apr  May  Jun

Electronics: 1200  -    -    1400  -    -
Furniture:   -    1500  -    -    1600  -
Clothing:   -     -   1100  -    -    1300

[Region Filter: East]

(Line chart with colored lines for each product category showing sales over months)

✓Filtering to East region focuses the analysis on relevant data only.

✓Sales in East region show strong Furniture sales in Feb and May.

✓Electronics sales peak in Jan and Apr in East region.

✓Clothing sales steadily increase in East region from Mar to Jun.

Bonus Challenge

Add a filter for Product Category to allow users to focus on one category at a time in the dashboard.

Show Hint

Drag 'Product Category' to Filters shelf and show it as a quick filter on the dashboard.