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

Automate and Digitize: Where Should Credit Unions Start to Build Efficiency?
Credit unions that want to improve efficiency should start by identifying their pain points, building a business case for digitization/automation, conducting a pilot program, implementing quick wins, and exploring new opportunities.

CAO Leadership Series: Municipal Budget Development
Addressing the challenges of municipal budget planning requires a holistic and forward-thinking approach. It necessitates active and continuous engagement with community members, proactive risk reduction strategies, and efficient procurement practices.

Unlocking Security Excellence: Essential IAM & RBAC Best Practices for Robust Application Access and IT Risk Management
The rise of new technologies and the ever-evolving IT landscape have necessitated the implementation of a robust Identity and Access Management (IAM) system accompanied by a Role-Based Access Control (RBAC) framework.

How Canadian Credit Unions Can Leverage ESG Principles and Technology to Reach a Younger Generation of Members
The incorporation of ESG principles by CCUs, coupled with the effective use of technology and targeted marketing, presents a powerful strategy for attracting younger members and securing future growth.

Building High Performing Teams: The 8 Components of Resilience
In a world where change is the only constant, organizations are awakening to the undeniable truth – resilience is the secret weapon for survival and success.

Natural Language in Data Visualization: A Showdown Between Tableau and Power BI
Two industry-leading data visualization tools, Tableau and Power BI, both offer the ability to query data using natural language. But how do they stack up?

7 Drivers of Economic Development
These seven drivers of economic development bring new money into the municipalities, accelerate the velocity of money within the city, increase the engagement of citizens, and propel the generation of new ideas, technologies, talent, success stories, wealth, and global rankings.

Steering Through Uncertainty: The Impact of IFRS 17 on Risk Management and Control Strategies
With a strong emphasis on accuracy and integrity, insurers are faced with the task of redefining their control environments and governance structures for financial reporting.

Analytical Data Mart vs. Data Lake: Which Approach is Better for Your Analytics?
Welcome to the world of data-driven organizations where it is crucial to have a well governed repository to efficiently store and manage your valuable data.

Mastering IFRS 17 with a Strategic Target Operating Model
When applied specifically to the realm of IFRS 17, a strategic Target Operating Model provides a high-level view of the end-to-end solution design, processes, controls, and close schedule required to execute the new finance model.

The Push for Companies to Prioritize Leadership Development
Leaders have been expected to do more than ever in the past few years. Navigating through uncertainty, dealing with new challenges, and responding to rapid change have all become commonplace demands for management teams.

Navigating a Hybrid Work Environment with Gen Z Employees
Millennials, who have dominated the workforce for the past decade, are now ceding the stage to the next generation of employees – Generation Z.

Developing Early Career Talent: 5 Strategies for Success
A robust and effective early career talent development program is essential for companies looking to grow their future leaders from within.

How to Capitalize on Your IFRS 17 Investment
With guidance and support insurers can move from IFRS 17 compliance to business as usual (BAU) and fully capitalize on their investment.

Leading & Engaging Gen Zs – The Bold Approach
Gen Zs are the new age workforce that is gradually changing the landscape of the corporate world. Leading and engaging Gen Zs in this environment requires a bold approach.

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 requirements.