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
0517 Slowly Changing Dimensions - Intro and Example Creation
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock