Skip to content
Try free
Inspired Learning Group logoEducation

A monthly KPI view across 23 schools, where there had been none

Running 23 schools meant maintaining finance, occupancy, payroll and staff-management systems separately, with no consolidated view across them. The first attempt at one was built by an intern, needed manual intervention every month, and stopped working when they left.

23
schools on one standard
900+
staff, 2,800+ pupils covered
Monthly
KPI pack, generated rather than assembled

The workflow

What replaced the manual work

  • Finance, occupancy, payroll and staff systems
  • 23 schools, files to a common folder
One pipeline
  • Connect
  • Clean
  • Automate
  • Share

Recorded once, re-run on a schedule.

  • One standardised data layer
  • Monthly KPI pack in Power BI

Outcomes

What changed

  • One consolidated monthly KPI view across all 23 schools, where none existed before
  • Business and school heads working from accurate KPIs for the first time
  • Data standardised across schools that name and record things differently
  • Business logic maintained by the operations team, with no technical dependency
  • A foundation the group can extend as it adds schools

What they used

The parts of Mammoth involved

  • Data Engine
  • Scheduled refresh
  • Free viewers
  • Custom roles

More case studies

Starbucks · 20 days → hours20 days of report assembly, down to hours — across 17 countriesRethinkFirst · 10x50+ hours a month saved, and new analysts productive in under two weeksMUFG · 19KYC standardised across 19 countries, and a week of Excel became 20 minutes

Start with one source and one question.

That's how this deployment began too. Twenty minutes on the free plan is a fair test.

Try freeBook a demo
  • 21-day Pro trial
  • No credit card
  • Viewers always free