LSE does not yet have a Data Platform or Data Warehouse. Planning Division is working with DTS to commission work to establish the requirements for this functionality to submit a business case to Business Portfolio Board.
In the interim Planning Division works with DTS and other areas of the School to produce curated data sources which can be used to enhance the School’s knowledge in key areas.
Types of data source
Some data used by Planning Division are stored as a Tableau Server data sources.
This makes it easier to refresh all dashboards connected to a data source and manage access to data.
These are also maintained as Alteryx databases so that they can be used for further analysis. We also make use of bespoke and ad hoc data as required.
Tableau data sources
The key Tableau data sources used by Planning Division can be found below.
Contains student recruitment data from SITS for applications to the School and offers made by the School.
Example use: Department Profile dashboards to show the number of applications and offers at the undergraduate and postgraduate level.
Contains ranking data from the university league tables monitored by the School.
Example use: the School’s league table dashboard to show the show rankings at the institutional, subject, and metric level.
Contains data relating to course results at the School, such as marks, number of modules, and units passed.
Example use: Student outcomes by characteristic dashboard.
Contains data from the decliners survey, such as other institutions attended, reasons for declining and financial factors.
Example use: Departmental Profiles to show information about decliners by department.
Contains data about LSE from the Higher Education Statistics Agency, including entry qualifications, mode, scores, and subject.
Example use: to examine subject and cost centre coding for LSE Programmes.
Contains student population data from the School censuses with a range of student characteristics. Used in dashboards to show student population. Refreshed three times a year on 31 October, 31 December, and 31 May.
Example use: headcount and FTE data requests.
Contains student population data from regular censuses with a range of student characteristics.
Example use: Programme outcomes data.
Data sources containing data from course level and programme level surveys
at UG and PGT level run by Teaching Quality Assurance and Review Office (TQARO). Example use: to analyse the impact of student activity versus
student satisfaction.
National Student Survey (NSS) data sources created from data provided by Texuna. These two data sources contain LSE and sector data on the NSS of final year undergraduate students.
Postgraduate Research Experience Survey (PRES) provides information on the responses of postgraduate research students at LSE and across the sector. This survey is run every two years and the data source contains information on two surveys.