Bird
Raised Fist0
Tableaubi_tool~8 mins

Performance recorder in Tableau - Dashboard Guide

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Dashboard Mode - Performance recorder
Dashboard Goal

Understand how to use Tableau's Performance Recorder to identify slow dashboard actions and improve overall speed.

Sample Data
Order IDRegionCategorySalesOrder Date
CA-2017-152156WestFurniture261.962017-11-08
CA-2017-152157EastTechnology731.942017-11-09
CA-2017-152158CentralOffice Supplies14.622017-11-10
CA-2017-152159WestFurniture957.582017-11-11
CA-2017-152160EastTechnology22.372017-11-12
CA-2017-152161CentralOffice Supplies48.862017-11-13
CA-2017-152162WestFurniture7.282017-11-14
Dashboard Components
  • KPI Card: Total Sales
    Formula: SUM([Sales])
    Result: 2,044.61
  • Bar Chart: Sales by Region
    Shows total sales per region using SUM([Sales]) grouped by [Region].
  • Line Chart: Sales Over Time
    Displays sales trend by [Order Date] using SUM([Sales]).
  • Performance Recorder Output: Performance Summary Table
    Shows recorded durations of dashboard actions like query execution, rendering, and data source refresh.
Dashboard Layout
+----------------------+-----------------------+
|      KPI Card        |    Performance Recorder |
|    Total Sales       |      Summary Table      |
+----------------------+-----------------------+
|          Bar Chart: Sales by Region           |
+----------------------------------------------+
|          Line Chart: Sales Over Time          |
+----------------------------------------------+
Interactivity

Filters on Region and Category update all charts and the KPI card. The Performance Recorder output updates automatically to reflect the performance impact of applied filters and user actions.

Self Check

If you add a filter for Region = 'East', which components update?

  • KPI Card: Total Sales updates to sum sales only for East region.
  • Bar Chart: Sales by Region updates to show only East region bar.
  • Line Chart: Sales Over Time updates to show sales trend for East region.
  • Performance Recorder Output updates to show performance timings for filtered queries and rendering.
Key Result
A Tableau dashboard showing total sales, sales by region and over time, with Performance Recorder output to analyze dashboard speed.

Practice

(1/5)
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