Could Someone Give me Advice for Optimizing Sisense Dashboards for Performance?
Hello there,
I have been working with Sisense for several months now and have created a number of dashboards for my organization. While they are functional and provide the insights we need; I have noticed that some of the dashboards are starting to slow down as the data grows. I am looking for advice on best practices to optimize dashboard performance; especially as data volumes increase.
Some of my dashboards take a while to load; especially those with multiple widgets and complex calculations. What are the key factors that impact load time; and how can I minimize them?
I am currently using several Elasticubes to pull data into Sisense. What are the best practices for designing Elasticubes that are optimized for performance? Should I be considering different strategies based on the type of data I am working with?
I have implemented several filters and drill-downs to allow users to explore the data; but I have noticed that these features sometimes slow down the dashboard when applied. Are there specific techniques to improve performance when using filters and drill-downs?
I am aware that the way queries are structured can significantly impact performance. Are there any specific query optimization techniques or tools within Sisense that can help?
Also, I have gone through this post;Â https://community.sisense.com/t5/product-and-website-news/minitab-performance-insights-why-sisense-offers-a/ba-p/20121 which definitely helped me out a lot.
I want to ensure that my dashboards remain responsive and efficient; even as our data continues to grow.
Thank you in advance for your help and assistance.
DRay
·1 year agoHi Padrickk,
Can you let me know if that KB doc helped?
DRay
·1 year agoHi Padrickk.
Just checking in to see if that KB doc helped. Can you let me know how you are doing?
Thank you.
DRay
·1 year agoHi Padrickk.
Thank you for reaching out. Can you take a look at this KB and let us know if it helps? https://community.sisense.com/t5/knowledge/maximize-dashboard-performance/ta-p/9483#:~:text=Presenting%20too%20much%20data,-Presenting%20large%20amounts&text=The%20web%20server%20has%20to,per%20dashboard%20for%20optimal%20performance.