Month: September 2022

Categories
Uncategorized

Lab 3 Visualization

This visualization dashboard shows the title of the dashboard, the description of the dashboard, the average restaurant rating per student, the restaurant recommendation contributors by name, a map of the restaurant recommendations, and the source cited. I created this dashboard by using the “Dashboard” feature in Tableau and following along Professor McSweeney’s instructions on Youtube, including the suggested design edits. In the embedded link on this page, you have to scroll down to see each visualization. During the next lab I will look into ways to show the entire dashboard via an embedded link.
Categories
Uncategorized

Lab 1+2 Visualizations

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.
Categories
Uncategorized

Lab 0 Visualization

This visualization shows US population estimates by Country from 1985-2015. The data is originally sourced from the UN. I imported the data from Excel into Tableau and created a line chart comparing population (in billions) of each country as compared to the year.