Week 4 Overview
Master advanced techniques including recursive queries, data modeling, and professional dashboard creation.
Key Focus Areas: CTEs, Power Pivot with DAX, CASE statements, PIVOT/UNPIVOT, advanced charts
This Week's Learning Path
Click any day below to view detailed lessons, practice exercises, and assignments:
📚 Day 16: SQL - CTEs & Recursive Queries
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 17: Excel - Power Pivot & Data Modeling (DAX basics)
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 18: SQL - CASE Statements & PIVOT/UNPIVOT
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 19: Excel - Advanced Charts & Dashboards
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments
📚 Day 20: SQL - Views, Stored Procedures, Optimization + WEEK 4 TEST
Comprehensive 4-hour lesson with tutorials, practice exercises, and assignments