We’ve all been there. You set out to build what you thought would be a great Tableau dashboard. When it’s all done, you realize the filter selections are lagging, charts are taking forever to load, and users are asking you what’s wrong with their report.  

Slow dashboards don’t just frustrate people; they also slow down decision-making. They chip away at trust in the data (or the tool) and push users back toward old habits like static reports and spreadsheets. 

The good news is that most performance issues are fixable. In this two-part series, I’ll share 10 practical techniques to help your dashboards run faster and make a better impression. 

In Part 1, we’ll focus on the data and query side, where the most significant performance gains usually happen. These five techniques focus on reducing the amount of work Tableau has to do behind the scenes. 

1. Use Tableau’s ‘Workbook Optimize’ Feature

Have you checked your dashboards with Tableau’s built-in Workbook Optimizer? 

If you’re using Tableau 2022.1 or newer, you have a built-in performance booster at your fingertips. You can launch it from the Server menu by selecting Run Optimizer in Tableau Desktop, or within the publishing options when uploading to Tableau Cloud or Server. 

[Figure 1–Run Optimizer in the Server Menu] 

The Workbook Optimizer scans your workbook and checks it against Tableau’s best-practice guidelines so you can spot potential performance or design issues before publishing. 

When it’s done, Tableau groups the results into three categories: 

• Take Action: Items that can affect performance or usability but don’t change functionality (for example, unused fields or data sources) 

• Needs Review: Recommendations that may take more time and effort. You decide whether the performance gains are worth it. 

• Passed: Best practices your workbook already meets or items you’ve intentionally left as is. (for example, Tableau might flag multiple LODs as a concern, but you’ve determined they’re necessary). 

[Figure 2–Workbook Optimizer Results] 

Each recommendation explains why it matters and how to fix it, with links to Tableau Help for more information. Some even let you apply changes automatically (like hiding unused fields). 

While the Optimizer doesn’t measure live performance, it’s the best place to start. It helps you clean up your workbook and make sure it’s aligned with Tableau’s best practices before you even hit publish. 

Quick Tips 

• Run the Workbook Optimizer early and again before publishing 

• Start with the ‘Take Action’ items for fast, high-impact improvements 

• Use the auto ‘Fix’ option when available to save time 

2. Use Performance Recording to Find Bottlenecks

Have you tested your dashboard’s performance with Performance Recording? 

After you’ve optimized your workbook, the next step is to see what else may contribute to slow load times. Tableau’s Performance Recording feature helps you identify where performance bottlenecks are occurring so you can focus your fixes where they’ll have the biggest impact. 

To use it, go to Help → Settings and Performance → Start Performance Recording, then interact with your dashboard like a typical user. When you stop the recording, Tableau opens a workbook that breaks down the timing of each action you made so you can see where delays occur. 

The performance results might look a bit technical at first glance, but here’s what to focus on. The Timeline view shows the sequence of events and how long each one took, while the Events view lists them by duration so you can quickly spot your biggest performance bottlenecks. Long-running queries, slow rendering, and complex calculations are usually the top culprits behind slow dashboards. 

[Figure 3–Performance Summary Dashboard] 

Performance Recording is one of Tableau’s most valuable diagnostic tools. It helps you focus your efforts where they matter most, so you can fix issues confidently instead of relying on trial and error. If you’d like to dig deeper, Tableau’s documentation on how to interpret a performance recording walks through each step in more detail. 

Quick Tips: 

• Run Performance Recording early and after major changes 

• Focus on the events or queries that take the most time 

• Use the results to guide improvements 

The next few tips address common performance issues that Tableau’s Optimizer or Performance Recording often uncovers, from heavy data sources to complex calculations. Each one helps Tableau work smarter behind the scenes, so your dashboards load faster and perform better.

3. Limit the Number of Records and Fields

Are you only bringing in the data you need? 

Now that you’ve identified what’s slowing your dashboards down, start by taking a good look at your data. Any column or row that’s present in your data source can hinder performance, regardless of whether it’s used in your dashboards. 

Make sure you’re filtering your data source only to include the rows you need. For instance, do you really need to include data from several years ago, or will you only need the last 12 months? 

Next, be sure to hide any fields you don’t use in your visualizations. Right-click on these fields in the Data pane and choose ‘Hide’. Alternatively, you can hide all unused fields at once by clicking the drop-down arrow at the top right of the Data pane and selecting ‘Hide All Unused Fields’ — or let Tableau do it automatically when you run the Optimizer. 

[Figure 4–Hide All Unused Fields] 

Also, consider aggregating your data outside Tableau when possible. Tools like Tableau Prep can pre-summarize values before they ever hit your workbook. For instance, if you have a large data source that includes every individual hospital visit, you can use Prep to calculate total visits per month or average length of stay per facility. Then, when you connect Tableau to that summarized dataset, it has far less data to process, making dashboards load faster and feel smoother.  

Quick Tips 

• Apply data source or extract filters to reduce the number of rows 

• Hide unused fields to reduce the number of columns 

• When possible, aggregate your data before bringing it into Tableau 

4. Use Extracts Instead of Live Connections

Are you connected to an extract?

Live connections are great when you genuinely need real-time data, but they can slow down dashboards, especially when dealing with large data sources. Unless you absolutely need real-time updates, use a Tableau extract instead. Extracts are local, columnar data files that are optimized for speed. They reduce the burden on your database and let Tableau handle queries faster. 

To switch from a live to extract connection, right-click your data source name and choose Extract Data. Alternatively, you can toggle the connection from ‘Live’ to ‘Extract’ on the Data Source tab.  

As mentioned earlier, it’s worth taking a moment to trim your data with filters and field cleanup — those small steps go a long way toward keeping your extract lean and efficient. Once you’ve done that, save the extract and publish your workbook to Tableau Server or Cloud to schedule automatic refreshes. 

[Figure 5–Switching a Data Source from a Live Connection to an Extract on the Data Source Page] 

Quick Tips 

• Use extracts unless real-time data is essential 

• Keep extracts small with extract filters and hidden fields 

• Schedule refreshes on the Server or Cloud instead of relying on live queries 

5. Optimize Calculations and LOD Expressions

Are your calculations efficient? 

Heavy calculations can quietly drag down dashboard performance, often in ways that aren’t obvious at first. Even a few inefficient expressions can add up, especially when they’re applied across large datasets or used repeatedly in multiple worksheets. 

A good starting point is to keep your logic as simple as possible. For example, using a CASE statement instead of several IF statements can make calculations easier to read and faster to process. If your calculations are complex or repeated across multiple views, consider moving that logic upstream into Tableau Prep or your database, where it can be handled once rather than recalculated every time the view updates. 

Level of Detail (LOD) expressions, particularly FIXED LODs on fields with lots of unique values, can slow things down if you’re not careful. The same goes for table calculations, which are processed locally after Tableau pulls the data, so large datasets can make them sluggish. Use these calculations strategically and monitor their impact with Tableau’s Performance Recording to keep your dashboards running smoothly. 

Quick Tips 

• Simplify logic whenever possible 

• Push heavy calculations upstream to Prep or your database 

• Watch out for FIXED LODs on high-cardinality fields 

• Use table calcs sparingly and test their impact 

A little cleanup here goes a long way. Minor calculation improvements often lead to surprisingly significant performance gains. 

Closing

These five tips focus on the data and query layer, where most performance issues arise. By tightening up your sources and calculations, you make Tableau’s job easier and your dashboards faster. 

In Part 2, we’ll move to the design and interaction layer, where your layout choices, filters, and load order have a big impact on how fast a dashboard feels to your users. 

Stay tuned for five more techniques to help your dashboards feel just as fast as they run!