Chapter 12.1

Operational Analytics

Abstract

Performance is of the essence in the operational environment. In order to enhance
performance, data are denormalized. However, when data are denormalized, data
become disintegrated. In order to achieve integration, data are integrated as they enter
the data warehouse. Data in the warehouse are at a granular. Because data in the data
warehouse are granular, the data can be shaped and reshaped into many different forms,
serving the needs of many different communities. Supplementing the data warehouse are
data marts. Data marts primarily support KPIs.

Keywords

Denormalization; Integration; ETL; Data warehouse; Granularity; Data marts; KPIs;
Historical data

The operational environment is one where the day-to-day activities of the corporation
take place. Sales are made. Bank deposits are made. Insurance policies are sold. Grocery
shelves are stocked.

In short, the world operates in a modern efficient manner when the operational world
runs properly.

The data that are generated by operational processing are of enormous value to the
world.

Fig. 12.1.1 depicts the operational environment.

Chapter 12.1: Operational Analytics