Blog Posts Process Analysis Process Modeling

Improve the performance of your dashboards

Blog: Aris BPM Blog

Today, I want to say a few words about how you can improve the performance of your dashboards.

  1. Always select a performant data source, such as CSV.
     
  2. Data sources should include only the data columns that are really used.

    Avoid using files containing more data than required, for example, an XLS file from someone who is using such a file for reporting. In most cases, these files include a lot of sheets, formatting information, and data columns that you don’t need for your dashboard.

    Example:
    If a file includes 75 columns from which you actually use only 10 for your entire dashboard, all 75 columns are loaded every single time.

    I know that it is comfortable to take the file just as it is to create dashboards (I myself did it, too…), but creating a dashboard is easier if you first prepare the file by deleting all unnecessary information.
     

  3. Data feeds should filter at a very early stage (i.e., take columns out that are not relevant to the dashboard).
     
  4. Set data feeds to the highest possible cache time.
    – Data sources that aren’t changed often, e.g., once a week, should have a refresh rate of 24 hours.


     

  5. In the Assign data dialog, remove all columns that are no longer needed for the widget.

    Example:
    If you have a pie chart and need only column1 and column2, remove the other columns in the Assign data dialog.

I hope to have provided you with some interesting information :).

Forum: 

Leave a Comment

Get the BPI Web Feed

Using the HTML code below, you can display this Business Process Incubator page content with the current filter and sorting inside your web site for FREE.

Copy/Paste this code in your website html code:

<iframe src="http://www.businessprocessincubator.com/content/improve-the-performance-of-your-dashboards/?feed=html" frameborder="0" scrolling="auto" width="100%" height="700">

Customizing your BPI Web Feed

You can click on the Get the BPI Web Feed link on any of our page to create the best possible feed for your site. Here are a few tips to customize your BPI Web Feed.

Customizing the Content Filter
On any page, you can add filter criteria using the MORE FILTERS interface:

Customizing the Content Filter

Customizing the Content Sorting
Clicking on the sorting options will also change the way your BPI Web Feed will be ordered on your site:

Get the BPI Web Feed

Some integration examples

BPMN.org

XPDL.org

×