top of page

Welcome
to NumpyNinja Blogs

NumpyNinja: Blogs. Demystifying Tech,

One Blog at a Time.
Millions of views. 

How to Make Your Tableau Dashboard Run Smoothly?

Practical Filter Tips to Boost Speed, Reduce Load Time, and Improve User Experience:


A fast, responsive Tableau dashboard isn’t just a “nice to have”—it’s essential, especially when you’re working with large datasets like healthcare records, patient encounters, or operational metrics. Slow dashboards frustrate users, interrupt workflows, and reduce trust in the data.


If you’ve ever clicked a filter and watched Tableau pause…

or waited for a dropdown to load…

or wondered why a simple view takes forever to refresh…


Good news is that most of that slowness is avoidable.

The biggest performance killers often come from filters—how many you use, what type they are, and how they’re configured.


In this vlog, I’m using a Sepsis Analysis dataset dashboard as an example so you can clearly see how each filter tip applies to a real clinical scenario. Each tip will show how the concept applies directly to a real sepsis project, so you can see exactly how it improves performance in a real‑world scenario.


For anyone who isn’t familiar with sepsis or clinical datasets: sepsis is a life‑threatening condition caused by the body’s extreme response to infection, and healthcare datasets often track patient vitals, labs, and outcomes to help analyze it. These datasets typically include fields like Heart Rate, Blood Pressure, Temperature, Lactate Level, WBC Count, and Sepsis Flag , Hospital admission time etc.



1. Use Efficient Filters

Not all filters are created equal. Some are naturally faster because they require less work from Tableau.

Dimension filters are always faster than measure filters.

Why?

• Dimensions are already grouped

• Measures require extra computation

• Calculated fields add even more processing time


In the sepsis dashboard, filtering by Admission Type, Hospital Unit, or Sepsis Category is much faster than filtering by Sepsis Score or Length of Stay. These measure fields require Tableau to calculate values every time, which slows things down. Choosing dimension filters first makes the sepsis dashboard respond quickly and feel lighter.


2. Reduce the Number of Quick Filters

Quick filters are convenient—but they’re also expensive.

Every quick filter (dropdown, checkbox, slider, etc.):

• Sends a query to the database

• Refreshes every chart on the dashboard

• Recomputes values each time the view changes

Multiply that by 5–6 filters, and performance drops fast.

Better approach:

• Keep only the essential filters

• Replace the rest with parameters

• Use action filters to let users click charts instead of using dropdowns.


In the sepsis dashboard, instead of having many dropdowns like Unit, Severity, Age Group, Admission Time, and Gender, you can use a parameter to switch between ICU and Hospital views and use action filters to filter by clicking charts. This reduces the number of dropdowns and makes the sepsis dashboard load much faster.


3. Avoid High Cardinality Filters

High cardinality fields have many unique values, and loading them takes more time because Tableau must scan a long list. These filters should be avoided unless absolutely necessary. Instead, use higher‑level fields that have fewer values.


In sepsis dashboard using ,

  • Patient ID

  • Visit ID

  • Claim Number

  • Diagnosis Description

These fields slow Tableau down because it must scan thousands of values before showing the list.

Better choice: Use higher‑level fields like:

  • Unit

  • Admission Type

  • Sepsis Category

These are easier for Tableau to process and easier for users to understand.


4. Use “All Values in Database

Sometimes Tableau loads only the values currently visible in the view, which causes the filter list to refresh again and again. Choosing “All Values in Database” keeps the full list ready and prevents unnecessary reloading. This improves performance and saves time.


In the sepsis dashboard, the Hospital Unit list may reload every time the date filter changes, which slows things down. Using “All Values in Database” keeps all units available at all times, so the filter responds faster and the dashboard feels smoother.




5. Use the Apply Button:

When multiple filters are used, Tableau refreshes the view after every click.

That means:

• Click 1 → refresh

• Click 2 → refresh

• Click 3 → refresh

That’s three unnecessary refreshes. So turning on the Apply button allows users to make all their selections first and then apply them at once. This reduces the number of refreshes and speeds up the dashboard.


In the sepsis dashboard, if a user selects Date, Unit, and Admission Type, Tableau normally refreshes three times. With the Apply button, it refreshes only once, saving time and making the dashboard feel much smoother and more efficient.




6. Use “Include” Instead of “Exclude”:

Exclude filters are slower because Tableau must scan all data to remove unwanted values.

Include filters are faster because Tableau keeps only what you select. This simple change can improve performance.


In the sepsis dashboard, instead of excluding Non‑Sepsis patients, it’s better to include only Sepsis patients. Tableau then processes a smaller amount of data, which helps the dashboard load faster and makes filtering more efficient overall.




7. Use Continuous Date Filters:

Continuous date filters are faster because they group data into ranges, while discrete date filters show every single date and create more marks. Fewer marks mean faster charts and smoother performance.


In the sepsis dashboard, using a continuous filter like “Last 30 Days” is much faster than listing every date individually. This reduces the number of marks on the chart, helps Tableau load the sepsis trend quickly, and gives users a smoother experience.



8. Use Wildcards or Custom Lists:

Text fields often contain many values, and loading the full list can slow down the dashboard. Using wildcard searches or custom lists avoids loading thousands of values at once and improves performance.


In the sepsis dashboard, if we have a field named Diagnosis Description which has too many text values, Tableau becomes slow when it tries to load all of them. Instead of showing every diagnosis, we can use a wildcard like “contains sepsis”—this shows only diagnoses related to sepsis—or create a small custom list of common sepsis terms to keep the filter short and fast.





 9. Use Boolean or Number Filters:

Filtering on text takes longer because Tableau must compare strings, while numbers and Booleans are much faster to process. Converting fields into numeric or TRUE/FALSE values improves speed and reduces filter load time.


In the sepsis dashboard, instead of filtering by text like “Severe Sepsis,” you can create a field like If sepsis = true. Filtering TRUE/FALSE is quicker, and Tableau processes fewer comparisons, making the dashboard respond faster.




Now you can see Why Smart Filter Design really Matters :


When we use filters the right way, Tableau stays smooth, fast, and easy for users to interact with. These best practices help Tableau avoid unnecessary work and keep the dashboard responsive, even when the dataset is large. By choosing lighter filters, reducing the number of dropdowns, and using smarter options like continuous dates, boolean fields, and wildcards, we make the dashboard more efficient. This leads to quicker load times, cleaner interactions, and a better overall experience for anyone exploring the data. In the end, good filter design helps users focus on insights instead of waiting for the dashboard to refresh.

+1 (302) 200-8320

NumPy_Ninja_Logo (1).png

Numpy Ninja Inc. 8 The Grn Ste A Dover, DE 19901

© Copyright 2025 by Numpy Ninja Inc.

  • Twitter
  • LinkedIn
bottom of page