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
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