1. Create views
Lots of join operation would take more time. If you find yourself creating a data connection with many tables, you can create a view in the database for those joined tables. It will help to improve the performance of the dashboard. Also, it will simplify the view in dashboard designer.
2. Create initial filter
Filter data as early as possible. For example, if your dashboard shows data for a certain date range, time range, a specific set of regions etc., using initial filter at the earlier stage can help to improve the performance.
3. Remove unused columns
Reduced the number of columns in the table schema, from the dashboard designer view, by manually excluding the unused columns.
4. Avoid creating complex expressions
Following actions may contribute to the dashboard performance.
5. Avoid changing datatype
Datatype change in designer reduces the performance. If possible, do the datatype change in database itself.
6. Avoid using too many widgets
Don’t use too many widgets in one single dashboard. In case, if you have used more widgets, move to another dashboard using multiple dashboard option.
7. Aggregate the raw data
If the granularity of your raw data is higher than the data you intend to display, aggregate it to the smallest granularity you need. If possible aggregate the raw data instead of using "None" option or "Enable Data Grouping" option in dashboard.
8. Moving file type data to server
If you’re using file type database such as Excel, CSV, JSON, before connecting dashboard designer, move your data to another server like SQL. It will improve your overall dashboard performance.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|
|8390||02/09/2018||02/09/2018||Dashboard Platform||Dashboard Datasources|