Building the Data Warehouse

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

The executive is interested in both negative and positive trends. If business is getting worse, why, and at what rate? What can be done to remedy the situation? Or, if business is picking up, who and what are responsible for the upturn? What can be done to accelerate and accentuate the success factors? Can the success factors be applied to other parts of the business?

Trends are not the only type of analysis accommodated by EIS. Another type of useful analysis is comparisons. Figure 7.3 shows a comparison that might be found in an EIS analysis.

Looking at fourth-quarter data, first-quarter data, and second-quarter data in Figure 7.3, the question can be asked, “Why is there such a difference in sales of new health policies for the past three quarters?” The EIS processing alerts the manager to these differences. It is then the job of the EIS analyst to determine the underlying reasons.

For the manager of a large, diverse enterprise, EIS allows a look at the activities of the enterprise in many ways. Trying to keep track of a large number of activ-


1st    2nd    3rd    4th    1st    2nd

qtr    qtr    qtr    qtr    qtr    qtr



300 200


new life policies new health policies new casualty policies

Figure 7.3 Why is there an extreme difference in sales of new health policies for the past three quarters?

ities is much more difficult than trying to keep track of just a few activities. In that sense, EIS can be used to expand the scope of control of a manager.

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