Could Someone Give me Advice for Optimizing Sisense Dashboards for Performance?

Padrickk · ‎08-22-2024

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.