[Solved] Reviews Last Review Reviews

READ ALL OF THESE INSTRUCTIONS CAREFULLY

First – you will need access to Tableau:

You can get a free copy of Tableau at – https://www.tableau.com/university-studentsLinks to an external site.
Tableau is also available in the computer labs at school and the virtual lab at https://sbus-vdi.montclair.edu/portal/webclient/index.html#/Links to an external site.

For this assignment you will be using Tableau to analyze AirBnB rental data from New York City.

To start you need to download this file – airbnb_nyc_clean.zip Download airbnb_nyc_clean.zipThe file is compressed, so you will need to unzip it. If you are not sure how to do this Google is your friend.

Data

This data set contains the following attributes:

id
name (really more of a description of the rental)
host id
host verified (verified or unconfirmed)
host name
neighborhood group (really the borough)
neighborhood
latitude
longitude
instant bookable
cancellation policy (strict, moderate, flexible)
room type
construction year
price (rental price per night)
service fee
minimum nights
number of reviews
last review
reviews per month
review rate number (1 – 5)
calculated host listing count (number of listing host has in NYC)
availability 365 (the availability of the list 365 days into the future)
house rules

Assignment

Use Tableau to analyze the data and create visualizations to answer the following questions:

Analyze which neighborhoods have the highest average price. To do this create a horizontal bar chart that is sorted in descending order. Indicate in the comments which neighborhood had the highest average price.
Create a map visualization that show the average price on Staten Island. Hint – you’ll need the latitude and longitude. Another hint – you’ll need to filter by neighborhood. In the comments indicate if there are more rentals close to NY or NJ.
Create a vertical bar chart that compares average price received by verified and unconfirmed hosts. In the comments indicate if there was a major difference between them or not.
Create a treemap that shows which hosts (by name) have the most reviews on Staten Island (you’ll need the filter again). In the comments indicate which host has the most reviews.
Create your own interesting visualization. In the comments indicate why you created it and what it reveals.

Each worksheet MUST have an label that indicates the question number and the actual visualization. Example: Q1 – AVG Price By Neighborhood.

Save your Tableau file as [Your Name].twbx (obviously replace with your actual name). Failure to properly name your file will result in an automatic 50% penalty!

Submit your resulting Tableau workbook with data (saved as a “.twbx” file) via Canvas and don’t forget to put your comments in the text box for this assignment.

HINT – the images below will give you some idea of what your visualizations should look like. Note – I used different data so your visualizations will not match the images exactly.