Alteryx Case Studies Birmingham City University Conquers HESES Regulatory Deadlines with Alteryx

Edit This Case Study Record

	Birmingham City University Conquers HESES Regulatory Deadlines with Alteryx Alteryx

Birmingham City University Conquers HESES Regulatory Deadlines with Alteryx

Alteryx

Technology Category	Analytics & Modeling - Data-as-a-Service Analytics & Modeling - Real Time Analytics
Applicable Industries	Education
Applicable Functions	Business Operation
Use Cases	Predictive Quality Analytics Predictive Replenishment
Services	Data Science Services
Challenge	Birmingham City University is required to make mandatory annual returns to the OfS (Office for Students, previously HEFCE) to verify its government funding allocation. The Planning and Performance Department must pull together information from several internal systems and external sources to complete the aggregated funding return of student activity. Amassing and preparing the data from multiple sources is a significant, sizeable and complex challenge; with regulatory timeframes for the HESES return generally imposing a 7 working day turnaround from the census point of 1 December. Improving automation and underpinning processes became increasingly important both for securing efficiencies and for maintaining high levels of data integrity. It is essential that legitimate changes compared to prior years are clearly and accurately demonstrated, as this has the potential to affect the university’s core funding grant. Read More
About Customer	The first Birmingham School of Design was opened in 1843 by The Birmingham Society for Artists, and gained university status in 1992. Since then, it has evolved into a thriving institution with 24,000 students from around the world and has been recognised as a world-leader for its research across various disciplines. Today, the university produces some of the UK’s most employable graduates from its state-of-the-art facilities in Birmingham, England. Delivering these services are four faculties, which cover a broad range of subjects and specialisms. Read More
Solution	In response to the increasingly data-driven requirements of the sector, the university was investigating Tableau to improve its business intelligence (BI) analysis generally, when it discovered Alteryx. The team extract student enrolment data for the current reporting year from SITS – the university’s student record management database – and inject it into Alteryx. They then use Alteryx to blend it with other key reference data, including ‘static’ data relating to courses, modules, funding and fees categories. This allows them to process Undergraduate separately from Postgraduate to reflect the different HESES funding calculations and reporting requirements. These categories include UK or EU fundable students, overseas non-fundable students, level of study such as undergraduate or postgraduate, whether the students are new entrants or continuing, funding group splits, and more. This process creates the current “census population” dataset to which is added a prediction around “late enrolments” such as starts after the December census date, which come from the four faculties. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Data-as-a-Service

Analytics & Modeling - Real Time Analytics

Applicable Industries

Education

Applicable Functions

Business Operation

Use Cases

Predictive Quality Analytics

Predictive Replenishment

Services

Data Science Services

Challenge

Birmingham City University is required to make mandatory annual returns to the OfS (Office for Students, previously HEFCE) to verify its government funding allocation. The Planning and Performance Department must pull together information from several internal systems and external sources to complete the aggregated funding return of student activity. Amassing and preparing the data from multiple sources is a significant, sizeable and complex challenge; with regulatory timeframes for the HESES return generally imposing a 7 working day turnaround from the census point of 1 December. Improving automation and underpinning processes became increasingly important both for securing efficiencies and for maintaining high levels of data integrity. It is essential that legitimate changes compared to prior years are clearly and accurately demonstrated, as this has the potential to affect the university’s core funding grant.

About Customer

The first Birmingham School of Design was opened in 1843 by The Birmingham Society for Artists, and gained university status in 1992. Since then, it has evolved into a thriving institution with 24,000 students from around the world and has been recognised as a world-leader for its research across various disciplines. Today, the university produces some of the UK’s most employable graduates from its state-of-the-art facilities in Birmingham, England. Delivering these services are four faculties, which cover a broad range of subjects and specialisms.

Solution

In response to the increasingly data-driven requirements of the sector, the university was investigating Tableau to improve its business intelligence (BI) analysis generally, when it discovered Alteryx. The team extract student enrolment data for the current reporting year from SITS – the university’s student record management database – and inject it into Alteryx. They then use Alteryx to blend it with other key reference data, including ‘static’ data relating to courses, modules, funding and fees categories. This allows them to process Undergraduate separately from Postgraduate to reflect the different HESES funding calculations and reporting requirements. These categories include UK or EU fundable students, overseas non-fundable students, level of study such as undergraduate or postgraduate, whether the students are new entrants or continuing, funding group splits, and more. This process creates the current “census population” dataset to which is added a prediction around “late enrolments” such as starts after the December census date, which come from the four faculties.

Impact #1	The team use Alteryx to collect, blend, verify and analyse data from multiple sources within this tight timescale
Impact #2	There’s no need to reinvent the wheel every year or for each new workflow, liberating the team to work on other important projects
Impact #3	Creating a culture of analytic excellence through Data Quality (DQ) reports for faculty administration colleagues

Impact #1

The team use Alteryx to collect, blend, verify and analyse data from multiple sources within this tight timescale

Impact #2

There’s no need to reinvent the wheel every year or for each new workflow, liberating the team to work on other important projects

Impact #3

Creating a culture of analytic excellence through Data Quality (DQ) reports for faculty administration colleagues

Benefit #1	HESES Return filed in 7 days

Benefit #1

HESES Return filed in 7 days

Download PDF Version

Overview

Birmingham City University Conquers HESES Regulatory Deadlines with Alteryx

Operational Impact

Quantitative Benefit