The Tableau Performance Checklist: Data – Keep Analysis Simple

Data

The Tableau Performance Checklist: Data – Keep Analysis Simple

The Tableau Performance Checklist series is designed to help you streamline your dashboard performance and Tableau Server configuration. Each post expands upon one item listed in the master Tableau Performance Checklist.

The first topic we’ll be covering in this new series is Data, and the first point on the checklist is as follows:

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

The old adage, “Keep It Simple, Stupid” is just as true in Tableau dashboard design as it is everywhere else. Take these examples for Sales by Item:

Bad viz 

Figure 1: A cluttered viz.                                                                                                 

Good viz

Figure 2: Simplified analysis.

Which viz above do you think communicates the data more effectively? There’s certainly nothing wrong with making your vizzes detailed, but too many details can distract from your central point, whatever that may be. Still, there’s more to clear and concise visual analysis than just layout. We need to go deeper.

It Starts with Good Preparation

Just as important to your visualization is how you prepare your data for your worksheets. It can have a tremendous impact on their performance. There are a few things to consider when trying to keep your data as trim and streamlined as possible.

Dashboard Performance

Your visualizations can only perform as fast as your underlying data sources. That is the great performance inhibitor that makes great dashboards into headaches. The key to improving performance for slow data is to extract only the data that is needed for the worksheet to perform its analysis.

Report Portability

When you create a data extract, you create a TDE that can serve a single workbook or multiple workbooks. The good news is that a TDE can be packaged with a workbook as a self-contained reporting suite that is not reliant on a connection back to the data source. As such, it can be shared and disseminated far more easily than a workbook that relies on a live data connector.

*** Caution: Keep security in mind when utilizing TDEs in a TWBX.

Data Source Efficiency

Not only can a data extract improve the performance of your dashboard, but you can also improve the efficiency and performance of the data source itself. A data extract does not need to communicate with the data source from which it was drawn. It is a self-contained data subset.

Aggregated Extracts

When you create a data extract, Tableau also gives you the option to aggregate your data for all visible dimensions. When these pre-aggregations are used, the data extract is called an “aggregated extract.” This type of extract does not contain the row-level data. Rather, it contains only the aggregated data. It’s ideal for some visualizations, depending on the type of analysis performed. An aggregated extract is smaller than a standard data extract, and it creates another level of efficiency in generating fast performance with your dashboards and worksheets.

Calculated Fields

When you create a data extract, all calculated fields in the extract are converted to static fields. This is a great way to reduce the heavy lifting of the data source whenever data is accessed via a live connection. Calculated fields that are converted into static values can be accessed and aggregated as easily as any other field. These are particularly effective when dealing with string calculations, which are far more resource-heavy than numeric or date calculations.

For more insight on calculated fields, check out this blog.

Mastering Best Practices

If you’re interested in becoming a Tableau Server guru, then learning these performance best practices is essential. Check back frequently as we add new posts and dive deeper into each point in the Tableau Performance Checklist.

Another great way to identify best practices is to leverage the insights offered by our Performance Analyzer, part of Workbook Tools for Tableau. It will examine all of your workbooks, worksheets, dashboards and data sources against a list of best practices to ensure that you’re using all the tips and tricks to guarantee your visualizations are moving at light speed.

As always, feel free to get in touch with us if you have any questions regarding performance or anything Tableau related! We’d be happy to help.

Contact Us!

Want More The Tableau Performance Checklist

  1. The Tableau Performance Checklist
  2. The Tableau Performance Checklist: Data – Keep Analysis Simple
  3. The Tableau Performance Checklist: Data – Bring in Only Needed Data
  4. The Tableau Performance Checklist: Data – Use ‘Describe’ to Explore
  5. The Tableau Performance Checklist: Data – Remove Unused Columns from Extracts
  6. The Tableau Performance Checklist: Data – Use One TDS File
  7. The Tableau Performance Checklist: Data – Use Extracts
  8. The Tableau Performance Checklist: Filtering – Minimize Quick Filters
  9. The Tableau Performance Checklist: Filtering – Avoid ‘Only Relevant Values’ in Quick Filters
  10. The Tableau Performance Checklist: Filtering – Avoid High-Cardinality Quick Filters
  11. The Tableau Performance Checklist: Filtering – Avoid Quick Filters That Drive Context Filters
  12. The Tableau Performance Checklist: Filtering – Keep Range Quick Filters Simple
  13. The Tableau Performance Checklist: Filtering – Use Dashboard Filter Actions
  14. The Tableau Performance Checklist: Filtering – Don’t Be Lazy with User Filters
  15. The Tableau Performance Checklist: Custom SQL – Limit in Live Connections
  16. The Tableau Performance Checklist: Custom SQL – Avoid Parameters
  17. The Tableau Performance Checklist: Custom SQL – Watch for Useless Clauses
  18. The Tableau Performance Checklist: Calculations – Use Calculated Fields Carefully
  19. The Tableau Performance Checklist: Calculations – Limit Blended Calculations
  20. The Tableau Performance Checklist: Calculations – Avoid Row-Level Calculations Involving Parameters
  21. The Tableau Performance Checklist: Rendering – Avoid High Mark Counts
  22. The Tableau Performance Checklist: Rendering – Limit Text Tables With Lots of Marks
  23. The Tableau Performance Checklist: Rendering – Minimize Image & Shape File Sizes
  24. The Tableau Performance Checklist: Rendering – Use Transparent Background PNGs
  25. The Tableau Performance Checklist: Local Computations – Server Performance
  26. The Tableau Performance Checklist: Local Computations – Table Calculations
  27. The Tableau Performance Checklist: Dashboard Layout – Limit Number of Worksheets
  28. The Tableau Performance Checklist: Dashboard Layout – Fix Dashboard Size

More About the Author

Dustin Wyers

Analytics Consultant | Assist Lead - East
Advance with Assist: REST Error in Tableau and Snowflake Connection Question: I’m getting an error when I try to log into Snowflake. It says REST error and no such file or directory. How can I get ...
Advance with Assist: Sheet Swapping with Dummy Headers Question: I’m trying to use a sheet swap toggle between two chart types, but in the layout container, the sheet is keeping space and ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072