Introduction to Data Warehouse


SKU: mpbi-1 Categories: , ,

The course is intended for data professionals, interested in building dimensional data warehouse for both medium and big sized organisations. It starts with basic data loading concepts and progresses to actual implementation of the Data Warehouse build and replications.

Course Content

Gathering requirements

Designing the data bus Matrix

Designing the DW architecture

Designing the Dimension Tables

Designing Fact Tables

Loading the Dimensions Tables using the merge statement

Loading the Fact table using the SSIS and look up

Deploying packages

Interview Questions & Answers

15-30 days on the job checklist


2 Days