Dashboard Performance Best Practices

In this article, we are going to map some of Sisense Dashboard Design Best practices related to performance. When you start developing a dashboard or when you want to simply improve its performance, take a look at the guidelines below and adjust your dashboard accordingly. 

Avoid Wide or Long pivot tables

  • Reduce the number of columns
  • Filter the number of rows (Top filter on value)
  • Consider Table widget or Aggregated Table plugin

Avoid many members in charts 

  • Wide X-axis in Line / Column charts
  • Many members in “break by
  • Use Drill hierarchies 

Always consider the number of widgets

  • Recommended 7-10 widgets 
  • Consider the number of elements (filters/texts)
  • Use drill dashboards (Accordion / Jump to

Avoid dashboard date functions

  • Date functions in the dashboard are re-calculated in the front end (Qdiff, MTD) 
  • Try to create the logic in the ElastiCube 

Avoid too many include/exclude values

  • Choose the lowest selection between the two
  • Consider using a higher hierarchy

Addons and customization

  • Make sure all the scripts are not colliding (console)
  • Disable un-used plugins

Performance issue and Possible Cause