1. Using the Performance Recorder

 
Subtitles Enabled

Sign up for a free trial to continue watching this lesson.

Free trial

Optimizing for Performance

9 lessons , 0 exercises , 1 exam

Start Course

Overview

Tableau's performance recorder helps you identify specific queries and views that are causing delays. In this lesson, we will learn how to run the performance recorder and interpret the results.

Lesson Notes

Running the performance recorder

1 Click on the Help dropdown
2 Click on Settings and Performance
3 Click on Start Performance Recording
4 Perform the actions you wish to monitor
5 Click on Stop Performance Recording

Tips for improving the performance of various actions

- Computing layouts: If layouts are taking too long, consider simplifying your visualization
- Connecting to data source: Slow connections could be due to network issues or issues with the database server
- Executing query: For live connections, if queries are taking too long, consider using an extract to speed up performance
- Generating extract: To speed up extract generation, consider only importing some data from the original data source
- Geocoding: To speed up geocoding performance, try using less data or filtering out data
- Blending data: To speed up data blending, try using less data or filtering out data

Transcript

In this course, we're going to look at one of the biggest issues facing Tableau users that is often neglected and that is performance. From previous courses, we know that Tableau can produce impressive data visualizations from virtually any data source in a snap. But sometimes messy data, excessive queries and design errors can slow down your dashboards. And for a manager or client, nothing is more frustrating than slow loading times. For example, waiting 15 seconds for a filter to perform.

In this course, we're going to show you how to diagnose and fix loading problems which is imperative for an optimum user experience.

In the final lessons of this course, we will also look at some of the ways to distribute your dashboards effectively to external users.

One of the best was of identifying loading problems in your dataset is the performance recording which simply tracks the time it takes for you to perform specific actions within your workbook. For example, reloading a date source or viewing a new dashboard. To start the performance reporter, I go to "help", Settings and Performance, and Start Performance Recording. And now I simple perform some actions that I'd like to time. So I could load Dashboard 1, load Sheet 3, load Sheet 2, and maybe return to Dashboard 1 again, and perform a filter.

Now I'll stop my performance recorder, and analyze the results.

Once I press stop on my performance recorder, a new Tableau workbook is generated, and this includes a performance summary which has a timeline of all the actions that I took on each individual sheet, and it also has the events sorted by time.

And as you can see, computing the layout and Dashboard 1 took the longest time. And then next was computing the layout and Sheet 2. In this particular example, I only have three types of events. Computing the layout, sorting the data, and geocoding.

And these last two event types can be seen as I scroll down.

Depending on the actions you take while the recorder is running, you may see some other event types as well, including query execution, connecting to data sources, and extract generation.

In this way, performance recorder allows you to quickly find out which parts of your workbook are creating loading problems. And in this course, we're going to use the performance recorder repeatedly to make sure any improvements we make to our dashboards are having the desired effect.

In the next Tableau dashboard you create, try using the performance recorder to see if any loading problems can be identified.