Project 2

✩

Project 2 ✩

SY22 STUDENT PROGRAMS

Overview:

The data presented in this dashboard has been modified to protect the confidentiality of student programming data at Chicago Public Schools. Due to the sensitivity of the original dataset, the corresponding SQL scripts used for data extraction cannot be shared.

Developed a SQL script and Power BI report to create an end-of-year overview for school-based coordinators and community partners.

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

- School A had a program attendance rate of 86% for SY22.
- The majority of programs fall under the enrichment category, making up 48% of the total. This suggests a strong focus on providing students with opportunities beyond core academics, such as arts or STEM.
- Student enrollment in programming peaked in February 2022. According to program coordinators, this increase was due to the conclusion of sports seasons, which allowed more students to participate and led to an expansion in program offerings during that period.