BI Data Warehouse Architecture / Diagram

Data Warehouse Architecture

Data Warehouse Architecture can be design in different way. Its depend on the specific business requirement that means it’s vary depending upon the specifics of an organization's need.

Below is standard Data Warehouse Architecture:

Data Warehouse Architecture / Diagram

Most Data Warehouse Architecture contains the below components or Layers as mentioned below:

1. Metadata Layer
2. Data Sources
1. Production Data
2. Internal Data
3. Archived Data
4. External Data
3. Data Staging Area
1. Data Extraction
2. Data Transformation
3. Data Loading
4. ETL Layer
5. Data Mart - Target
1. Data Mart 1
2. Data Mart 2
3. Data Mart n…
6. ODS - Operational Data Store
7. Data Storage Layer
8. Data Logic Layer
9. System Operations Layer
10. Multiple Data Marts
11. Data Information / Presentation Area
12. Management and Control Component 

The most common Data Warehouse Architectures are as follow:

1. DWH Architecture – Basic
2. DWH Architecture – with Data Staging Layer
3. DWH Architecture – with Data Staging and Data Mart Layers

+Vivek Kumar