Colleges already collect almost everything they need to manage the year. The problem is that most of it is seen after the year has ended. Here is how Power BI changes that.
Further education colleges use Power BI to bring learner records, attendance, the Individualised Learner Record and finance data into one model, so leaders can see enrolment, retention, achievement and funding while the year is still running and there is time to act. Most of the data already exists, because colleges collect it to make their returns. The gain is in seeing it weekly, by course and by learner group, instead of in a report that arrives after the learners have left.
The data colleges already hold
A college in England runs a student record system, such as ProSolution, unit-e or EBS, from which it produces the Individualised Learner Record (ILR) it returns to the Department for Education. The DfE took over that role when the Education and Skills Funding Agency closed on 31 March 2025. Alongside that sit attendance and register data, timetabling, the virtual learning environment, HR and finance. Colleges in Scotland, Wales and Northern Ireland return data to their own funders, but the internal picture is the same.
Each system answers its own questions well. What it cannot do on its own is show the principal, in one place, which courses are losing learners this term, what that does to next year's funding, and which groups of learners are falling behind on achievement.
What leaders want to see
- Enrolment against target, by curriculum area and funding stream, updated as enrolment happens.
- Attendance and early warning, so a learner whose attendance drops is seen in week three, not at the end of term.
- Retention, by course, campus and learner group, during the year rather than only in the final figures.
- Achievement, with in-year predictions alongside the qualification achievement rates the college will be judged on.
- Funding, showing how current learner numbers and retention translate into income, so finance and curriculum plan from the same figures.
How it is built
The Power BI model sits over a small data platform that takes regular extracts from the student record system, attendance and finance, and keeps history from year to year. The ILR is treated as one source among several: useful because its definitions are fixed, but too infrequent and too late to manage the year on its own. Row-level security means curriculum managers see their own area, while senior leaders and governors see the whole college.
The hard part is not the technology. It is agreeing definitions, such as when a learner counts as retained or withdrawn, so that the dashboard, the ILR and the curriculum manager's spreadsheet all give the same answer.
See it working
We built College Insight, a Power BI demonstration on sample further education data covering enrolment, attendance, achievement and funding reporting, so colleges can see the approach before committing to anything. You can open the College Insight demo on our site.
Where to start
Start with in-year retention and attendance, because those are the measures a college can still change. Build them well, reconcile them to the student record system, then add achievement and funding. A first version typically follows a four-week Establish phase and an 8 to 12 week build. Our free audit will show how much of it your current systems already support.
Related reading
From day seven to day two: automating the monthly reporting pack
Row-level security done right: when everyone should see only their own numbers
Three jobs, one dashboard, none of them done well
The date table: why every Power BI model needs one
Simon Devine
Managing Director
Part of the Hopton Analytics team, delivering governed analytics programmes for UK mid-market organisations.
