These visualizations contain data sourced from a Google survey on NYC restaurant reviews by DATA 73000 students. The survey contained questions regarding student name, restaurant name, restaurant location, yelp star rating, service rating, food rating, borough, food type, ambiance rating, and additional comments. I imported the data directly from Google Drive and created the below visualizations in Tableau. To clean the data, I used the SPLIT function in Tableau to separate delineated variables in the “Food Type” and “Name” category, and then corrected typos directly in Google Sheets.
This scatterplot graph shows the ambiance rating as compared to the yelp star rating, the service rating, and the food rating.
This map shows the count of restaurants in the survey by borough. To get here, I had to convert the geographic role of the “Borough Name” latitude and longitude attribute to “county” to generate the interactive polygon map.
This pie chart shows the restaurant recommendation contributors by first name.
This bar chart shows the average restaurant rating (1-5) by contributors. To get here, I created a simple calculation in Tableau adding the ambiance, food, and service rating and dividing by 3 to create an “Average Rating” attribute. Tableau automatically used a sum function instead of an average function, so after changing the function the values showed up as expected.
This line graph shows the responses by survey participants by day. To get here, I changed the timestamp from YEAR to DAY to accurately reflect when the students submitted their responses.
Email us at commonshelpsite@gmail.com so we can respond to your questions and requests. Please email from your CUNY email address if possible. Or visit our help site for more information:
