Quick filters for interactivity in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants an interactive sales dashboard where users can filter data by Region and Product Category to explore sales performance easily.

📊 Data: You have monthly sales data including columns: Date, Region, Product Category, Sales Amount, and Units Sold.

🎯 Deliverable: Create a Tableau dashboard with quick filters for Region and Product Category that update the sales charts dynamically.

Sample Data

Date	Region	Product Category	Sales Amount	Units Sold
2024-01-15	North	Electronics	12000	30
2024-01-15	South	Furniture	8000	20
2024-02-10	East	Electronics	15000	40
2024-02-10	West	Clothing	7000	50
2024-03-05	North	Clothing	9000	45
2024-03-05	South	Electronics	11000	25
2024-04-12	East	Furniture	13000	15
2024-04-12	West	Furniture	6000	10
2024-05-20	North	Electronics	14000	35
2024-05-20	South	Clothing	7500	40

1

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

Use 'Connect to Data' and select the data file or database with the sales data.

Expected Result

Tableau shows the data fields ready for analysis.

2

Step 2: Create a new worksheet to visualize total Sales Amount by Month.

Drag 'Date' to Columns, right-click and select 'Month' as date part. Drag 'Sales Amount' to Rows and set aggregation to SUM.

Expected Result

A line chart showing total sales amount for each month.

3

Step 3: Add 'Region' as a quick filter to the worksheet.

Right-click 'Region' field in Data pane, select 'Show Filter'.

Expected Result

A filter pane appears on the right allowing selection of one or more Regions.

4

Step 4: Add 'Product Category' as a quick filter to the worksheet.

Right-click 'Product Category' field in Data pane, select 'Show Filter'.

Expected Result

A filter pane appears allowing selection of one or more Product Categories.

5

Step 5: Customize the quick filters for better user experience.

Click the filter dropdown arrow, choose 'Single Value Dropdown' or 'Multiple Values Dropdown' for both filters.

Expected Result

Filters show as dropdown menus for easy selection.

6

Step 6: Create a dashboard and add the worksheet with the filters.

Click 'New Dashboard', drag the worksheet onto the dashboard canvas. Ensure filters appear and are interactive.

Expected Result

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

7

Step 7: Test the filters by selecting different Regions and Product Categories to see the sales chart update dynamically.

Select 'North' and 'Electronics' in filters and observe the chart update.

Expected Result

Chart updates to show sales only for North region and Electronics category.

Final Result

Sales Dashboard

[Region Filter ▼]  [Product Category Filter ▼]

  Sales Amount by Month

  Jan  Feb  Mar  Apr  May
  |----|----|----|----|----|
  |    |    |    |    |    |
  |****|****|****|****|****|

(Chart updates as filters change)

✓Users can easily explore sales trends by selecting specific Regions and Product Categories.

✓The quick filters make the dashboard interactive and user-friendly.

✓Filtering helps focus on relevant data, improving decision-making.

Bonus Challenge

Add a quick filter for 'Date' to allow users to select a specific date range for sales analysis.

Show Hint

Use the 'Show Filter' option on the 'Date' field and set the filter type to 'Range of Dates' for easy selection.