Student Number Planning
Advanced Data Modelling in Alteryx
Download PDF Version
Student Number Planning
Advanced Data Modelling in Alteryx
Download PDF Version

Key Facts

Client: Higher Education Institution

Department: Strategy, Planning & Policy (SPP)

Tech Solution: Alteryx Designer

Challenges Faced:

Utilising Alteryx to automate HESA Data Futures

About the Company

Based in the United Kingdom, our client’s higher education institution provides education to 15,000+ full and part-time students from over a hundred and twenty countries.

A student body of this size requires rigorous and precise student number forecasting for upcoming academic years. The university was also looking for new approaches how to calculate corresponding income from tuition fees and grants and provide scenario planning for future years.

Click to Download Full 4-Page PDF Version of this Case Study


While the task of projecting student numbers and corresponding fee income is very difficult and laborious, it also plays a vital role in every university’s financial planning. Typically, there’s plenty of manual work involved as higher education institutions often use Excel as their go-to solution for formulas, calculations and various types of projections.

While this could work for smaller, simpler projects, the complexity of student number planning presents a different challenge. Students are accepted into different levels of study (undergraduate, postgraduate, research, associate) with different study methods (full time vs part-time, distant vs campus learners ect.) and separated into various fee status and funding categories.

There are also exchange students, students on placements, repeating students, or exceptional cases like interrupting students. Another level of complexity is added by the face that not all courses are similar in length and students may choose different paths throughout their studies, which makes the modelling even more challenging.

Alteryx Designer Interface

Interface of Alteryx analytical application for business users

Alteryx Solution Overview

Download Case Study to view Full Solution!

Fill out the form below to receive the free 4 page PDF Case Study

Download Here


Download the PDF Version of this Case Study!

Scroll to Top