What is a business dashboard?Definition: A business dashboard is a multi-layered application, built on a business intelligence and data integration infrastructure that allows organizations to monitor, analyze and manage business process more effectively. This definition suggests that a dashboard is an application that is wired to the organization’s database/ERP system from where it draws data and presents it in a meaningful way. The fact that a dashboard is multi-layered implies that it presents different hierarchical views of data. Using a dashboard; executives can monitor, analyze and manage a business process.
How do people interact with a dashboard?Dashboards are all about visualizing data. According to Wayne Eckerson, the director of research and services for TDWI (The Data Warehousing Institute) and a leading authority on business dashboards – business dashboards should allow visualization of data at three levels:
- Summarized view
- Multi-dimensional view
- Detailed view
As suggested in the definition above, a business dashboard should let users monitor, analyze and manage business processes. The summarized graphical view of the dashboard allows a user to monitor a business process. In case there is a problem in the process flow, the user drills-down to the next level which is the multidimensional layer. The multidimensional layer provides a much detailed view of data, thereby allowing the user to determine the cause of the problem. Sometimes, the cause of the problem cannot be detected in the multidimensional layer – so the user has to drill-down further to the detailed view layer. The detailed view layer provides details of individual transaction and from here the user can easily identify the fundamental cause of the problem.
Architecture of a DashboardWhile building a dashboard application, planners and developers should establish well defined levels of abstraction with respect to data. This not only makes the application user friendly, but also makes it deployable at all levels of organizational hierarchy. As discussed previously in conjunction with end user interaction with dashboards, a dashboard should present data across three levels, viz; summarized view, multidimensional view and detailed view. Following are the design specifications for each data presentation layer of the dashboard:
- Summarized view: This is the topmost layer of a business dashboard and it should display essential KPIs graphically (i.e. using graphs or gauges). The layer must also have an in-built control mechanism that triggers an alert when a KPI exceeds or drops below the normal value range.
- Multi-dimensional view: This layer should supplement the metrics displayed in the top layer with additional data. Analytical tools must be built into this layer in order to allow users to perform computational analysis on data.
- Detailed view: This layer should facilitate users to view reports pertaining to individual transactions (e.g. invoices, shipments etc).