From Spreadsheets to Dashboards: The 6 Numbers Every School Leader Should Watch

Most schools are sitting on rich data — in the SIS, the finance system, the helpdesk — but leadership still meets around a stale spreadsheet. A good dashboard isn't about pretty charts; it's about deciding faster on numbers you trust. Start with these six.

1. Enrollment and pipeline

Applications, accepted, enrolled, and withdrawn — by campus and grade, trending against last year. This is the number that drives every other one.

2. Attendance, live

Daily attendance by grade and campus, with early-warning flags for at-risk students. Waiting for a monthly report means intervening a month too late.

3. Revenue and collections

Fees billed vs. collected, outstanding balances, and aging. Cash-flow surprises are almost always avoidable with a live view.

4. Cost per student

Operating cost per student, per campus. It turns abstract budget debates into a concrete, comparable figure leadership can act on.

5. IT and facilities tickets

Open tickets, resolution time, and recurring issues. A rising trend here is an early signal of operational strain before it reaches parents.

6. Staffing ratios

Student-to-teacher and student-to-staff ratios by campus, against your targets. Quietly one of the biggest levers on both quality and cost.

The goal isn't more reports. It's one screen the leadership team trusts enough to decide from.

You don't need to build all six at once. Pick the one decision that hurts most today, model the data behind it, and ship a single reliable view. Momentum follows. If you want help shaping that first dashboard, let's talk.