Interactive Course Mind Map
A visual, hierarchical architecture of the entire 9-module curriculum. Trace how core cell mechanics connect with formulas, tables, pivot tables, data cleaning, Power Query ETL, and DAX dimensional modeling.
🗺️ The 3-Tier Curriculum Architecture
Data Capture, Hygiene & UI
Modules 1, 2 & 7: Grid coordinates, primitive data types, custom number formatting, list validation, deduplication, and the DAMA 6 Dimensions of Data Quality. Ensures data is structured before analysis begins.
Analytical Computation & Summaries
Modules 3, 4, 5 & 6: Relative vs Absolute references, dynamic array calculations, XLOOKUP, Excel Tables (ListObject), multi-dimensional PivotTables, and executive KPI dashboard visualization.
Automated ETL & Scaled Modeling
Modules 8, 9 & Capstone: Power Query M pipelines, column unpivoting, fuzzy merging, Star Schema relationship modeling, CALCULATE context transitions, and executive portfolio presentation.