![tableau dashboard tableau dashboard](https://www.ryansleeper.com/wp-content/uploads/2018/01/Tableau-UI-KPI-Example-Dashboard.png)
Push as much work as possible to database or ETL.Īn extract is a columnar data store, the wider the data set, slower the query performance Tableau Server is not intended to be a replacement for a data warehouse. The key is to use domain-specific data sets. While many of the recommendations offered in this document will have a positive influence on scalability for workbooks published to Tableau Server, the principal focus of this document is about improving performance.ĭata Strategy has the most impact on the performanceĮxtracts are typically much faster to work with than a live data source. Performance is about ensuring that an individual workbook runs as quickly as possible. Scalability is about ensuring that we can support multiple users viewing shared workbooks. Scalability is not the same as performance Other environmental factors such as hardware configuration and capacity.Some differences between Tableau Desktop and Tableau Server.The data connections and underlying data sources.how much data is returned, is it custom SQL what kind of calculation, where is the calculation performed, etc. how many elements, how many data points, use of filters and actions, etc. The visual design at both the dashboard and worksheet levels – e.g.The performance of a dashboard is impacted by: This is a subjective measure but in general we want a workbook to provide an initial display of information and to respond to user interactions within seconds. Fast – Does the workbook respond quickly enough for the users? This could mean time to open, time to refresh or time to respond to interaction.Flexible – Can the workbook answer multiple questions the users want to ask, or just one? Does it engage the user in an interactive experience or is it simply a static report?.Simple – Is it easy to create the workbook and will it be easy to maintain in the future? Does it clearly communicate the message of the author and the data?.Some of these factors are technical and some more user-focused but in general an efficient workbook is: There are several factors that make a workbook efficient.