Profile picture for user Eva Klein

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.


    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.


    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 :).

Featured achievement

Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks


icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock