10 Sep Enterprise Intelligence and Decision Support Systems

Enterprise Intelligence and Decision Support Systems

 

The Components of BI Architecture

 

The Components of BI Architecture

 

2

 

Ease of use, minimal training, uses Standard Reinsurance business terms

 

Fast performance

 

For those metrics which cover Operations detail, Ad-hoc reports can be easily created

 

Executive Ad-hoc reports can be easily created

 

Scaleable and insulated from data sources

 

Data Sources

 

Extract,

 

Transform

 

& Load

 

(ETL)

 

Data from

 

source

 

systems

 

Evolve

 

First Data

 

Mart:

 

Create

 

specialized,

 

web-

 

enabled

 

interfaces

 

Aggregate

 

at group &

 

business

 

unit

 

levels

 

Distribute

 

to business

 

units and

 

Group

 

Source 3

 

Source 4

 

Source 2

 

Source 1

 

Etc.

 

External

 

Market

 

Data

 

User Benefits:

 

Standard operational reports not covered in warehouse because of lower “grain” or different refresh schedule.

 

Near “real time” access

 

Transaction Systems

 

Start with

 

One Key

 

Performance

 

Indicator

 

(KPI)

 

Create a

 

single data

 

mart for all

 

audiences

 

Data Warehouse

 

Transaction System Reporting

 

Either provided with the applications or enhanced with direct connect to transaction systems

 

User Benefits:

 

Future State:

 

A Data Warehouse With Comprehensive Business Intelligence:

 

User Benefits:

 

Extend data marts, create new data marts for additional KPI’s

 

Add data marts specialized for “problem” transactional reporting

 

Extend intranet-based viewing to include web-based querying

 

Provide seamless drill-down from high-level summary to transaction detail

 

Integrate information from multiple sources

 

Extends benefits from the first data mart

 

A Sample Comprehensive BI Architecture

 

3

 

3

 

OLTP = Online Transaction Processing