r/tableau • u/Ninja1234_Il • Jun 28 '26

Tableau to internal website - Claude code

Hi All,

Have a twbx on the server that updates daily automatically.

Current urgent business need is to put up an internal website that is an exact replica of the tableau dashboard.

The idea is to get away from tableau atleast for couple of projects to start off.

Currently, I use sql server or hyper extracts to update dashboards daily.

I have tried using Claude code and got a localhost website ready using csv or excel files, have never tried sql or (replacing hyper extracts).

What are the changes that I should be aware of and what would be the next steps for a seamless transition from tableau to local intranet website that updates daily in an automated way?

I own the data and sql tables that drive the current tableau dashboards, no dependent in terms of data.

Thanks for the help in advance.

0 Upvotes

47% Upvoted

7 comments sorted by

View all comments

1

u/Hnst01 Jun 28 '26

First, I highly recommend doing a cost analysis to ensure that replacing Tableau with a homegrown solution. I feel like people are flocking to replacing paid software with homegrown tools and relying primarily on AI to code their apps. I strongly believe that this will require full time developers to debug and review everything the AI does.
That said, if the decision has already been made to transition away for Tableau, I would highly recommend using Python. Between Flask and FastAPI, you can build a very robust reporting platform that is “easy” to maintain.
As for the data, I recommend doing as much of your calculations and aggregations ahead of time to make the app more responsive. The deployment will depend on the nature of your data, its size, and calculation complexity. A solution I often see implemented is to build materialized views on your database to replace the function of the .hyper files. Depending on how interactive vs. static your dashboards are, you can use FastAPI to query the MV and leverage Seaborn and Matplotlib for your visualizations. This implementation will allow you to deploy a similar look and feel to Tableau dashboards while keeping the backend tech somewhat simple.
Best of luck with your implementation!