The objective of the property analysis is to provide recommendations to help the client find the most profitable location for a property in Amsterdam, Netherland.
The process included making SQL queries to acquire the Airbnb's supply and demand data, and comparing the monthly income across 7,109 properties in 20 different neighborhoods in Amsterdam, Netherland. Data that were used include the advertised Airbnb prices, room types, occupancy rate and population. By looking into the monthly income and competitiveness based on location and property type, I was able to offer a more holistic view to help the client make a purchase decision based on the Airbnb market data.
A dynamic map with information including property type, neighborhood data and income data is created with Google Fusion. Green pins are properties with a monthly income greater than $901 while the yellow pins are properties with a monthly income between $800 and $900.
Data Analysis, SQL, Excel