Automatic Reports from University Survey Data

Consulting job done for Data Science Consulting Class Fall 2024. For this project, I was tasked with helping Jennifer Ballard in the institutional research department to create a script that would automatically generate reports when a new survey year was given. This survey data was taken each year from alumni who had graduated the previous year. To create the report, I started by going through all the data and coming up with ideas on what I could do that would be of interest in a report. Then, I went through and created tables and graphs of every column I could, cleaning the data as needed and combining columns when appropriate. I then had meetings with Jennifer Ballard to present my progress, and she told me what order she wanted the data presented in, as well as what data was not important. I then went through and put the data for the reports in order and formatted the tables and charts. Through a couple more meetings, I finalized the script and sent the script along with the reports for each year of data gathered so far. These reports were split up by department, as well as major.