EaseWithData — Data Warehouse Series
1 min readJan 18
--
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:
- Introduction to Data Warehouse
- Data Lake vs DW and OLTP Systems
- OLAP Systems
- ETL vs ELT and Data Loading Strategies
- Measures\Facts & Attribute Part I
- Measures\Facts & Attribute Part II
- Designing First Data Warehousing Model
- Dimension — Conformed
- Dimension — Junk, Degenerated, Role Playing and SCD
- Dimension — Slowly Changing Type 1 (SCD 1)
- Dimension — Slowly Changing Type 2 (SCD 2)
- Dimension — Slowly Changing Type 3
- Transactional Fact Table and Periodic Snapshot Fact Table
- Accumulating Snapshot Fact Table & Factless Fact Table
- DW Model — Star Schema and Snowflake Schema
- 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
