Master Data Warehouse Concepts - Step by Step from Scratch (Part 1)

Inf Sid, ETL/Data Architect

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
39 Lessons (2h 45m)
    • 1. 01 - Is Data Warehouse still relevant in the age of Big Data

      4:25
    • 2. 02 - Why Data Warehouse is Implemented?

      4:51
    • 3. 03 - What is a Data Warehouse?

      5:48
    • 4. 04 - Chareterstics of a Data Warehouse

      5:43
    • 5. 05 - What is Business Intelligence?

      5:37
    • 6. 06 - What is Business Intelligence Part 2 Project Specific Set Up

      3:34
    • 7. 07 - Mutiple Uses of BI

      8:02
    • 8. 08 - Different Tools used in BI

      6:24
    • 9. 09 - Centrelized Data Warehouse Architectures

      4:46
    • 10. 10 - Federated Data Warehouse Architectures

      3:05
    • 11. 11 - Muitli Tired Data Warehouse Architectures

      3:13
    • 12. 12 - Components of Data Warehouse Architectures

      3:57
    • 13. 13 - Importance of Staging in Data Warehosue - Part 1

      4:43
    • 14. 14 - Importance of Staging in Data Warehouse Part 2

      3:35
    • 15. 15 - Advantages of Data Warehouse

      9:28
    • 16. 16 - Disadvantages of a Traditional Data Warehouse

      6:01
    • 17. 17 - ODS - Operational Data Store

      2:20
    • 18. 19 - Features and Benefits of ODS

      2:18
    • 19. 18 - Define ODS

      8:41
    • 20. 20 - Differences Between OLTP, ODS and DWH

      4:01
    • 21. 21 - OLAP

      5:54
    • 22. 22 - OLAP Vs OLTP Part 1

      4:33
    • 23. 23 - OLAP Vs OLTP Part 2

      6:01
    • 24. 24 - MOLAP

      6:36
    • 25. 25 - ROLAP

      3:40
    • 26. 26 - HOLAP

      2:28
    • 27. 27 - DOLAP

      1:28
    • 28. 28 - DataMart

      1:47
    • 29. 28 - Fundamental Difference between DWH and DM

      0:36
    • 30. 29 - Advantages of a Data Mart

      2:40
    • 31. 30 - Charecteristics of a Data Mart

      4:00
    • 32. 31 - Disdvantages of a Data Mart

      3:13
    • 33. 32 - Mistakes and MisConceptions of a Data Mart

      2:15
    • 34. 33 - Metadata

      1:57
    • 35. 34 - Benefits of Metadata

      1:46
    • 36. 35 - Types of Metadata

      5:32
    • 37. 36 - Metadata Project Setup

      5:34
    • 38. 37 - Best Practices for Metadata Setup

      1:30
    • 39. 38 - Metadata Summary

      3:16
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

4 of 4 students recommend this class
Overall, Its a good course on data warehouse. I understand data ware house after watching the course. It's bit hard to understand at first with the accent, but I got use to it after a few lessons. Good Job Suggestions: add captions The video 15 Advantages of a traditional warehouse and some content about the disadvantage which was repeat in the next video 16 Disadvantages of a traditional warehouse.