Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»

But trend analysis and comparisons are not the only ways that the manager can use EIS effectively. Another approach is to “slice-and-dice.” Here the analyst takes basic information, groups it one way, and analyzes it, then groups it another way and reanalyzes it. Slicing and dicing allows the manager to have many different perspectives of the activities that are occurring.

Drill-Down Analysis

To do slicing and dicing, it is necessary to be able to “drill down” on data. Drilling down refers to the ability to start at a summary number and to break that summary into a successively finer set of summarizations. By being able to get at the detail beneath a summary number, the manager can get a feel for what is happening, especially where the summary number is surprising. Figure 7.4 shows a simple example of drill-down analysis.

In Figure 7.4, the manager has seen second-quarter summary results and wants to explore them further. The manager then looks at the regions that have contributed to the summary analysis. The figures analyzed are those of the Western region, the Southeast region, the Northeast region, and the Central region. In looking at the numbers of each region, the manager decides to look more closely at the Northeast region’s numbers.

New York

Massachusetts’ Connecticut Pennsylvania New Jersey Virginia

Maine, RI, Vermont



To make sense of the numbers shown by EIS, the numbers need to support a drill-down process.

Скачать в pdf «Building the Data Warehouse»