Tableau is widely used to create visualizations and dashboards to analyze various kinds of data and derive useful results. There are a few simple tricks to make the tableau dashboard more efficient:
- Do not join different types of sources: While creating visualizations we tend to join different data sets. It is important to consider the file types while performing joins. Joining a database to an Excel file and then to some other tableau extract. This can be hazardous for tableau performance. It takes a lot of time to fetch results from different file types and perform calculations based on it. It is crucial to not join too many different file types for better performance.
- Calculations should not be too complex: If the data needs to be processed by performing way too many complex calculations, it should be done in the source file and not tableau. Tableau calculations should be kept short and simple. It helps to perform calculations faster and retrieve results in a short time.
- Reduce number of report in the dashboard: Too many reports in a dashboard takes a lot of loading time. The number of reports in a dashboard should be precise and too the point. There is no use in creating a new report to visualize every small detail. The reports should be made efficient by displaying right amount of information. This helps improve tableau performance.
- Do not bring unwanted data: Before loading the data into tableau, it is important to performs checks whether all the data is necessary for visualization. If some columns or rows are not needed for the visualization, they can be filtered out before bringing them into tableau. Too much of data results in increase in parsing time which reduces tableau efficiency.
- Use Parameters instead of Quick Filters: Using parameters helps reduce load time of the dashboard. The user can insert the values in parameters to see results related to the input. Quick filters displays all the possible results a user can see but it leads to increase in loading time of the report.
By following these simple rules, efficiency of tableau dashboard can be increased.
Reference: https://www.excella.com/insights/top-5-tips-for-getting-the-most-out-of-your-tableau-dashboard