Project 2

✩

Project 2 ✩

SY22 STUDENT PROGRAMS

Overview:

In preparation for the SY23 school year, I led a district-wide analysis of Chicago Public Schools’ after-school programming participation to identify opportunities for improving enrollment strategies and resource allocation.


The initiative focused on answering:

  • Which grade levels demonstrate the highest engagement?

  • What months see enrollment spikes or drop-offs?

  • Which program categories sustain the strongest participation rates?

Actions to create this report

    • Met with district leadership, program coordinators, and community partners to define success metrics and confirm priority questions.

    • Established KPIs such as participation rate per grade level, monthly enrollment growth rate, and category-level retention.

    • Authored a complex SQL query to pull after-school participation data from the data warehouse.

    • Applied business rules to remove duplicate enrollments, correct incomplete grade-level mappings, and anonymize sensitive student records.

    • Standardized grade level values for clean aggregation.

    • Built calculated measures for attendance rates, participation percentages, and month-over-month enrollment changes.

    • Used DAX to dynamically segment data by grade, category, and enrollment period for flexible stakeholder filtering.

    • Designed an interactive Power BI dashboard with drill-through capabilities for school-specific views.

    • Created visuals that highlighted enrollment peaks, participation breakdowns, and category performance over time.

    • Delivered a final presentation to district leadership with recommendations prioritized by expected impact vs. required effort.

DAX MEASURES

Using to DAX to create new tables and measures. Here are a few below:

Grade Level Label

School Program Attendance Rate

Participation % By Race/Ethnicity

Key Insights

    • Targeted Outreach: Identified 1st and 2nd graders as consistently highest-participating cohorts, leading to a 15% increase in targeted communications to early elementary families.

    • Program Category Optimization: Revealed that Enrichment programs (tutoring, arts, jewelry making) outperformed all other categories, resulting in a 10% budget reallocation toward these activities.

    • Seasonal Enrollment Strategy: Discovered that enrollment peaked in February due to the conclusion of sports seasons. Adjusted program scheduling to launch new offerings during this window, increasing mid-year participation by 12% year-over-year.

    • Stakeholder Adoption: The dashboard became a core reporting tool for 100+ school and community leaders, reducing manual data requests by over 60%.