Query performance tuning in Tableau - Dashboard Guide

Dashboard Mode - Query performance tuning

Dashboard Goal

Understand how query performance tuning affects dashboard speed and responsiveness in Tableau.

Sample Data: Query Performance Metrics

Query ID	Execution Time (seconds)	Rows Returned	Cache Status	Optimization Applied
Q1	12.5	15000	No	None
Q2	4.2	15000	Yes	Indexing
Q3	7.8	8000	No	Filter Pushdown
Q4	3.5	8000	Yes	Filter Pushdown + Indexing
Q5	15.0	30000	No	None
Q6	5.0	30000	Yes	Indexing

Dashboard Components

• KPI Card: Average Execution Time
  Formula: AVG([Execution Time (seconds)])
  Shows the average query execution time across all queries.
• KPI Card: Average Execution Time (Cached Queries)
  Formula: AVG(IF [Cache Status] = 'Yes' THEN [Execution Time (seconds)] ELSE NULL END)
  Shows average execution time for cached queries only.
• Bar Chart: Execution Time by Query ID
  X-axis: Query ID
  Y-axis: Execution Time (seconds)
  Color: Optimization Applied
  Shows how different optimizations affect execution time per query.
• Table: Query Details
  Columns: Query ID, Execution Time (seconds), Rows Returned, Cache Status, Optimization Applied
  Shows detailed data for each query.

Dashboard Layout

+----------------------+-----------------------------+
| Average Execution Time| Average Execution Time (Cached)|
|       KPI Card        |          KPI Card            |
+----------------------+-----------------------------+
|                                                      |
|           Bar Chart: Execution Time by Query ID       |
|                                                      |
+------------------------------------------------------+
|                                                      |
|                   Table: Query Details                |
|                                                      |
+------------------------------------------------------+
    

Interactivity

Filter: Optimization Applied
Selecting one or more optimization types filters the bar chart and table to show only queries with those optimizations.
The KPI cards update to reflect average execution times for the filtered queries.

Filter: Cache Status
Choosing 'Yes' or 'No' filters all components to show cached or non-cached queries only.
This helps compare performance impact of caching.

Self Check

Add a filter for Optimization Applied = 'Indexing'.
Which components update and what changes do you see?

Answer:
The bar chart and table update to show only queries Q2, Q4, and Q6.
The KPI cards recalculate average execution times for these queries.
You will see that queries with indexing have lower execution times compared to those without.

Key Result

Dashboard shows how query optimizations and caching affect execution time in Tableau queries.