Guidelines to optimize the loading speed and performance of Adriel BI dashboards
Adriel dashboards are designed to handle complex data visualization needs efficiently. However, dashboard performance can be affected by how they’re configured and used. Here are some best practices to help you optimize loading speed and performance.
Navigation Summary
- Manage the Number of Widgets
- Adjust Data Ranges
- Optimize Data Source Connections
- Streamline Filter Usage
- Use Custom Breakdowns and Metrics Efficiently
1. Manage the Number of Widgets
- Keep the number of widgets on a single dashboard to 25 or fewer.
- Each widget pulls data from one or more sources, and too many widgets can increase the processing time.
- Combine similar data visualizations where possible to reduce the overall widget count.
Pro Tip: Use overview widgets to aggregate key metrics instead of displaying multiple granular-level single metric widgets.
2. Adjust Data Ranges
- Narrow data ranges can significantly improve performance, as fewer records need to be processed.
- For example, viewing data for the last 30 days instead of the last year will load faster.
Pro Tip: Use dynamic date ranges (e.g., "Last 7 Days" or "This Month") to automatically limit the data scope without manual adjustments.
3. Optimize Data Source Connections
- Limit the number of data sources connected to each widget to 5 or fewer.
- Each connection increases the query complexity, which can slow down the dashboard.
- Using Data Source Filters can be a fast way to limit the number of data sources for an entire Teamspace or View.
4. Streamline Filter Usage
- Filters can be applied on the Teamspace, View, and Widget level. While effective use of filters to minimize the loaded data set will increase speed and performance, using many complex AND/OR filters across different levels can create query complexity and increase the loading speed.
- Aim for 5 or fewer unique filter conditions per dashboard and limit the usage of multiple OR filters.
- When multiple data sources are selected, apply specific data source filters cautiously.
- Multiple data sources + applying filters across different levels = Increased processing time.
- Filters on one level = Faster loading and smoother performance.
Use Case Example: To optimize dashboard performance, apply a "Campaign Name" filter at the Teamspace or View level to limit the dataset to only relevant campaigns. Use a complex "Keyword" filter at the Widget level for targeted analysis, ensuring minimal query complexity and faster loading speeds.
5. Use Custom Breakdowns and Metrics Efficiently
Best practices for managing Breakdowns:
-
Limit the Number of Labels:
Each additional label in a custom breakdown increases loading time. Focus on the most critical dimensions to streamline performance. -
Simplify Conditions:
Avoid using multiple AND/OR conditions as they significantly increase processing time. Overly complex filter conditions are a common cause of slow widget performance.
Best practices for managing Metrics:
-
Use Metrics Without Filters Where Possible:
To maintain optimal performance, avoid applying filters directly to custom metrics unless absolutely necessary. Best to utilize filters on the View- and Teamspace- levels, when possible.
- Custom breakdowns with a high number of labels or complex conditions (e.g., AND/OR logic) tend to cause the most significant slowdowns.
- Custom metrics with filters are a primary factor in reducing dashboard responsiveness. Without filters, metrics generally do not affect performance.
By following these guidelines, you can significantly improve the performance and loading speed of your Adriel dashboards. Optimizing dashboards not only enhances the user experience but also ensures that you can access critical insights quickly and efficiently.
If performance issues persist, please fill out our support form or contact our support team directly at support.global@adriel.com and we’d be happy to help with personalized recommendations!