Dimension filters in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants to see sales data filtered by specific product categories and regions to understand performance in targeted areas.

📊 Data: You have sales data including Order ID, Product Category, Region, Sales Amount, and Order Date.

🎯 Deliverable: Create a Tableau dashboard that allows filtering sales by Product Category and Region using dimension filters.

Sample Data

Order ID	Product Category	Region	Sales Amount	Order Date
1001	Electronics	East	1200	2024-01-15
1002	Furniture	West	850	2024-01-18
1003	Clothing	East	400	2024-01-20
1004	Electronics	South	950	2024-01-22
1005	Furniture	North	700	2024-01-25
1006	Clothing	West	300	2024-01-28
1007	Electronics	North	1100	2024-02-01
1008	Furniture	South	650	2024-02-03
1009	Clothing	East	450	2024-02-05
1010	Electronics	West	1300	2024-02-07

1

Step 1: Connect Tableau to the sales data source containing Order ID, Product Category, Region, Sales Amount, and Order Date.

Use Tableau's 'Connect' feature to import the data table.

Expected Result

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

2

Step 2: Create a new worksheet and drag 'Sales Amount' to Rows and 'Order Date' to Columns to create a sales trend chart.

Rows: SUM(Sales Amount), Columns: Order Date (continuous month/year).

Expected Result

A line chart showing total sales over time appears.

3

Step 3: Add 'Product Category' as a filter by dragging it to the Filters shelf and select all categories initially.

Filters shelf: Product Category (select all).

Expected Result

Filter control for Product Category is created but all categories are selected.

4

Step 4: Add 'Region' as a filter by dragging it to the Filters shelf and select all regions initially.

Filters shelf: Region (select all).

Expected Result

Filter control for Region is created but all regions are selected.

5

Step 5: Show both filters on the worksheet by right-clicking each filter and selecting 'Show Filter'.

Right-click Product Category filter > Show Filter; Right-click Region filter > Show Filter.

Expected Result

Filter panels for Product Category and Region appear on the worksheet for user interaction.

6

Step 6: Test the filters by selecting specific Product Categories and Regions to see the sales trend update accordingly.

Select 'Electronics' and 'Furniture' in Product Category filter; select 'East' and 'West' in Region filter.

Expected Result

The sales trend chart updates to show sales only for Electronics and Furniture in East and West regions.

7

Step 7: Create a dashboard and add the worksheet with filters to it, arranging filters on the side for easy access.

Dashboard layout: Place worksheet center, filters on left side.

Expected Result

Dashboard displays sales trend chart with interactive filters for Product Category and Region.

Final Result

Sales Trend Dashboard

[Product Category Filter]  [Region Filter]

  Sales Amount
    |
1300|      *
    |      *     *
1100|      *     *
    |      *     *
 850|      *  *  *
    |  *   *  *  *
 400|__*___*__*__*___ Order Date
       Jan  Feb

Filters let you pick categories and regions to see sales trends update.

✓Electronics and Furniture have higher sales compared to Clothing.

✓East and West regions show stronger sales performance.

✓Using dimension filters helps focus analysis on specific product categories and regions.

Bonus Challenge

Add a filter for Order Date to allow filtering sales by specific months or date ranges.

Show Hint

Drag 'Order Date' to Filters shelf, choose 'Range of Dates', then show filter on dashboard.