How to Run and Interpret the Tableau Workbook Optimizer

With version 2022.4 or later, you have the option to “Ignore this rule” if a best practice does not apply to your workbook. Some guidelines also give you the option to “Fix the rule” automatically, like hiding unused fields.

Each guideline has a short blurb explaining how the rule affects your workbook performance, as well as a link to additional information.

Optimize from the start

I highly recommend reviewing Tableau’s 20 guidelines to make a plan before building your dashboard and will share what I have found to be helpful tips to consider.

New to Playfair Data?

Watch our 90-second intro video and receive tips on making your data usable.
 
Watch Video

First, make sure to practice good data prep! Don’t use more data than you need. Optimize your data by including calculations in your data source, and use an extract if possible.

9 Quick Alteryx Tips to Optimize Your Data Workflows

Nested calculations

If you know you will be using a lot of calculated fields, try to map them out before jumping in and building views, especially if the calculated fields will be dependent on each other. Nested calculations add an additional layer of processing, which can negatively affect speed optimization. I’m not saying to avoid nested calculations altogether, but if you plan on writing any complicated calculations, especially conditional statements, brainstorming different ways to write your calc can save you time in the long run.

Date calculations

Always minimize date conversions and calculations when possible. Date calculations typically take longer to process than other data types, so make sure your data is in the desired format before loading. For example, see the below image of the Data pane where the field “Ship Date” is a string, and DATEPARSE was used to convert it from string to Datetime format. Now the calculated field “Days to Ship Actual” is considered a nested calculation using “Ship Date (DATEPARSE)”, which could be avoided if Ship Date had Date or Datetime format in the data source.

Expression performance hierarchy

Not all calculations are created equal! 

• When writing a conditional statement, try using CASE/WHEN over IF/THEN as it typically performs better, and always write the most common outcome first. When conditional statements are processed, Tableau stops as soon as a condition is met, and you will save computing time.
• Next, if you are writing an IF/THEN statement, use ELSEIF over ELSE IF. Tableau processes ELSE IF as two separate logical statements, whereas ELSEIF is viewed as a single statement.

For example, this version of a calculated field…

IF [First Name] = “William” THEN “Playfair” ELSEIF [First Name] = “Megan” THEN “Spengler” END

…will process faster than this version:

IF [First Name] = “William” THEN “Playfair” ELSE IF [First Name] = “Megan” THEN “Spengler” END END

• Immediate If (IIF) statements are another option that stop once a condition is met, but there is no major difference in performance when compared to IF/THEN. 
• Table calculations typically execute quicker than LOD expressions, but the performance really depends on your data source. If possible, I would recommend comparing dashboard performance with and without a specific table calculation or LOD expression to determine which works best for you.

The Beginner’s Guide to Tableau Table Calculations

Text formatting

If you need static text elements on your dashboard, try adding them to your background image or using text boxes instead of creating additional sheets. The fewer dashboard elements you have the better, but sheets take longer to render than text boxes.

Takeaway

Now that we have reviewed Tableau’s best practices, I hope you can see why it’s efficient to think about optimization before building out your dashboard rather than trying to optimize your dashboard retroactively. And don’t forget, you can run the Tableau Optimizer on your workbooks as many times as you want, so checking your optimization score as you work is always a great idea. 

Thanks for reading, and happy optimizing!
-Megan