Education · United Kingdom

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.

65%
Faster data prep
90%
Data consistency
70%
Self-serve adoption
Company size
Medium
Company industry
Education
About the company

A 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.

The challenge

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.

The solution

One automated data layer connecting all systems — 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
The outcome

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.

Management Team
ILG — Inspired Learning Group
The transformation · From disconnected school systems to one unified network view
BEFORE 23 schools · 5 systems · no unified view S01 S02 S03 S04 S05 S06 S07 S08 S09 S10 S11 S12 S13 S14 S15 S16 S17 S18 S19 S20 S21 S22 S23 NETSUITE PSP IRIS SIMS CSV No shared view · manual exports · IT bottleneck AFTER One unified view · every school · no IT S01–S06 Finance view S07–S12 Academic view S13–S18 Ops view S19–S23 Admissions view Network Dashboard · Power BI · Auto-update NETWORK ENROLMENT 2,800+ ▲ pupils · all schools DATA PREP TIME 65% ▼ faster DATA CONSISTENCY · BY SOURCE Netsuite 90% SIMS 95% IRIS 85% 70% self-serve Zero IT 23 schools

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.

Automation

Manual data exports across 5 systems replaced by automated pipelines. Data prep time dropped 65% — freeing staff for higher-value work across the network.

Consistency

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.

Self-serve

70% of staff now access insights independently — no IT ticket, no waiting. School leaders create custom views specific to their school without technical help.