🎯 Resource to Skill Map

This matrix provides a direct, practical lookup answering: "Where can I learn, reference, practice, and apply this specific skill in a portfolio project?"

Core Skill	Primary Course Lesson	Supplementary Gemini Resource	Practice Drill	Project Implementation
Interface Navigation & Ergonomics	01 Excel Interface and GUI	Excel Interface Blueprint	Ex01 Data Management and Formatting	Workbook Setup & View Hygiene
Data Quality & Hygiene Audit	01 Data Quality Dimensions and Audit	Six Dimensions of Data Quality	Ex05 Data Cleaning and Transformation	Call Center Data Quality Assessment
Structured Tables & References	01 Excel Tables Architecture	Excel Tables	Ex03 Excel Tables and Structured References	Dynamic Source Table Setup
Modern Exact & 2-Way Lookups	04 Lookup and Reference Functions	XLOOKUP and Modern Lookups	Ex02 Formulas and Lookup Logic	Customer & Agent Attribute Enrichment
Dynamic Array Filtering & Spilling	07 Dynamic Arrays and Modern Formulas	Dynamic Arrays and Modern Calculation	Ex07 Supplementary Dynamic Lookups and KPIs	Exception Handling & Dropdown Vector Feeds
Multi-Condition Aggregations	02 Statistical and Aggregation Functions	SUMIFS, COUNTIFS	Ex02 Formulas and Lookup Logic	Baseline Volume Metrics
Automated ETL & Unpivoting	01 Power Query Fundamentals and ETL	Power Query ETL Transformations	Ex06 Power Query ETL	Call Log Ingestion Pipeline
Multidimensional Pivot Summaries	01 Pivot Table Foundations	Pivot Tables	Ex04 Pivot Table Summaries	Topic vs Department Analysis
Interactive Dashboard & Slicer Design	01 Visual Analytics and Chart Selection	Executive Dashboard Design Principles	Hotel Challenge	Call Center Performance Report
Relational Star Schema Modeling	01 Dimensional Modeling Principles	DAX Measures and Data Modeling	Ex07 Supplementary Dynamic Lookups and KPIs	`FactCalls` to `DimAgent` & `DimDate` Models
Explicit DAX Measure Engineering	03 DAX Fundamentals Calculated Columns vs Measures	Data Analysis Expressions (DAX)	Ex07 Supplementary Dynamic Lookups and KPIs	Call Center KPIs
Operational KPI Architecture	06 Projects/Call Center Performance Analysis/Business Problem	Call Center KPI Analytics	Ex07 Supplementary Dynamic Lookups and KPIs	First Contact Resolution & SLA Compliance
Executive Storytelling & Case Study	06 Projects/Call Center Performance Analysis/Recommendations	Analytics Pipeline Comparison	PwC Challenge	Portfolio Case Study
Database Discovery & Schema Profiling	01 Data Quality Dimensions and Audit	SQL Server Architecture	Lab 01 Database Discovery, Lab 04 Data Profiling	Northwind Sales Analysis
Relational SQL JOINs & Ingestion	01 Power Query Fundamentals and ETL	SQL Joins, SQL to Excel Architecture	Lab 05 SQL Querying, Lab 07 SQL to Excel Ingestion	Northwind Project
Many-to-Many Bridge Resolution	01 Dimensional Modeling Principles	Many-to-Many Relationships	Lab 03 Relationship Analysis, Lab 06 Analytical SQL	pubs Publishing Intelligence
Enterprise 3NF OLTP Extraction	01 Dimensional Modeling Principles	OLTP vs OLAP, SQL Views	Lab 05 SQL Querying, Lab 06 Analytical SQL	AdventureWorks Sales Analytics
Kimball Star Schema in Power Pivot	01 Dimensional Modeling Principles	Query Folding, SQL vs Power Query	Lab 07 SQL to Excel Ingestion, Lab 08 Model Validation	AdventureWorksDW Project
Production SQL Pipeline & VBA Automation	01 Power Query Fundamentals and ETL	Production Analytics Pipeline	Lab 07 SQL to Excel Ingestion, Lab 08 Model Validation	Production Pipeline Project

How to Use This Matrix

Targeting a Weak Point: If an interview or assessment tests DAX Measures, jump directly to DAX Measures and Data Modeling, solve the tasks in Ex07 Supplementary Dynamic Lookups and KPIs, and review the production measures in 06 Projects/Call Center Performance Analysis/KPIs.
End-to-End Execution: Follow the horizontal row from Lesson → Resource → Practice → Project to achieve mastery in any analytical domain.