National Student Survey data as a Tableau Data Extract
For all the UK Higher Education Tableau users out there I thought it might be useful to transform National Student Survey data from Excel files in to Tableau Data Extracts (.tde).
About the Data
The National Student Survey is conducted once a year amongst all final year university students. The results are used in university league tables, meaning university staff are very eager to analyse their results to see where they are doing well and what they could improve.
You can download the NSS data from the HEFCE website in Excel format. Unfortunately the Excel files are not formatted for Tableau. Using Alteryx (who The Information Lab recently partnered with), I was able to not only format the NSS Excel files in to a Tableau friendly format, but I also added in some additional fields which analysts of the NSS data might find useful.
All the existing fields from the Excel files are available in the .tde plus a few extras:
- Answered 1-5 value: the number of respondents per answer option (1-5)
- Average Score: the mean score of each question (Q1-28) or each answer option (1-5)
The Data Files
NSS data as a .tde is available from us from 2008 onwards. Click on the links below to begin download.
In a follow up post I will explain how I used Alteryx to create these .tde files, in the meantime if you have any further questions please get in contact with us or leave a comment below.