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.
Data Warehouse Architecture
Unit 1 – Create a Data Mart for Weekly Sales
Unit 2 – Staging – Create Staging Schema
Unit 2 – Staging – Load Master Data
Unit 2 – Staging – Load Transaction Data
Unit 3 – ODS – Create the DataStore Schema
Unit 3 – ODS – Load Master Data
Unit 3 – ODS – Load Transactional Data (Full data load)
Unit 3 – ODS – Load Transactional Data (Incremental data load)
Unit 4 – DataMart – Load Master Data
Unit 4 – DataMart – Load Transactional Data
Unit 5 – Create a final Package
Unit 3 – ODS – Create the DataStore Schema (FastTrack)