Student Attendance Dashboard

Presented here is a dashboard showcasing student attendance throughout the academic year, featuring informative donut charts that capture the comprehensive view of overall attendance and tardiness rates. The attendance breakdown categorizes absences into excused and unexcused, empowering stakeholders to gain valuable insights into students' attendance patterns and their time spent away from school. Moreover, the attendance profile chart enables the swift identification of notable trends or extended periods of absence within a student's attendance record.

To create these impactful dashboards, data was extracted from the school's database using SQL. As the existing database system lacked the capability to generate concise summary statistics and visually appealing visualizations for student data, a pragmatic solution was devised. By transferring the data to a spreadsheet, the foundation was set for crafting these informative dashboards. The subsequent sharing of this spreadsheet through the school's Google Workspace seamlessly enabled teachers to access and review comprehensive attendance details for individual students, fostering a data-driven approach to optimize student engagement and success.

Click the image to view the dashboard in Google Sheets.

Student data has been replaced with fabricated data for privacy reasons.