Project Description

York St. John University – Student Number Planning Case Study



With nearly 7,000 students, York St. John University’s original student number planning solution involved a mainly manual, Excel-based approach that was dependent on a handful of Finance team individuals. The process was not sufficiently documented or visible to a wider teaching audience. This sort of ‘black box’ process led to a distrust amongst management in regards to the outputs and made longer-term forecasting of numbers difficult and time consuming.


To streamline the complex process of creating one accurate projection, the team has decided to leverage Alteryx, cutting down calculation time from over a week to just a couple of seconds, all the while improving their predictive capabilities. Aside from the business logic itself, the workflow also contains various data validation rules, testing key data joins and automatically highlighting and identifying data quality issues should they arise. This makes it very easy for everyone to understand, use, edit or customise.

Student Number Planning in Action

(This video is a general higher education solution video, and is not specific to York St. John University)

Student Number Planning in Action

(This video is a general higher education solution video, and is not specific to York St. John University)

University Image


The undergraduate home student’s model was fully automated, catering for 85% of university’s tuition fee income. The team now focuses on building a separate model covering non undergraduate home students, further improving projections’ accuracy and eliminating human-induced errors. The more transparent model helps them make informed, focused decisions.

  • Key process automation was completed within 3 business days

  • Future analysis planning/what if analyses are run within seconds

  • The transparent and accurate model improves decision-making

Andrew Fern Testimonials Image

“Billigence’s approach to enabling my team to use Alteryx has been first class. We never felt lost in the complexity of the process and Billigence was able to teach us and show us what we needed to do simultaneously.  It was also great fun.  We made far more progress in one working week with Billigence than we had dreamed was possible at the start of the project.  Undoubtedly we will become avid Alteryx users and keep our link to Billigence’s expertise on student number planning to ensure our University prospers.”

Andrew Fern, York St. John University

Download the PDF version of this Case Study!

To download this content, please provide your email address. Please note that by providing us with your e-mail address, you agree to receive occasional communications from Billigence.