Skip to main content
Education
Role: Senior BI Analyst

School Excellence & Network KPI Dashboard

Client: New Horizon Academy
4 weeks
5 Technologies

Key Measurable Results

8 KPIs

Unified across Occupancy, Retention, CRM, Labor, CTO & Surveys

3-Tier

Automated School vs. District vs. Company benchmarking

Automated

Weekly & monthly executive scorecard across all campuses

1The Problem

Leadership across the multi-location school network had no unified view of campus performance. District managers couldn't compare weekly occupancy, student retention, family survey recommendations, labor ratios, CRM inquiry-to-enrollment conversion, or contribution to overhead (CTO) side-by-side against district and company goals.

2What We Built

Built an automated School Excellence Report dashboard comparing every campus against District and Company averages across 8 core KPIs—Weekly Occupancy, 12-Month Retention, Family Survey Recommendation, Top Workplace Engagement, Monthly Labor %, CRM Inquiry-to-Enrolled Conversion, Monthly CTO, and Weekly Enrollment—with weighted composite scoring.

The Tools & How We Used Them

Power BI / Tableau

Designed the 8-panel School Excellence Report with synchronized trend lines, target badges, and 3-tier benchmark bars

SQL & Data Modeling

Aggregated weekly occupancy, rolling 12-month retention, monthly labor/CTO financials, and bi-annual survey datasets

CRM Analytics

Tracked monthly inquiry-to-enrolled conversion rates and enrollment count variances against campus goals

Automated Scoring Engine

Calculated composite campus, district, and company scores across weighted operational and financial KPIs

How It Works — Step by Step

1

Implemented a weighted Excellence Score rubric (Occupancy = 2 pts, CRM Conversion = 2 pts, CTO = 3 pts, Retention/Surveys/Labor = 1 pt each) benchmarking each school against District and Company averages

2

Built side-by-side multi-year trend lines and current-period comparison bars for Weekly Occupancy, 12-Month Retention, and Weekly Enrollment

3

Integrated CRM Inquiry-to-Enrolled conversion tracking with dual percentage and enrollment-count goal thresholds

4

Added financial and operational health cards tracking Monthly Labor % against target thresholds and Contribution to Overhead (CTO) across positive, average, and goal benchmarks

✓The Result

8 KPIs

Unified across Occupancy, Retention, CRM, Labor, CTO & Surveys

3-Tier

Automated School vs. District vs. Company benchmarking

Automated

Weekly & monthly executive scorecard across all campuses

Skills & Deliverables

Power BISQLCRM AnalyticsEducation BIMulti-Location Benchmarking

Project Details

Our Role

Senior BI Analyst

Client

New Horizon Academy

Industry

Education

Delivery Timeline

4 weeks

Need a similar system built for your team?

Book a free discovery call and we'll map out how to build this for your exact data sources and tools.

School Excellence & Network KPI Dashboard