How to Improve Tableau Performance

Today we’ll be learning how to increase performance of Tableau Dashboard or server. Here is broad list of Tableau performance best practices and methods. Some times the dashboard takes too much to apply some filter to work or while moving to other tabs. These techniques and best practices will be very helpful to solving those issues and improving the Tableau dashboard performance.

 

Ask Tableau users what they love most about Tableau, and they’ll likely say it’s the ability to create stunning data visualizations quickly and easily. Tableau was designed with usability in mind, apparent in its approachable interface, yet behind that interface lies a powerful collection of components capable of cranking out complex data visualizations at lightning speed.

Of course, excited users inevitably find ways to bog things down. It’s easy to do. The good news is that we learned from these mistakes and took the time to jot down a few ways to maintain peak performance. So whether your Tableau Server is running slow or Tableau Workbooks seem sluggish, our Tableau Performance Checklist is here to help with performance-saving best practices. We hope it helps you as much as it’s helped us.

The List

The Tableau Performance Checklist is divided into seven main categories. You’ll find those categories with their subsequent best practices in the master list below:

Data

  • Keep analysis simple. Work with a subset of your data. Extract a sample if needed.

  • Bring in only the data needed for analysis. Consider adding a data source filter or using an extract. If using a join, minimize the number of joined tables.
  • Use “Describe” to explore dimensions in new data sets without having to load them into a viz (keyboard shortcut CTRL+E).
  • Remove unused columns (measures/dimensions) in order to minimize extract refresh time or custom SQL query time.
  • Create a published TDS file for your business team to use rather than each analyst creating their own data source. This includes all metadata associated with dimensions, measures, calculated fields, hierarchies, sets, parameters and naming conventions.
  • Use extracts wherever possible to accelerate performance. Hide unused and confidential fields. Roll up data granularity by pre-aggregating or filtering. Break hierarchies to only visible dimensions.

Filtering

Custom SQL

Calculations

Rendering

Local Computations

Dashboard Layout

Further readings and sources-

The Tableau Performance Checklist (Source)

Tableau Performance Checklist 1

The Tableau Performance Checklist 2

Tableau workbook Performance

Tableau Performance Series

Improving Database Query Performance

Tableau Performance Pdf 1

Tableau Performance Pdf 2

Tableau Performance Pdf 3

 

Thanks for reading! Keep visiting Analytics Tuts for more tutorials.

 

 

 

2 comments

Leave a Reply

Your email address will not be published. Required fields are marked *