Performance recorder in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a Tableau developer at a retail company.

📋 Request: Your manager wants you to find out why a sales dashboard is slow to load and interact.

📊 Data: You have access to the sales dashboard and its data sources, including sales transactions, product details, and customer information.

🎯 Deliverable: You need to use Tableau's Performance Recorder to capture and analyze the dashboard's performance and provide a report with key bottlenecks.

Sample Data

Order ID	Product	Category	Sales	Order Date	Customer Region
1001	Chair	Furniture	150	2024-01-05	East
1002	Desk	Furniture	300	2024-01-06	West
1003	Pen	Office Supplies	5	2024-01-07	East
1004	Notebook	Office Supplies	10	2024-01-08	South
1005	Monitor	Technology	200	2024-01-09	North
1006	Keyboard	Technology	50	2024-01-10	West
1007	Chair	Furniture	150	2024-01-11	East
1008	Pen	Office Supplies	5	2024-01-12	South

1

Step 1: Open the sales dashboard in Tableau Desktop.

No formula needed.

Expected Result

Dashboard is loaded and ready for interaction.

2

Step 2: Start the Performance Recorder by going to Help > Settings and Performance > Start Performance Recording.

No formula needed.

Expected Result

Performance Recorder starts capturing all dashboard actions.

3

Step 3: Interact with the dashboard by filtering sales by Category and Customer Region, and by changing date ranges.

No formula needed.

Expected Result

Performance Recorder captures the load and interaction times.

4

Step 4: Stop the Performance Recorder by going to Help > Settings and Performance > Stop Performance Recording.

No formula needed.

Expected Result

A new workbook opens showing the performance summary.

5

Step 5: Review the Performance Summary dashboard focusing on the 'Events' worksheet to identify slow queries and rendering times.

No formula needed.

Expected Result

You see which queries or dashboard actions take the longest time.

6

Step 6: Note the longest running queries and dashboard actions for optimization.

No formula needed.

Expected Result

You identify that complex filters and large data extracts cause delays.

7

Step 7: Prepare a report summarizing the findings with screenshots of the Performance Summary and recommendations to improve speed.

No formula needed.

Expected Result

Report clearly shows bottlenecks and suggests actions like data extract optimization or filter simplification.

Final Result

Performance Recorder Summary
===========================
| Event           | Duration |
|-----------------|----------|
| Query 1         | 1200 ms  |
| Filter Action   | 800 ms   |
| Rendering       | 600 ms   |

Key Bottlenecks:
- Complex filters slow down queries.
- Large data extracts increase load time.

Recommendations:
- Simplify filters.
- Use optimized extracts.
- Limit dashboard complexity.

✓Complex filters on Category and Region cause slow query times.

✓Large data extracts increase dashboard load and interaction time.

✓Rendering time is moderate but can improve with fewer visual elements.

Bonus Challenge

Use Tableau's Performance Recorder to compare dashboard performance before and after applying filter optimizations.

Show Hint

Record performance once with original filters, then simplify filters and record again. Compare the two performance summaries.

Practice

1. What is the main purpose of Tableau's Performance Recorder?

easy

A. To export data to Excel

B. To create new visualizations automatically

C. To find slow parts in your Tableau workbook

D. To connect to new data sources

Solution

1. Step 1: Understand Performance Recorder's role

   Performance Recorder is designed to help identify which parts of a Tableau workbook are slow.

2. Step 2: Compare options with this purpose

   Options A, B, and D describe other Tableau features, not Performance Recorder.

3. Final Answer:

   To find slow parts in your Tableau workbook -> Option C

4. Quick Check:

   Performance Recorder = Find slow parts [OK]

Hint: Remember: Performance Recorder finds slow workbook parts [OK]

Common Mistakes:

• Confusing Performance Recorder with data export tools
• Thinking it creates visualizations automatically
• Assuming it connects to data sources

2. Which menu in Tableau do you use to start the Performance Recorder?

easy

A. Data menu

B. Dashboard menu

C. Worksheet menu

D. Help menu

Solution

1. Step 1: Recall where Performance Recorder is located

   Performance Recorder is started and stopped from the Help menu in Tableau.

2. Step 2: Eliminate other menus

   Data, Worksheet, and Dashboard menus do not contain Performance Recorder controls.

3. Final Answer:

   Help menu -> Option D

4. Quick Check:

   Start Performance Recorder = Help menu [OK]

Hint: Performance Recorder is under Help menu [OK]

Common Mistakes:

• Looking under Data menu instead of Help
• Trying to start from Worksheet or Dashboard menus
• Not knowing where to find Performance Recorder

3. After recording performance in Tableau, what is the output you get?

medium

A. A new workbook showing detailed timing for each action

B. A CSV file with all data source queries

C. A dashboard with automatic recommendations

D. A log file saved in the Tableau installation folder

Solution

1. Step 1: Identify the output of Performance Recorder

   Performance Recorder creates a new Tableau workbook that shows detailed timing for each action performed during recording.

2. Step 2: Compare with other options

   Options B, C, and D describe outputs unrelated to Performance Recorder's actual output.

3. Final Answer:

   A new workbook showing detailed timing for each action -> Option A

4. Quick Check:

   Performance Recorder output = New workbook with timings [OK]

Hint: Output is a new workbook with timing details [OK]

Common Mistakes:

• Expecting a CSV file instead of a workbook
• Thinking it generates automatic recommendations
• Looking for a log file in installation folders

4. You started Performance Recorder but forgot to stop it. What is the likely issue?

medium

A. No performance data will be saved until you stop recording

B. Tableau will automatically stop recording after 5 minutes

C. Performance data will be saved but incomplete

D. Tableau crashes due to continuous recording

Solution

1. Step 1: Understand how Performance Recorder works

   Performance Recorder only saves data when you stop the recording explicitly.

2. Step 2: Evaluate other options

   Tableau does not auto-stop recording, nor does it crash from continuous recording. Partial data is not saved until stop.

3. Final Answer:

   No performance data will be saved until you stop recording -> Option A

4. Quick Check:

   Stop recording to save data [OK]

Hint: Always stop recording to save performance data [OK]

Common Mistakes:

• Assuming Tableau auto-stops recording
• Thinking partial data is saved automatically
• Believing continuous recording causes crashes

5. You want to improve a slow dashboard. After using Performance Recorder, you see long times in 'Query Execution' and 'Layout'. What should you do next?

hard

A. Increase the number of worksheets in the dashboard

B. Optimize data source queries and simplify dashboard layout

C. Disable Performance Recorder and refresh the dashboard

D. Add more filters to the dashboard to reduce data

Solution

1. Step 1: Interpret Performance Recorder timings

   Long 'Query Execution' means slow data queries; long 'Layout' means complex dashboard design.

2. Step 2: Choose actions to address these issues

   Optimizing queries and simplifying layout directly target these slow parts.

3. Step 3: Evaluate other options

   Adding worksheets or filters may increase complexity or not address root causes; disabling recorder does not improve speed.

4. Final Answer:

   Optimize data source queries and simplify dashboard layout -> Option B

5. Quick Check:

   Fix queries + layout = faster dashboard [OK]

Hint: Fix slow queries and layout to speed dashboard [OK]

Common Mistakes:

• Adding more worksheets increases complexity
• Disabling recorder does not improve speed
• Adding filters may not reduce query time