- SQL (PostgreSQL)
- Tableau
The datasets were sourced from the Inside Airbnb website, which provides detailed information on Airbnb listings in cities worldwide. This data includes a wide range of attributes such as listing IDs, host details, neighborhood locations, room types, #, availability, and more. The data is regularly updated and offers a comprehensive view of Airbnb activity across the city’s five boroughs, making it an ideal source for analyzing trends in the Airbnb market.
The analysis involved several steps, starting with a thorough exploration of the data using SQL queries in PostgreSQL's pgAdmin 4 to understand the structure, check for missing values, and calculate basic statistics. This was followed by more detailed analyses to uncover trends in #, room types, and neighborhood activity. Key insights were then visualized in Tableau, with dashboards showcasing individual listings on a map of New York City, and neighborhood-level trends in # and availability.