Tableau Ambassador • Making Data Literacy Accessible to All • RetailTUG Leader • DVS Mentor
Do you struggle with Dashboard Performance in Tableau? Does it take > 10 seconds for your dashboard to render? If you answered 'Yes', read on. This is a deep and wide topic, I will break it down for you over this week and the next. Today, I will start with the data source. 1. Custom SQL in Tableau - avoid it in Live Connections, if you can (check the detailed explanation from Chris in comments) 2. Leverage the power of the Hyper-engine 3. Bring in the tables and create a relationship 4. Hide 'Unused Fields' 5. Make an extract of the data (works in most cases) Do you use Custom SQL in your Data Source? Did you know how to hide 'Unused Fields'? Like, Share and Follow #DataAnalytics #DataVisualization #Tableau #DataFam #DataViz
What are your reasons for advising to avoid custom SQL if possible? If you are SQL savvy, then I find this to be a great way to ensure the minimal amount of data is used/processed to support a dashboard’s data sources. If the opposite is true, then yes - stick to low or no-code solutions.
And the dashboard optimizer
When I first used the Workbook Optimizer, I learned that although I had been working with Tableau for a while, I had no idea this was an option that would improve my Dashboard's performance. Thanks for sharing, Ojoswi Basu!
Tableau Ambassador • Making Data Literacy Accessible to All • RetailTUG Leader • DVS Mentor
11moCheck out my other posts on Tableau Performance best practices Day 1: Data Source https://rb.gy/yiaj9w Day 2: Impact of Filters https://rb.gy/f1a2d0 Day 3: Visual Rendering https://rb.gy/ea52g0 Day 4: Calculation Best Practices https://rb.gy/duxcgg Day 5: Diagnostic Tools https://rb.gy/gvemf4