Building the Data Warehouse

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


■■ Key ratio indicator measurement and tracking


■■ Drill-down analysis


■■ Problem monitoring


■■ Competitive analysis


■ Key performance indicator monitoring

A Simple Example


As an example of how EIS analysis might appear to an executive, consider Figure 7.1, which shows information on policies offered by an insurance company. Quarter by quarter, the new life, health, and casualty policy sales are tracked. The simple graph shown in Figure 7.1 is a good starting point for an executive’s probing into the state of the business. Once the executive has seen the overall information, he or she can probe more deeply, as shown by the trend analysis in Figure 7.2.


In Figure 7.2, the executive has isolated new casualty sales from new life sales and new health sales. Looking just at new casualty sales, the executive identi-


executives and EIS









new life policies new health policies new casualty policies


qtr    qtr    qtr    qtr    qtr    qtr


new casualty policies


Figure 7.2 Trends—new casualty policy sales are dropping off.


fies a trend: New casualty sales are dropping off each quarter. Having identified the trend, the executive can investigate why sales are dropping.


The EIS analysis alerts the executive as to what the trends are. It is then up to him or her to discover the underlying reasons for the trends.

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