⚡ Intermediate Learning Path
Data Validation & Transformations
Level up to production data engineering: master data cleansing, quality assertions, window analytical functions, relational integrity, and multi-metric aggregation pipelines.
20
Problems10 XP
Each Challenge200 XP
Total PointsIntermediate
Difficulty
Data Cleansing & Standardization
Normalize raw dirty strings using trim(), upper(), lower(), initcap(), and regex standardization.
4 Challenges40 XP
▶
PY-051:Standardize Department Casing and Trim Whitespace•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-052:Title-Case Employee Names and Clean Whitespace•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-053:Multi-Branch Categorization: Derive Salary Tiers•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-054:Schema Standardization for Gold Layer Lakehouse•Intermediate•⭐ 10 XP
Start Challenge →
Data Quality Assertions & Null Handling
Isolate corrupt records, apply boundary threshold assertions, domain validation, and multi-field imputation.
4 Challenges40 XP
▶
PY-055:Isolate Corrupted Records with Missing Critical Data•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-056:Flag Out-of-Bounds Salary Anomalies•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-057:Compound Domain Validation Rule•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-058:Multi-Column Default Imputation with Dictionary fillna•Intermediate•⭐ 10 XP
Start Challenge →
Advanced Analytical Window Functions
Execute dense ranking, partition top-earner filtering, and inter-row lag/lead lookback operations.
4 Challenges40 XP
▶
PY-059:Analytical Window: Dense Rank Salaries by Department•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-060:Analytical Window: Top-Earner Partition Filtering•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-061:Analytical Window: Prior Salary Lookback with lag()•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-062:Analytical Window: Upward Salary Lookahead with lead()•Intermediate•⭐ 10 XP
Start Challenge →
Relational Integrity & Complex Joins
Detect foreign key violations via left anti joins, perform broadcast lookups with null fallback, and resolve duplicates.
4 Challenges40 XP
▶
PY-063:Relational Integrity: Left Anti Join for Missing Foreign Keys•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-064:Broadcast Lookup Join with Null Coalesce•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-065:Deduplication with Window Tie-Breaking on Latest Joining Date•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-066:Relational Enrichment with Department Metadata Join•Intermediate•⭐ 10 XP
Start Challenge →
Temporal Analytics & Pipeline Integration
Compute tenure with datediff, extract cohorts with year(), build multi-metric aggregations, and orchestrate end-to-end pipelines.
4 Challenges40 XP
▶
PY-067:Tenure in Days Calculation with datediff()•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-068:Cohort Hire Year Extraction and Sorting•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-069:Department Multi-Metric Summary Aggregation•Intermediate•⭐ 10 XP
Start Challenge →
▶
PY-070:End-to-End Cleanse, Validate, and Aggregate Pipeline•Intermediate•⭐ 10 XP
Start Challenge →