Top tier: front-end tools

Query / Report

Analysis

Data mining

Middle tier: OLAP server

OLAP server

OLAP server

Bottom tier: Data warehouse server

Monitoring

Administration

Metadata repository

Data warehouse

Data marts

Extract

Clean

Transform

Load

Refresh

Data

Operational databases

External sources