New York City Airbnb Dashboard
Personal Project
Project Type:
PowerBI, Dashboard, Python
Date:
GitHub Repo:
Project Background
With tens of thousands of listings across New York City, the Airbnb market presents both opportunities and pricing challenges for hosts, guests, and investors. This project analyzes listing prices, review volume, room types, and neighborhood-level dynamics using the NYC Airbnb dataset. The goal is to surface actionable insights that can improve pricing strategies, attract target audiences, and increase guest satisfaction in a competitive landscape.
Executive Summary
The analysis highlights clear pricing patterns across boroughs and room types, supported by over 22,000 listings and 770,000 reviews. Using exploratory visualizations and pricing vs. review comparisons, key trends emerged:
-
Manhattan leads in listing price; Bronx is most affordable.
-
Listings under $500 receive the most guest engagement.
-
Hotel rooms and entire homes command premium pricing.
-
Price volatility is visible in certain years — notably 2022.
Listings with higher prices tend to receive fewer reviews, suggesting affordability is important to guest interaction.
Dashboard & Insight
Key Findings
-
Borough Pricing Trends: Manhattan commands the highest average prices across the boroughs, with the Bronx offering the most affordable options.
-
Accommodation Types: Hotel rooms and entire homes are priced at premium rates, while private and shared rooms are more economical, catering to budget travelers.
-
Seasonal Price Fluctuations: There are notable variations in pricing over time, with significant peaks observed in specific periods. For example, the year 2022 saw a spike in prices across listings in the Bronx, Brooklyn, and Staten Island.
-
Price vs. Reviews: Listings with higher prices tend to garner fewer reviews, indicating that more affordable listings are more frequently reviewed, suggesting that affordability may influence guest engagement.
Recommendations
-
Optimize Pricing: Listings under $500 receive more engagement, making them more attractive to guests.
​
-
Target Budget Travelers: Hosts in Queens, Bronx, and Staten Island can attract price-sensitive guests.
​
-
Luxury Listings Need Unique Value Propositions: High-end Airbnb stays should enhance guest experience to justify premium pricing and increase listing reviews.
​
-
Use Seasonal Pricing Models: Adjust rates based on historical price trends and demand fluctuations.
Citation
Inside Airbnb. (n.d.). Get the data. http://insideairbnb.com/get-the-data/​
Thank you! Please message any suggestions.