Page 65 - CITP Review

12
Exhibit 2-2 — BI tools
Data management DBMS
ETL
DW and data marts

Reporting — General purpose OLAP
EIS
DSS
Dashboards

Reporting — Visualization OLAP
EIS
Dashboards

Reporting — Strategic and performance BPM
management Dashboards
Balanced scorecards

Business intelligence Data mining
Other mining (web, text)

The visual tools are EIS, OLAP, and dashboards — some of same tools as general reporting. OLAP uses
the cube method and the results are natural subjects for visualization — for example, sales by territory,
sales by period of time, sales by category and time, which can be visualized in bar graphs or line graphs.

Typically, EIS summarize a specified area of data into a single visual for executives (sometimes actually a
dashboard). Dashboards are particularly suited for visualization. When reports are generated to compare
actual results to budgets or predictions, that comparison can easily be reported with visual results.

For example, if results are on target or within expected parameters, the cell or figures are often colored
green. If results are slightly off target, slightly behind expectations, the result is shown in yellow (caution).
If results are behind by some designated degree, the result is shown in red (alarm).

The strategy and performance management reporting tools include business performance management
(BPM), dashboards, and balanced scorecards. BPM is specifically for the purpose of business
performance management. Dashboards provide the kind of information that can measure performance
or strategic information. Balanced scorecards, which have been around in manual and technology form
for many years, provide a holistic evaluation of the entity’s performance.

12
Efraim Turban, Ramesh Sharda, Jay E. Aronson, and David King, Business Intelligence. (Upper Saddle River, NJ:
Pearson, 2008), 32.

© 2019 Association of International Certified Professional Accountants. All rights reserved. 2-19