Learning Plan Structure

Data Warehousing

Important Topics

• OLTP vs OLAP

• Data Design and Preparation

• Dimensional Designs

• Warehouse Architectures

• Fact Tables

• Data Integration Design and Analysis

• Extract, Transform and Load (ETL) systems

• Extraction of Meta Data

Books

• Data Warehousing Fundamentals for IT Professionals
• Kimball's Data Warehouse Toolkit Classics: 3 Volume Set
• Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
• Star Schema The Complete Reference
• Dimensional Modeling: In a Business Intelligence Environment
• The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence
• DW 2.0: The Architecture for the Next Generation of Data Warehousing

 

Courses

• Udemy - Data Warehouse Concepts: Basic to Advanced concepts
• Coursera - Data Warehouse Concepts, Design, and Data Integration