URLit.me Blogs

EaseWithData — Data Warehouse Series

If you are new to data warehousing or preparing for an Interview, then this Series is for you.

This Series follow YouTube videos explaining the Basics of Data Warehouse in simple terms. Make sure to Like and Subscribe to our channel.

Click on the links below to follow:

1. Introduction to Data Warehouse
2. Data Lake vs DW and OLTP Systems
3. OLAP Systems
4. ETL vs ELT and Data Loading Strategies
5. Measures\Facts & Attribute Part I
6. Measures\Facts & Attribute Part II
7. Designing First Data Warehousing Model
8. Dimension — Conformed
9. Dimension — Junk, Degenerated, Role Playing and SCD
10. Dimension — Slowly Changing Type 1 (SCD 1)
11. Dimension — Slowly Changing Type 2 (SCD 2)
12. Dimension — Slowly Changing Type 3
13. Transactional Fact Table and Periodic Snapshot Fact Table
14. Accumulating Snapshot Fact Table & Factless Fact Table
15. DW Model — Star Schema and Snowflake Schema
16. Early Arriving Facts or Late Arriving Dimensions

Checkout the whole playlist on YouTube — https://youtube.com/playlist?list=PL2IsFZBGM_IE-EvpN9gaZZukj-ysFudag

Subscribe to out YouTube Channel — https://www.youtube.com/@easewithdata

Checkout my Personal Blog — https://urlit.me/blog