How ILG unified data across 23 schools and cut reporting time by 65%
Replacing manual data exports with auto-updating Power BI dashboards, accessible to every school, without IT.
Photo: UnsplashA network of 23 independent UK schools serving over 2,800 pupils
Inspired Learning Group (ILG) operates 23 independent schools across the United Kingdom, serving over 2,800 pupils. With a commitment to delivering personalised education, ILG depends on timely, reliable data to make decisions that directly affect students, staff, and resources across the network.
For a group this size, data is the connective tissue, linking finance, admissions, academic performance, and operations across every school. When it doesn't flow freely, the whole network slows down.
Disparate systems across 23 schools, with no unified view and no time to build one
ILG's administrative teams worked with data spread across multiple disconnected systems: Netsuite, PSP, IRIS, SIMS, and various CSV files. Each school had its own data, its own format, and its own reporting rhythm. There was no single view of what was happening across the network.
Without a unified data layer, decision-makers had to wait for manually prepared reports that were frequently out of date by the time they arrived. Timely interventions were impossible because the insights came too late, and the IT team was the bottleneck for every change.
One automated data layer connecting all systems, with Power BI dashboards for every school
Mammoth gave ILG the infrastructure to connect all their data sources and deliver insights automatically to every decision-maker across the network:
- Connect Netsuite, PSP, IRIS, SIMS, and CSV files into one unified pipeline
- Implement automated Power BI dashboards accessible to all decision-makers from anywhere
- Enable school-specific data perspectives without any IT intervention
- Foster a data-driven culture across both administrative and academic teams
- Allow staff to create custom views and discover insights independently, no manual work
All 23 schools on centralised dashboards. Decisions made faster. IT out of the loop.
- 65% reduction in data prep time: workflow automation across all departments
- 90% data consistency: standardised formats powering reliable reporting
- 70% self-serve adoption: staff access insights without IT support
- All 23 schools now rely on centralised dashboards for strategic planning
- Early identification of trends enables timely interventions across the network
Mammoth-powered, auto-updating Power BI dashboards allow all decision-makers to access data from anywhere, create custom school-specific views, and discover new insights. All without the help of the IT team. ”
self-serve
IT
view.
The Mammoth advantage
Why Mammoth worked for ILG
Three things made the difference, and they're the same three things every multi-site organisation tells us about.
Manual data exports across 5 systems replaced by automated pipelines. Data prep time dropped 65%, freeing staff for higher-value work across the network.
One standardised data layer across all 23 schools. A 90% improvement in data consistency means every dashboard tells the same reliable story, wherever you open it.
70% of staff now access insights independently. No IT ticket, no waiting. School leaders create custom views specific to their school without technical help.