Production Capstone: Engineer an end-to-end automated ETL pipeline ingesting 12 multi-store retail files with custom M-transformations and zero manual touch.
“Capstone 1: 12-Store CSV Consolidation with Full Power Query Pipeline” is part of Level 3: Advanced Excel — Dynamic Arrays, Power Query, DAX & VBA Automation. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
Module 5: Executive Dashboards & Interactive Visuals
Module 6: VBA & Automation
Module 7: What-If Analysis, Finance & 3 Capstones
