Month 6: Understanding ETL Processes
Week 1: Basics of ETL
- Day 1: Introduction to ETL
- Day 2: Importance of ETL in Data Warehousing
- Day 3: The ETL Process
- Day 4: ETL Tools
- Day 5: ETL vs ELT
Week 2: Extracting Data
- Day 1: Data Extraction Techniques
- Day 2: Data Profiling
- Day 3: Data Cleansing
- Day 4: Data Validation
- Day 5: Automating Data Extraction
Week 3: Transforming Data
- Day 1: Data Transformation Techniques
- Day 2: Data Enrichment
- Day 3: Data Aggregation
- Day 4: Data Formatting
- Day 5: Data Standardization
Week 4: Loading Data
- Day 1: Data Loading Techniques
- Day 2: Full Loads vs Incremental Loads
- Day 3: Error Handling During Data Loading
- Day 4: Data Auditing
- Day 5: Automating Data Loading
dowhatkennydoes.com 