Excel Data Analysis Automation
Budget: $15 – $25 USD
Business context: The Open University is one of the largest universities in the world by number of enrolled students. In recent years, it has been working on developing an analytics platform called OU Analyse. This platform is designed to track student performance across its many programs, with the aim of reducing dropout and increasing student engagement and learning. Their analytics team is growing, and they have been actively looking to hire strong candidates. You have been shortlisted as one of them.
Business problem: As part of the interviewing process, you have been given an anonymized dataset and asked to compute the GPA (Grade Point Average) for all students in the October 2014 cohort and create a Tableau dashboard that includes their GPAs and demographic data.
Analytical context: You will be working with a subset of the OULA dataset, which contains demographic and assessment data for a number of UK-based students from the October 2014 cohort (coded as 2014J). The data is in the OULA.xlsx file (click on the file name to download the file). You will find four worksheets in this Excel file:
student_info contains demographic information about students as well as which “module” (course) they were enrolled in and whether they received a pass, a fail, or dropped out.
modules lists the different modules that the students could enroll in. The actual names have been replaced with three-letter codes for privacy reasons.
assessments has a table with all the assessments for each module, indicating the weight that each assessment had in the final grade.
student_assessment contains the actual grades that each student received in each assessment on a 0-100 scale. Most students in this sample only enrolled in one course, but there are some who enrolled in more.
The full documentation can be found here
Deliverable: In this extended case, you will be submitting 1 excel file that contains all of the exercise answers and your Tableau Dashboard link.
Business problem: As part of the interviewing process, you have been given an anonymized dataset and asked to compute the GPA (Grade Point Average) for all students in the October 2014 cohort and create a Tableau dashboard that includes their GPAs and demographic data.
Analytical context: You will be working with a subset of the OULA dataset, which contains demographic and assessment data for a number of UK-based students from the October 2014 cohort (coded as 2014J). The data is in the OULA.xlsx file (click on the file name to download the file). You will find four worksheets in this Excel file:
student_info contains demographic information about students as well as which “module” (course) they were enrolled in and whether they received a pass, a fail, or dropped out.
modules lists the different modules that the students could enroll in. The actual names have been replaced with three-letter codes for privacy reasons.
assessments has a table with all the assessments for each module, indicating the weight that each assessment had in the final grade.
student_assessment contains the actual grades that each student received in each assessment on a 0-100 scale. Most students in this sample only enrolled in one course, but there are some who enrolled in more.
The full documentation can be found here
Deliverable: In this extended case, you will be submitting 1 excel file that contains all of the exercise answers and your Tableau Dashboard link.