patrón hexagonal azul
Customer Story

University of Nottingham + Alteryx

patrón hexagonal azul

Building A "Super System" For Student Planning + Income Modeling


One of the UK’s largest universities and research institutes, the University of Nottingham is ranked in the top 20 of several major UK league tables and listed in the top 100 universities worldwide. It boasts novelist D. H. Lawrence among glittering alumni and is responsible for many ground-breaking inventions including the MRI scanner. About 45,000 students from around the world are spread across multiple campuses in Nottingham and in Malaysia and China. With strong links to other universities and companies worldwide, Nottingham offers over 800 courses covering everything from medicine, science and engineering to social sciences and the arts.

The State of Play

Student income is the largest income stream for the University of Nottingham, and each year the university must forecast its student population and the related income in order to allocate departmental budgets. The planning and performance team is responsible for collecting and analyzing up to nine million records of data on thousands of students across the globe to model expected student numbers and activity accurately.

However, with 56 departments requiring deep levels of analytical granularity and five-year forecasts, calculations are complex. By 2015, the team desperately needed a more dynamic student planning model that would allow increased granularity and subsequently improve decision making, whilst working alongside Tableau’s data visualization. The task would be to handle all reporting for student planning and forecasting as well as verifying data for HESA (Higher Education Statistics Agency), the body that collects quantitative data about higher education in the UK.

The team had earlier replaced Microsoft Excel with IBM Cognos planning and business intelligence software to cope with scalability needs but keeping the data warehouse relevant was difficult and expensive. Utilizing Tableau was relieving some limitations but querying and data preparation were still problematic.


That’s when Alteryx came along and changed everything.

Why Alteryx?

Davidson’s team initially took advantage of Alteryx to clean and prepare the data for Tableau by completely scrapping the student elements of the data warehouse and rebuilding a new dataset in Alteryx, comprising 10 years of student data.

“Coding wasn’t required so we were able to build the system ourselves,” Davidson says. “Within two weeks we had a proof of concept and Alteryx was handling the volume with ease. So, we kept developing and within two months we’d built an entire student number planning and income model. There was excitement within the team because using the product had opened the door to many new and exciting possibilities. In addition to our student number planning model, we have managed to recreate our data warehouse from scratch, as well as beginning to leverage data on applicants’ A-level grades to model which students we want to actively recruit.”

Share the insights with your team

Automóvil de carreras McLaren
Historia de cliente

McLaren Racing agiliza el análisis de datos en la carrera por acelerar

Con más de 20 fines de semana de carrera en el calendario de la Fórmula 1 (que generan 1,5 TB de datos), es fundamental poder recopilar y procesar esos datos, para luego actuar en consecuencia. El equipo de McLaren Racing usa Alteryx Analytics Automation Platform para acelerar la toma de decisiones estratégicas, tanto dentro como fuera de la pista.

Cadena de suministro
Líder de analítica
Inteligencia de negocios/Analítica/Data science
Leer ahora
Apter Streamlines Customer Tax Projects with Alteryx
Historia de cliente

Apter optimiza los proyectos fiscales de los clientes con Alteryx + UiPath

La consultoría fiscal Apter creó una solución de administración fiscal integrada y totalmente automatizada en tres semanas.

Reducción de riesgos
Líder comercial
Leer ahora
Logotipo de Takenaka en la parte superior de la foto de un edificio moderno
Historia de cliente

La aplicación de datos acumulados durante 300 años al diseño arquitectónico de vanguardia

Alteryx funciona como una caja de herramientas moderna, al convertir información que se ha almacenado y guardado durante mucho tiempo en datos utilizables que transmiten los pensamientos y sentimientos de las personas, …

Preparación de datos y analítica
Leer ahora

Experience the power and ease of Alteryx

Prueba gratis