From Spreadsheet Chaos to Strategic Planning: What Edinburgh Napier University's Success Can Teach Higher Education Leaders
How much time is your institution spending managing spreadsheets instead of making decisions?
For many universities, student number planning remains one of the most critical, resource-intensive, processes in the organisation. Accurate student forecasts influence everything from financial planning and staffing to course investment and long-term institutional strategy. Yet many institutions still rely on disconnected spreadsheets, manual consolidation, and lengthy review cycles to produce those plans.
It’s a challenge I have seen across multiple industries but in this case the education sector, and one that Edinburgh Napier University set out to solve.
As Scotland’s number one modern university in the Times Higher Education World University Rankings 2025, and the leading university in Edinburgh for student satisfaction for five consecutive years, Edinburgh Napier has built a reputation on delivering outstanding outcomes for students. To continue doing so, the university needed a modern planning process capable of supporting more than 20,000 students across more than 250 undergraduate and postgraduate programmes.
The Challenge
The problem wasn’t a lack of data. It was the way the data was being managed.
Student number planning relied on multiple spreadsheet versions being shared across departments through email and shared drives.
-
Different teams often worked on different versions of the same dataset, creating challenges around accuracy, version control, and governance.
-
Consolidating plans were labour-intensive, and making even minor changes could trigger lengthy recalculations and reviews.
-
Most importantly, valuable planning expertise was being spent on administration rather than analysis.
The Solution
Working with a specialist IBM Business Partner, Edinburgh Napier implemented a Student Number Planning solution using IBM Planning Analytics.
The objective was straightforward: create a planning environment that was flexible enough to handle the complexity of academic planning, structured enough to support governance and financial alignment, fast enough for iterative decision-making and transparent enough to build confidence across the institution.
The results were transformative.
-
Instead of exchanging spreadsheets, departments now work within a shared planning environment with a single trusted source of data.
-
Users enter information directly into standardised planning interfaces, and updates are immediately available across the organisation.
-
Consolidation happens automatically, dramatically reducing the administrative burden on planning teams.
Of course, successful transformation is rarely just about technology.
One of the clearest lessons from this project was the importance of stakeholder engagement. Edinburgh Napier established trust early by involving faculties and departments throughout the design process. The team also adopted an iterative approach, focusing on core planning drivers first before expanding capabilities over time.
The Result
The measurable impact speaks for itself.
Previously, three senior planners worked with subject leaders across departments to build student number plans. Producing a draft plan required approximately three days of effort, followed by a further two days of review and refinement. Across two planning cycles each year, plus consolidation activity by the central planning team, the process consumed around 35 days of effort.
Today, the same planning activity takes just seven days.
That’s an 80% reduction in planning effort, freeing specialists to focus on higher-value activities rather than administration.
This 80% reduction relates to the main planning cycles but does not take into consideration the further updates and changes which are inevitable in a complex planning process. These have significantly increased over the years due to increasing instability in the sector, this would have been untenable in the old Excel system which took 5 times longer in activity than with the current process.
-
The benefits go even further.
-
A ten-year forecast that previously required four members of staff working for two days, approximately eight days of combined effort, can now be produced by a single planning officer in minutes.
-
Scenario modelling has also been transformed.
-
Questions that once took hours or days to answer can now be explored almost instantly.
-
Whether assessing future course demand, evaluating programme changes or understanding the financial implications of strategic decisions, leadership teams now have faster access to the insight they need.
The result is more than a new planning system. It’s a new way of working.
Looking ahead, the university plans to build on this foundation by using student planning data to support future timetabling and resource planning initiatives, extending the value of trusted data across the institution.
For education leaders navigating increasing complexity, tighter budgets and growing demands for accountability, Edinburgh Napier’s story offers a powerful reminder: the goal isn’t simply to make planning faster.
It’s to give your people the time and confidence to make better decisions.
Tell us how we can help
Book in a chat with our team
Case Studies
Don’t just listen to us, our clients always say it better than we do. We’re just too humble.
