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.