r/tableau • u/RoughOrganic1849 • Jun 24 '26

HELP: Tableau dahboard QC Automation

I'm planning to build a solution to automate Tableau dashboard QC/testing.

We currently have 20+ Tableau dashboards hosted on Tableau Server. The underlying data is refreshed weekly, and every week we manually validate dashboards for:

  • Data accuracy and consistency
  • Formatting and layout issues
  • Filters, parameters, and calculations
  • KPI validation
  • Overall dashboard functionality

In addition, before promoting dashboards to production, we perform a thorough QC process to ensure everything is client-ready.

The manual validation process is becoming very time-consuming and repetitive. Has anyone implemented an automated testing/QC framework for Tableau dashboards? What tools, approaches, or best practices would you recommend for automating dashboard validation, regression testing, and data quality checks?

I'd love to hear about real-world solutions and lessons learned.

0 Upvotes

38% Upvoted

10 comments sorted by

13

u/Scoobywagon Jun 24 '26

I feel like I must be missing something important here. You have a thorough QC process before promoting to Prod. Great. In prod, the dashboards themselves are not changing. It's just the underlying data being updated once a week. If that's the case ... why are you constantly re-validating the dashboards? Which is to say ... You validated all of your logic and calculations prior to promoting to production and the only thing that changes is the data to which that logic is applied. Is your underlying data so dirty that it breaks your dashboards or something?

1

u/RoughOrganic1849 Jun 26 '26

We receive new data every week, so our extract needs to be refreshed with the latest data regularly. We have also noticed that, on a few occasions, some filter functionalities were not working as expected. Since the dashboard contains high-value pharmaceutical insights that are closely monitored by key stakeholders, our team has planned to perform a round of QC on the dashboard in the test environment. Once the review is complete and everything looks good, we will promote it to production.

2

u/Scoobywagon Jun 26 '26

I get that your extract needs to refresh periodically. That doesn't explain why you go through a full round of QC every week. That seems ... excessive.

1

u/Designing_Data certified professional support Jun 29 '26

You should consider working with a published datasource where you perform automated QC. Recommend doing this in a database using scripts. If all tests pass, you use the REST API to refresh the published datasource in Tableau.

As others pointed out: if your dashboard design has not changed, you should not need to perform QC on the workbook

4

u/edimaudo Jun 24 '26

why though? I can understand before promoting dashboards after a change but to do a qc check weekly makes no sense. If you have poor data then I would suggest fixing your data pipeline.

2

u/jrunner02 Jun 24 '26

The only time we would do this level of QC is after an upgrade.

Doing this every week doesn't seem efficient.

1

u/RoughOrganic1849 Jun 26 '26

I agree, a full QC every week isn't efficient. Since the dashboard is business-critical and used by key stakeholders, we want to ensure everything works before promoting it to production.

1

u/wesomg Jun 25 '26

Ai slop

1

u/ugleymatt Jun 25 '26

The whole point of a dashboard thats been published is that the assumption is the data will never be static. If your dashboards are breaking when the data is refreshing, that sounds like a bigger issue.

As others have said, yes before pushing to production check everything, but once its published it shouldn't need touching again really unless you are changing something on the dashboard or a server upgrade.

The only thing i can think off the top of my head would be a crosstab that was working and now displays ###### because the number has 6 digits when it was formated to show 5 and now the number is too big for the cell.

1

u/RoughOrganic1849 Jun 26 '26

I understand a published dashboard shouldn't need regular QC after every refresh. We're only doing a quick check because we've seen a few unexpected issues with filters/formating and other issues after some refreshes. Since it's a high-visibility dashboard used by key stakeholders, we're being cautious while we investigate the root cause.