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.
Shop
Introduction to Data Warehouse
£500.00
Description
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
Duration
2 Days
