School Performance Analytics

Analyze student and teacher performance for a school district

[SCHOOL_DB] · modules 7-9 · 13 steps

progress: 0/14 steps0%

# scenario

Greenfield School District hired you to work on their analytics. The superintendent wants reports on student achievement, teacher effectiveness, and course outcomes. Using window functions, CTEs, and advanced joins, you'll build the queries that run their reporting dashboard.

# build

An analytics suite showing student performance trends, teacher metrics, course statistics, and academic rankings.

# steps

step 01
Student GPA with Class Average
step 02[locked]
Student GPA Rankings
step 03[locked]
Course Enrollment Rankings
step 04[locked]
Top Students Per Grade Level
# from window-functions/partition-by
step 05[locked]
GPA Gap Analysis
step 06[locked]
Student Performance Summary
step 07[locked]
Course Search Optimization
# from database-objects/indexes
step 08[locked]
Data Integrity Audit
step 09[locked]
Department Statistics Snapshot
step 10[locked]
Teacher Workload Analysis
step 11[locked]
Grade Distribution Report
step 12[locked]
Enrollment Audit Trail Prep
step 13[locked]
Complete Analytics: Performance Dashboard
step 13[locked]
Student Privacy Report