Blog, News and Updates from the Schools & Academies Show

Connected by Design: Building the Foundations for Better Decisions in Trusts

At this year’s Schools and Academies Show, we are sharing the stage to discuss how we can unlock the power of data across trust operations, alongside the Centre for Education Operational Excellence (CEOE). Though we work in different trusts and use different underpinning technologies (United Learning on Microsoft and Lift Schools on Google), we face common challenges and share some principles about how data should support better decisions. Education data is having a moment. The government has announced plans for a data spine and common data standards to improve interoperability and portability. Sector-led initiatives such as Open Education AI, a non-profit developing shared data infrastructure and standards, are also helping schools and trusts bring their data together and use it more effectively.

However, challenges remain. First, data is spread across disparate systems which don’t all yet have the interfaces needed to share data in the way that schools and trusts need. Second, over the past decade or so, there has been a proliferation in ed tech software which means that schools and trusts hold data in different platforms for different purposes. Each does its job, but only holds part of the picture, and the way that data moves in and out of these systems is still highly manual and person dependent.

What this means in practice is that much of the data reporting we do in schools and trusts is backwards looking, describing what has already happened. Here we explore what it would take to move to a system that can anticipate and support leaders in responding to what might happen in future. There are digital tools and technologies that can help us to do this better, but technology alone can’t improve organisational digital and data maturity. We need to invest in broad foundations, from understanding the systems and processes that exist through to what data is contained within them, well before we can decide how technology can support.

Understand your starting point

Start with the decisions you need to improve. Which are slow, difficult or poorly informed, and what would help leaders act with greater confidence? From our experience, trusts then need to build an honest picture of four things:

1.         Systems. What are you using, who owns each one, and where is the source of truth? Many trusts find they hold the same pupil or staff record in several places, each slightly different.

2.         Processes. Data is a by-product of the work that gets done. If admissions, attendance follow-up or recruitment run differently in every school, the data could mean something different too. Agreeing common definitions and simplifying processes helps make information comparable. Be clear where a common process adds value and where local variation is needed.

3.         Data flows. You need to map how data moves: where it is manually entered, how it travels between systems, where it is re-keyed or exported, and who uses it at the end, and for what purpose. Manual hand-offs can create delay, error and dependency on individuals, but automated flows need checks too. Know where the risks sit.

4.         Data quality and ownership. Quality is not just a technical problem; it also comes from organisational habits. Some measures, such as persistent absence, have nationally defined thresholds. Across other areas we don’t always have common definitions. For every important measure, someone should own its definition and the process for checking its quality.

Underpinned by governance

None of this is easy, and we haven’t nailed it across all areas in either of our trusts. We develop our data maturity over time, balancing strategic importance with what is technically and pragmatically possible. Underpinning all of this is governance: clarity about who can access what, on what basis, and who is accountable for acting on the insights. Ethical considerations belong here too, particularly as we consider AI in predicting outcomes. Leaders need to understand how an insight was reached, question potential bias and apply human judgement before acting.

Invest in the time, not just the tools

Some technical challenges take time to solve, but the organisational work can be harder. With operational teams stretched, mapping processes or formalising definitions rarely feels urgent next to a payroll deadline or getting assessment data back to schools. These activities inevitably get squeezed and we end up layering new systems or processes on top of old problems.

In practice this means protecting time for the people who know the processes, alongside the technical colleagues building the solution. It also means developing colleagues’ confidence, curiosity and skills to interpret information, question it and act. A dashboard is only useful if it changes a conversation, informs a decision or prompts action. Start by exploring what your existing systems can already do, including the automation built into them, and develop a realistic roadmap. Sustainable changes take time to design and implement.

Towards operational intelligence?

With connected and trusted data in place we can change the questions from “what happened last term?” to “what should we do this week?”. Bringing workforce and finance data together, for example, could help leaders understand how vacancies, absence and agency spending affect a school’s forecast. Over time, workforce data could also help flag recruitment and retention risks earlier. Finance, estates and procurement data can reveal opportunities to use resources more effectively. Success should be measured in time released, better service to schools, stronger financial control and earlier action on risks.

More predictive uses of data will take time, but trusts can make useful progress now. Choose one important decision, agree the definitions and ownership behind it, and test what existing systems can provide. Then review whether the information improved the decision. That is continuous improvement in practice: a short loop between insight, action and evidence of impact.

We are looking forward to having this discussion at the Schools and Academies Show on 19 November, sharing our experiences, but also learning from colleagues across schools and trusts who are grappling with the same challenges and designing new solutions.