How to make report run faster or load faster, as My report is running very slow
I have two tables which has data in billions.. can I extract this huge amount of data in Tableau... Currently It's a live connection so report is running very slow..
what could be other option s to make report load faster? Can I extract billions of data in Tableau?
For performance, you have to think through the entire analytics stack:
-Storage
Network (Network transport can have issues within each layer)
-Database
Network
-Tableau Server
Network
-Dashboard
Network
Starting from a Tableau Dashboard perspective, @Bruce Segal comment above is the place to start, Performance Recording is your friend.
The links below will help from a Desktop/Dashboard performance perspective and what to think about.
Desktop Performance Recorder: https://help.tableau.com/current/pro/desktop/en-us/perf_record_create_desktop.htm
Tableau Workbook Performance Checklist: https://help.tableau.com/current/pro/desktop/en-us/perf_checklist.htm
If your dashboard is well designed, and it is slow, it can be the database. I would say 90% of the performance issues that I see are at the database level. Most are on-premise databases or companies that have moved from on-premise to online databases, but they didn't reshape the data to take advantage of newer database technology.
Not sure what your database is but I included a few whitepapers below for Snowflake and Google Big Query.
Database Performance:
BigQuery Best Practices: https://www.tableau.com/learn/whitepapers/google-bigquery-tableau-best-practices
Rapid Fire Analytics w/ Snowflake: https://www.tableau.com/learn/whitepapers/delivering-rapid-fire-analytics-snowflake-and-tableau
Tableau+Snowflake Blog: https://bigdatadave.com/blog-feed/
