Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Become a Data Warehouse Consultant
Download Important Support files for Learning Enterprise Data Warehouse
Download Important Support files for Learning Enterprise Data Warehouse
Understanding Enterprise Data Warehouse & Its Relevance
0101 Is Data Warehouse still relevant in the age of Big Data (3:25)
0102 Why do we need Data Warehouse (3:10)
0103 What is Data Warehouse (3:41)
0104 Characteristics of a Data Warehouse (4:58)
Understanding Business Intelligence
0201 What is Business Intelligence (2:03)
0202 Uses of Business Intelligence (3:41)
0203 Tools used for (in) Business Intelligence (3:08)
Understanding Data Warehouse with Advantages and Limitations
0301 Components of a Data Warehouse (3:39)
0302 Advantages of a Traditional Warehouse (2:58)
0303 Limitations of Traditional Data Warehouses (5:21)
Understanding Data Mart in Enterprise Data Warehouse
0401 What is a Data Mart (2:15)
0402 Fundamental Difference between DWH and DM (2:41)
0403 Advantages of a Data Mart (1:52)
0404 Charecteristics of a Data Mart (2:04)
0405 Disdvantages of a Data Mart (2:05)
0406 Mistakes and MisConceptions of a Data Mart (2:04)
Understanding Dimension Model in Enterprise Data Warehouse
0501 What is Dimension Modelling (3:16)
0502 Benefits of Dimensional Modelling (1:49)
0503 What is a Dimension (4:51)
0504 What is a Fact (3:09)
0505 Additive Facts (2:19)
0506 semi addative facts (2:39)
0507 Non additive facts (3:02)
0508 FactLess Facts (2:50)
0509 What is a Surrogate key (3:44)
0510 Star Schema (3:40)
0511 SnowFlake Schema (2:41)
0512 Galaxy Schema or Fact Constellation Schema (1:52)
0513 Differences between Star Schema and SnowFlake Schema (4:12)
0514 Conformed Dimension (3:07)
0515 Junk Dimension (1:55)
0516 Degenerate Dimension (2:39)
0517 Slowly Changing Dimensions - Intro and Example Creation (3:42)
0518 Slowly Changing Dimensions - Type 1, 2 and 3 (6:07)
0519 Slowly Changing Dimensions - Summary (3:41)
0520 Project Set up the Dimensional Model using a Financial Services Case Study (14:20)
Become a Data Warehouse Consultant Feedback
0101 Is Data Warehouse still relevant in the age of Big Data
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login