The following list of changes, tweaks, or considerations are all designed to improve performance of a Tableau dashboard. Not all suggestions will work in all situations, so even with this list there is a need for experience and understanding of how Tableau works in order to properly evaluate this list. There are three broad categories of things to do, some requiring more technical expertise and access to source systems than others.
- Data Structure/Content Tuning
- Visualizations Tuning
- Calculation Tuning
- Other
We have color-coded, based on category, actions to be taken. The list is generally presented from “most impactful” to “least impactful”. Again, not all “most impactful” suggestions will work on all structures of data, and in some cases entries at the bottom of the list may be much more impactful in some scenarios. For example, if a dashboard is running on a heavily used Tableau Server the last entry in the list, “Use fixed sized dashboards” may actually produce significantly better results. Caveats aside… here is the list.
Tableau Dashboard Performance Tuning Checklist
- Consider offloading data preparation/cleansing from Desktop and into Prep and simplify any calculated fields with the sole purpose of reshaping data for visualizing (e.g. string manipulation, data type conversion, etc.)
- Extract source data and consider using a multi-table (i.e., normalized) extract, where appropriate, but especially for multi-fact tables (e.g. survey data, snowflake schemas, etc.)
- Reduce number of marks in visuals (i.e. aggregate source data, aggregate views, etc.)
- Remove/hide unused columns… if extracting data, hide the unused columns prior to extracting
- Pivot columns to rows where appropriate (e.g. date columns like months or years, survey responses, etc.)
- Reduce number of rows as early as possible (e.g. data source filters)
- Reduce size of large text table views, or hide the large text tables until filters have been applied
- Connect to data sources using native drivers rather than ODBC
- Avoid using custom SQL (this bypasses Tableau’s ability to generate efficient, optimal queries)
- Reduce number of views per dashboard
- Reduce number of filters on views
- Promote “high impact” “frequently used” filters to context filters
- Replace LOD filters with sets that are formula-based
- Replace LOD expressions with table calculations where possible
- Determine where performance issues exist (i.e., Desktop Only, Server Only, or both) and address accordingly, consider using a performance recording for low-level detail of performance factors
- Use only one or two context filters, and only if they reduce record count by 10% or more
- Change enumerated filters (e.g., dropdown, radio, slider) to unenumerated filters (e.g., custom value list, wildcard match)
- Avoid excessive use of “only relevant values” filters
- Use the “apply” button for shown filters
- Simplify the granularity of the data source so advanced calculations (e.g. table calcs, LOD expressions, etc.) aren’t necessary
- Reduce number of text fields
- Avoid sparsely populated data sources (e.g. lots of NULL/blank values), unless the data is extracted
- Use joined data sources instead of blended data sources when data sources have high number of records (i.e. not as useful if one data source is “reference data” with very few rows and the other is “fact data” with lots of rows), or when the field has large numbers of unique values (i.e. high cardinality)
- When joining tables, use the minimum tables and joins necessary to generate the data you need
- When possible, avoid linking blended data sources on long text fields, or fields with high cardinality (i.e. lots of unique values)
- Avoid string manipulation where possible (e.g. FIND, LEFT, RIGHT, MID, etc.)
- Allow logins to database ability to create and delete temp tables
- Use optimal date functions (e.g. DATETRUNC, DATEADD, DATEDIFF) rather than complex conditional logic
- Use the most efficient type of calculation: table calculation, level of detail expression, aggregate/view-level expression, row-level expression
- Use fastest possible data type (e.g. integers and boolean are faster than strings and dates)
- Use optimal aggregation (i.e. MIN and MAX are more efficient than ATTR or AVERAGE are, COUNTD is one of the slowest of all aggregations)
- Optimize use of external calculations (i.e. Python, R) if they are absolutely required
- Use fixed sizes for dashboards
If you need assistance to improve the performance of your Tableau dashboards, we would be happy to help! CONTACT US

Business Intelligence Road Map to Smarter Decisions
If your organization is having difficulty deriving greater insight, understanding, and intelligence from your data, you are not alone. Data is everywhere. But accessing, organizing, and making sense of it can be daunting.

Power BI vs Tableau – Which is Better?
Although Tableau and Power BI are similar business intelligence tools, there are key differences that organizations should be aware of when considering analytical requirement

6 Essential Data Visualization Best Practices
We have identified 6 Essential Data Visualization Best Practices. Adhering to these best practices makes it easier and faster for users to gain insight from large volumes of data and thereby make the best decisions for their business.

Optimus SBR Named as 2021 Great Place to Work
Optimus SBR has been named as Great Place to Work for a third consecutive year.

Executing on Round 2 of Municipal Modernization Program Reviews in Ontario: Should You Approach Them as a Marathon or a Sprint?
Our overview of areas of focus for the second round of the Municipal Modernization Program, Service Delivery Reviews themes, and advice on how to execute with the funds made available for this investment.

Optimus SBR named to the Growth List for 8th Consecutive Year!
Canadian Business named Optimus SBR on the 32nd annual Growth List!

Adapting in a New Era of Corporate Travel
Travel is one of the most impacted sectors hit this year due to COVID-19. Organizations need to begin to take a critical look at what corporate travel will look like in a post-COVID world.

Optimus SBR Named as 2020 Great Place to Work
For the second consecutive year, Optimus SBR is thrilled and honoured to be named on the 2020 list of Best Workplaces in Professional Services, and as one of this year’s Best Workplaces™ in Canada. This year, we’ve also been named to the inaugural list of Best Workplaces in Ontario.

The Driving Need to Reassess Processes & Controls Related to COVID-19 Responses
COVID-19 has thrust a massive amount of change onto financial institutions. Conducting a review of the processes and controls put in place during these unprecedented times is critical as financial institutions face an increasingly complex risk environment.

Pivoting When the World Changes: Getting the Most Out of Municipal Service Delivery Reviews in the New COVID-19 Reality
Municipal services matter, and not just the ones that people see. The ones that keep things humming behind the scenes matter too. And never has that been more apparent than during the COVID-19 pandemic.

How to Improve Analytics Capabilities and AAIM for Success
With technological advancement rapidly reshaping how we do business, a company’s ability to leverage data to make more informed decisions is the key to staying competitive in today’s market.
Whether your organization is beginning their analytics journey or is further along in its analytics maturity, an objective analytics capabilities assessment focused on using data to make better decisions is an important first step to achieve your analytics goals.

Optimus SBR Named 2022 Most Admired Corporate Cultures™ Winner!
What a thrill it is to be honoured as a 2022 Most Admired Corporate Cultures™ Winner! This award celebrates the Bold Attitude and Entrepreneurial Spirit each of us embodies.