Nathan Morse

PhD student in Political Science
at Penn State University

Automatic Monthly Report

For my job as a data analyst at the Reitz Union, I created a satisfaction status report for the building’s hotel that can be automatically generated each month. The report, which is entirely coded in R, downloads survey responses from Qualtrics (an online survey platform) using an API token, cleans up the data using tidyverse functions, and produces a single-page infographic using grid functions. I coded nearly all of the project myself, with support from my supervisor when needed, and I designed the graphics. The only component of the report that requires manual human input is the qualitative comments. Other than that, this report can be produced at the click of a button each month to update the Hotel Manager, Business Director, and university officials on customer satisfaction.