Enterprise Data Warehousing

Data Vault is in fact at the core of Enterprise Data Warehousing (EDW). But what is EDW? How does it differ from general data warehousing? The fact is that the majority of programs classified as a data warehouse today are actually Operational Data Stores. But what is the difference between an ODS and an EDW? Assuming I have the one, why do I need the other?

This course will cover the fundamentals of data warehousing including purpose, current requirements, the fundamental architecture, logical and information modeling, data integration and ETL, the role of history in the EDW, the meaning of 3NF vs. Data Vault vs. Star Schema, OLAP, adaptability and agility, and the enterprise view and commitment.

After you review the details and terms of this plan, simply click the Buy Now button below to proceed to the Payment Page. Once your payment is processed, you will be activated immediately. You can start learning in minutes!



  • Data Warehousing Today (10min)
  • Enterprise View & Commitment (11min)
  • EDW – Current Requirements (12min)
  • EDW Central Requirements (8min)
  • BI OLAP for EDW (11min)
  • Adaptability & Re-engineering (19min)
  • Agile in the EDW Project (12min)
  • EDW Agility (12min)
  • The Free EDW (6min)
  • Fundamental EDW Architecture, EDW Framework (9min)
  • EDW Architecture (6min)
  • Steps to Modeling the EDW (12min)
  • Dimensionitus (11min)
  • EDW Boil the Ocean (13min)
  • Dimensional EDW – Moving to the DW (6min)
  • What is Data Vault (5min)
  • 3NF, DV, Star Schema (8min)
  • ETL Pipeline (14min)
  • Steps to Logical Data Modeling (22min)
  • Data Vault Overview: Introduction Architecture (6min)
  • Data Vault Overview EDW Challenge (7min)
  • Data Vault Overview Business Rules (4min)
  • Applying Data Modeling approaches to EDW (19min)
  • Business Keys in EDW (8min)
  • Business Key and the Dimensional DW (5min)
  • Business Keys with New Architecture (8min)
  • Focus on Business Key vs Departmental (5min)
  • Architectural Layers Beyond the Names (10min)
  • Architural Layers and Characteristics (8min)
  • Difference between DW and ODS (9min)
  • Industry Reference Models (15min)
  • CDI & MDM Initiatives (18min)
  • Integrating MDM with the Data Vault (7min)
  • Unstructured data in the EDW (11min)
  • Expanded Knowledge Management (11min)

Count: 35 lessons

Time: 5hrs 58min : classroom equivalent over 11hrs 56min

Usage: You can watch any and all of these Lessons for two (2) weeks beginning with the date of purchase.

Cost: $995

Buy Now