Visualization instruction

1.The points shown in the map represent the geographic location of zipcode in our data, and its radius size is the value of the average daily earnings. The blue dots represent the initialized area, the red dots represent the selected area, use the mouse to hover over or click the dot to get more information.
2.The x-axis in the top right bar chart is the zipcode for the region, and the y-axis is the return on investment (ROI value), calculated by the following formula:

ROI = Revenue / cost

Where Revenue is annual cash flow, we assume 365 days per year, occupancy rate: 75%, then the formula for calculating Revenue is as follows:

Revenue = price * days * Occupancy rate

Please brush bars to get more information.
3.The x-axis of the bar below is the specific year and the y-axis is the value of the apartment in dollars. The transition of the line color from red to green represents the value from small to large. Please use the mouse to hover over the line to get more information.

User guide

The problem we chose was: how to identify the most profitable investment area (zip code) for a real estate company or individual investor that specializes in buying properties within New York City for short or long term rentals as part of their business model. Our solutions are:
1. Property data was collected in Zillow and Airbnb for each zipcode in the New York area from 2007-2017, and property investments were selected by calculating return on investment (ROI) and viewing area home value curves. Among them, the larger the ROI, the more likely the investor is to make a profit.
2. Based on our data processing and visualization, you can easily find out that the area with the highest ROI is in 11003, which will be the best area for you to invest in if you can only buy one property. If several areas have the same ROI value, the home value curve is used to determine which has a greater impact on the costs and benefits.
3. On the other hand, we can make a choice by looking at the regional house value curve. With the data we collected earlier, we used Tableau to make a forecast. Investors can view the Revenue by growth rate. We did not make a forecast for home values after 2020 because of the uncertainty of home values caused by Covid-19.