January 21, 2015

10 Easy Ways to Improve Your Tableau Workbook Performance



I don’t typically write “tool-specific” blog posts. However, tomorrow I’m presenting at a local Tableau User Group Meeting so I figured I’d kill 2 birds with 1 stone. If you are not a Tableau user, hopefully you can find some value in the concepts.

Part of my presentation pertains to optimizing your Tableau workbooks. The following 10 suggestions are some of my favorites for reducing workbook size and enhancing the overall performance. Most of these take only a few seconds to complete and will pay huge dividends.

Every little bit counts!

Please feel free to add your own suggestions in the comments! I know there are many more Jedi tricks. (& if you know of a way to do both #4 AND #5 on the same workbook…do tell!)

  1. Use Extracts when Possible
    • Tableau’s Columnar Data Engine is the way to go if you don’t require real-time data
  2. Optimize Extracts
    • Adds your calculated fields to your extract instead of calculating on your desktop
  3. Filter Data at Data Source Level
    • If you have 10 years of data and you’re only reporting the last 5, filter out what you don’t need before you extract.
  4. Aggregate for Visible Dimensions (& “Roll Dates To”)
    • Aggregates your data based on your visualizations (i.e. you have data to Engineer level but we only need to report at Director Level)
  5. When using dates, specify how far down date hierarchy to view.
    • No need to aggregate to the minute or second if you need to display at a weekly view
  6. Incremental Extracts
    • Appends only new data rather than regenerating all data
  7. Hide All Unused Fields
    • Best used when ready for production
  8. Use Actions instead of quick filters
    • Actions Filter the Visualization rather querying your data source
  9. If you must use filters, use context filters
    • Context Filters create a temp table with the results of your filter so that all subsequent filters query only the reduced result set
  10. String Calculations perform worse than Numeric Calculations.
    • Parameters are a great place to leverage this advice
  11. Do not attempt to Boil the Ocean
    • Use workbook case specific datasets rather than 1-size-fits-all solutions, this is not like building a Universe in BO if you’ve worked with that tool.


Cheers,

Kevin Taylor

6 comments:

  1. Anyone know why the extract optimization would cause a SQL Server sourced extract not to refresh? trying to go through this bit by bit but ran into this. Beuhler?

    ReplyDelete
  2. Be careful with context queries. God rule of thumb, use when the resulting dataset would be only 10-20% of the original to offset the creation of a temp table.

    ReplyDelete


  3. It is really a great work and the way in which you are sharing the knowledge is excellent.Tableau Training in Chennai

    ReplyDelete
  4. If you want to be able to learn how to visualize data using tableau then look for best tableau courses.

    ReplyDelete
  5. Great post I must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more. 4 ps of marketing

    ReplyDelete