data visualization program architecture diagram

In some cases this in-memory engine is not needed. Since database queries are often too slow to get the required response time, most dashboard tools have an in-memory engine that contains the complete dataset so that changing selections or drilling-down goes very quickly.

The possibility to drill-down means that the dataset should not only contain the highly aggregated data but also all the details behind it. The data set should not only contain the data that is shown in the dashboard, but also all data that could possibly be shown in the dashboard based on all the selections that the user can make. The flexibility of the dashboard and the possibility to drill-down, however, has some consequences on the data set. Showing information visually has many benefits. A very popular feature of most dashboards is the ability to drill-down from an overview of the data to a more detailed and granular view to see a more specific part of the data. Dashboards are often highly configurable to change how the data is visualized or which details are shown. Dashboards usually represent the information using graphs, tables or KPI cards its purpose is to provide the information at a glance to quickly give an overview on the performance of the business. A business intelligence (BI) dashboard is a data visualization tool that displays information about key business performance indicators (KPIs) or other metrics.

Data visualization program architecture diagram