Education

School Network Performance Dashboard

N
New Horizon Academy
4 weeks
4 Technologies

Key Results

70

Company Goal score now tracked across all schools

68.6%

Pulse Survey visibility for employee satisfaction

$2.70

Rate of Pay tracking for talent competitiveness

1The Challenge

The school network had no unified view of key performance metrics across locations. District managers couldn't compare school performance, identify underperforming locations, or track the metrics that contribute to overall company goals.

2Our Solution

Created a multi-level analytics dashboard that tracks Key Measures (Family Survey, Retention, Occupancy), Customer Service & Marketing metrics, and Talent Management KPIs across all school locations with drill-down capability.

Our Approach

1

Mapped company goals to measurable KPIs for each school location

2

Built Key Measures section: Family Survey Recommendation, Retention, Occupancy rates

3

Added Customer Service metrics: Google Reviews, Registration numbers, Weekly Enrollment

4

Created Talent Management view: Staff Retention, Workplace Survey, Glassdoor scores

5

Implemented filters for School Name, District Manager, and Company-wide comparison

School Network Performance Dashboard — data analytics case study by Alfa Analytics

The Impact

70

Company Goal score now tracked across all schools

68.6%

Pulse Survey visibility for employee satisfaction

$2.70

Rate of Pay tracking for talent competitiveness

Technology Stack

Power BISQLExcelEducation Analytics

Project Details

Client

New Horizon Academy

Industry

Education

Duration

4 weeks

Want to achieve similar results for your education organization?