Overseas Student Number Planning
- Former user (Deleted)
This workbook contains data and graphs designed to provide an overview of the international recruitment at the University of York, from application to enrollment, with features to export the data seamlessly.
The Overseas Predicted Enrolments and the Overseas Applicants Details views were developed to empower the users to explore the data in-depth, hence the large number of parameters available to manipulate the data on display.
Conversely, the International Arrivals Risk Report view was developed to provide a quick view of the aggregate risk of no show that the academic units are exposed to.
The Overseas Predicted Enrolments and the Overseas Applicants Details views rely on data produced via an Alteryx workflow, whereas the International Arrivals Risk Report uses live data from SITS.
In general, the data can be aggregated by:
- Department
- Faculty
- Mode of study
- Domicile
There are levels of aggregation that are specific to each view as well.
The Overseas Predicted Enrolments is a view that feeds off a Tableau hyperextract produced by an Alteryx workflow.
It predicts the number of enrolments by applying the previous years conversion rates to the amount of applicants in the pipeline at the time the data was produced.
It shows the gap to the target in each academic unit.
Levels of aggregation
The academic units are part of a hierarchy, thus the number of enrolments can be drilled down to the route level.
The full hierarchy is the following:
- Faculty
- Department
- Programme
- Route
Scenario planning
In light of the gap to the target, users can simulate in the Scenario planning box how the number of enrolments would be if they dialed up or down the application to offer rates and/or the offer to enrolments rates.
The percentage change to the conversion rates can be applied to all departments or to only those that are below the target. A description of the change is displayed on the left side of the respective parameters.
This exercise directs the users to think of the areas that need more resources and which levers they have at their disposal to affect the overseas recruitment.
Cohort composition
The bubble chart below the Scenario planning box displays the predicted cohort composition, split by geographic region.
Conversion rates
The bar chart below the Scenario planning box displays the Application to offer rate in grey and the Offer to enrolment rate in blue, with the average rates across the geographic regions overlaid.
Limitations
The limitation of this prediction is that it disregards the number of students that might still apply in the future.
The data needs to be updated manually via Alteryx and then its output needs to be loaded to the respective Tableau file.
Also, the targets are not easily accessible and usually are available on static files only.
The Overseas Applicants Details is a view that feeds off a Tableau hyperextract produced by an Alteryx workflow.
It displays the details of the applicants, including a circle graph that indicates the application milestones that each student has reached.
This view is aimed at international recruiters at the operational level, which can track the changes to the applications within their regions over time more easily.
Levels of aggregation
The data can be aggregated by geographic region, by faculty, by agent or even by sponsor.
The aggregation by region and by faculty use an individualized version of the data, whereas the others use a non-individualized version of it.
That happens because one applicant can be linked to multiple agents as well as to multiple sponsors concomitantly.
Time based filters
The underlying data contains the date of the latest change to the application as well as its content.
Therefore, it is possible for the end users to select only applications that have changed since a given date. The options are:
- Changed since last update
- Changed within the last fortnight on record
- Changed within the last month on record
- Changed earlier this year
- Changed before the beginning of this year
Limitations
The data needs to be updated manually via Alteryx and then its output needs to be loaded to the respective Tableau file.
The International Arrivals Risk Report is a view that feeds off data from SITS, updated daily on a materialized view in the Oracle database.
The data is provided and vetted by SDMI and contains an individualized record of each person expected to study at the University in the upcoming academic year, including new starters and continuing students.
The view assigns each overseas student in the data aforementioned to a risk group, depending on attributes such as their CAS status, accommodation booking and pre-payment, their registration status, and the date of registration.
This view is aimed at any stakeholders interested in a detailed appraisal of how many overseas students might in fact show up for classes. These include Planning officers, international recruitment officers, Deans and Heads of Departments.
Main levels of aggregation
The academic units on the Overview are part of a hierarchy, thus the aggregate number of students per risk group can be drilled down to the Department level.
Further levels of aggregation
The bar charts just below the Overview, contain the number of students per risk group aggregated at the Department and the Country of Domicile levels.
Limitations
The ownership of the data resides with SDMI.
Each view has its own refresh schedule:
- Overseas Predicted Enrolments (updated via Alteryx weekly)
- Overseas Applicants Details (updated via Alteryx weekly)
- International Arrivals Risk Report (daily)