Data Warehouse Architecture

Course Overview

In this course, we create a data warehouse from scratch. We will access the extraction layer of an ERP system, upload the data into a Staging Area. From the Staging Area, the data will be integrated into the Operational Data Store (ODS). The Operational Data Store contains all the data records. We will discuss time dependencies, which are known als Slowly Changing Dimension. Then, we will create a Data Mart, which is based on a Star Schema. Later, we will create a data cube on top of a data mart.

About the Author

Prof. Dr Peter Lehmann teaches Business Information Systems and Business Intelligence at the Stuttgart Media University.

Description

Lessons

Data Warehouse Architecture

DWA 01 – Create a Data Mart for Weekly Sales

DWA 02 – Create the Staging Area

DWA 03 – Load Staging Area (Master Data)

DWA 04 – Load Staging Area (Transaction Data Full)

DWA 05 – Create the DataStore

DWA 06 – Load Data Store (Master Data)

DWA 07 – Load Data Store (Transactional Data)

DWA 08 – Load Data Mart (Master Data)

DWA 09 – Load Data Mart (Transational Data)

DWA 11 – Load Transactional Data (Incremental data load)

DWA 12 – Create a final ETL Package

DWA FastTrack: Create the Data Mart with Weekly Sales / 200

DWA FastTrack: Create the Staging Area / 210

DWA FastTrack: Create the DataStore Schema / 220

DWA FastTrack: Load the DataStore Schema / 230

Take the course to view this content