Extract optimization in Tableau - Dashboard Guide

Dashboard Mode - Extract optimization

Goal

Understand how to optimize Tableau data extracts to improve dashboard speed and efficiency.

Sample Data

Order ID	Region	Category	Sales	Order Date
1001	East	Furniture	300	2024-01-15
1002	West	Technology	450	2024-02-10
1003	East	Office Supplies	150	2024-03-05
1004	South	Furniture	200	2024-01-20
1005	West	Technology	500	2024-03-15
1006	North	Office Supplies	100	2024-02-25
1007	South	Furniture	350	2024-03-10

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 2050
  Description: Shows total sales from the extract.
• KPI Card: Number of Orders
  Formula: COUNTD([Order ID])
  Result: 7
  Description: Counts unique orders in the extract.
• Bar Chart: Sales by Region
  Formula: SUM([Sales]) grouped by [Region]
  Results:
  • East: 450
  • West: 950
  • South: 550
  • North: 100
  
  Description: Visualizes sales distribution by region.
• Filter: Date Range
  Type: Date filter on [Order Date]
  Description: Limits data to a selected date range, improving performance.
• Filter: Category
  Type: Multi-select filter on [Category]
  Description: Allows focusing on specific product categories, improving performance.

Dashboard Layout

+----------------------+----------------------+
|   Total Sales (KPI)  | Number of Orders (KPI)|
+----------------------+----------------------+
|                      Bar Chart: Sales by Region                      |
|                                                                    |
+--------------------------------------------------------------------+
| Filters: Date Range | Category Filter                               |
+--------------------+----------------------------------------------+

Interactivity

The Date Range and Category filters update all components dynamically. Selecting a narrower date range or fewer categories reduces the data processed, speeding up interactions.

For example, choosing only the 'Furniture' category will update the bar chart and KPIs to reflect just those filtered rows.

Self Check

If you apply a filter to show only orders from the 'Technology' category, which components update and what are their new values?

• Total Sales: 950 (sum of 450 + 500)
• Number of Orders: 2 (orders 1002 and 1005)
• Bar Chart: Only 'West' region bar shows 950 sales; other regions show 0 or are hidden.

Key Result

A Tableau dashboard showing total sales, order count, and sales by region with filters to improve performance.