Performance considerations in Tableau - Dashboard Guide

Dashboard Mode - Performance considerations

Dashboard Goal

Understand how to design a Tableau dashboard that loads quickly and responds smoothly by applying performance best practices.

Sample Data: Sales by Region and Category

Region	Category	Sales	Orders	Profit
East	Furniture	1000	50	200
East	Technology	1500	70	300
West	Furniture	1200	60	250
West	Office Supplies	800	40	150
Central	Technology	1300	65	280
Central	Office Supplies	900	45	180

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 6700
• KPI Card: Average Profit per Order
  Formula: SUM([Profit]) / SUM([Orders])
  Result: 4.1
• Bar Chart: Sales by Region
  Aggregates sales per region using SUM([Sales])
  Shows 3 bars: East (2500), West (2000), Central (2200)
• Filter: Region Selector
  Allows user to select one or more regions to filter all components
• Table: Sales Detail
  Shows rows from sample data filtered by region

Dashboard Layout

+----------------------+----------------------+
| Total Sales (KPI)    | Avg Profit/Order (KPI)|
+----------------------+----------------------+
|                      Bar Chart: Sales by Region          |
+---------------------------------------------------------+
|                      Sales Detail Table                  |
+---------------------------------------------------------+

Interactivity

The Region Selector filter controls the data shown in the KPI cards, bar chart, and sales detail table. When a user selects a region, all components update to show only data for that region. This keeps the dashboard consistent and responsive.

Performance tips applied:

• Aggregations done at data source level (SUM) to reduce data load.
• Minimal number of filters to avoid slow queries.
• Simple calculations (SUM, division) to keep response fast.
• Use of indexed columns (Region) for filtering.

Self Check

Question: If you add a filter to select only the East region, which components update and what results do they show?

Answer: All components update:

• Total Sales KPI: Shows 2500 (1000 + 1500)
• Average Profit per Order KPI: Shows 4.17 ((200 + 300) / (50 + 70))
• Bar Chart: Shows only one bar for East with sales 2500
• Sales Detail Table: Shows only rows where Region = East

Key Result

A Tableau dashboard showing total sales, average profit per order, sales by region bar chart, and detailed sales table with region filter for performance optimization.