-
1. Re: How to Increase Dashboard perfomance
Aaron Clancy Nov 1, 2014 11:45 PM (in response to p Reddy)You should really include more details on a question like that so that we don't have to come back with questions like "What is your server setup? What is the complexity of the dashboard? Are you using an extract or not? Are you aggregating to the necessary level? Is your box taxed with other applications? Do you have adequate resources allocated to your server? Is there consistently high concurrency/usage of your Tableau Server? How many records are in your dataset? Are you using context filters heavily? Which version of TS are you using? How much faster are interactions for your dashboard on Tableau Desktop?
Answers to these questions could be a start to help troubleshoot why you're having performance issues.
I would also create a support case with Tableau if you think that there is something wrong with the server installation.
If your issue is not environment based, here's a good doc for creating efficient workbooks:
http://www.tableausoftware.com/learn/whitepapers/designing-efficient-workbooks
-
2. Re: How to Increase Dashboard perfomance
Dan Murray Nov 2, 2014 3:56 AM (in response to p Reddy)TThis is impossible to answer without a screenshot of your dashboard and some information on your datasource (spreadsheet? Database? Row count, column width). For a good guide in general on this see Chapter 8 of my book, Tableau Your Data! Available at Amazon and other major book sellers.
-
3. Re: How to Increase Dashboard perfomance
SathishKumar Parthasarathy Nov 3, 2014 4:42 AM (in response to p Reddy)General Thumb Rules for performance optimization.
a) Keep the Data set filtered from the Data Source as much as possible. e.g. use only one countries data if other countries data is never used in the reports. Higher the data volume, lower the performance of the reports.
b) Use Tableau Extracts as much as possible for non-volatile data sets. (batch Extract)
c) Keep Calculated columns to a minimum. Lot of calculations will affect the performance.
d) Check the Server Utilization, accordingly can upgrade the Server capacity. (more the CPU cores and memory, the faster the reports will be)
e) If you are using the Database, Tableau reports performance is directly related to the database performance
f) Check how many users are using the reports at the same time, concurrent users will affect the query performance.
The above are generic guidelines. Check and use them appropriately.
Thanks,
Sathish
-
4. Re: How to Increase Dashboard perfomance
p Reddy Nov 3, 2014 10:12 PM (in response to SathishKumar Parthasarathy)Thanks Sathish for your key points
On Mon, Nov 3, 2014 at 4:43 AM, SathishKumar Parthasarathy <