❓Exploring Airbnb’s Expansion in Personalized Travel Experiences: A Data-Driven Analysis of NYC Homestays
Airbnb is reshaping the travel landscape by offering more unique and tailored experiences for travelers. This analysis seeks to derive meaningful insights from historical booking data of homestay listings in New York City. To do so, we will employ the Extract-Transform-Load (ETL) process to analyze key aspects of the data, answering essential research questions related to:
Host Engagement & Performance Neighborhood Popularity & Trends Customer Pricing Strategies Guest Reviews & Satisfaction By exploring these factors, this report aims to uncover patterns and insights that can help enhance Airbnb's travel offerings and improve both host and guest experiences in NYC.
- Excel
- Power BI
- Power Query
- PowerPoint
Watch the complete Dashboard video Link
Our comprehensive analysis of Airbnb homestays in New York City reveals intriguing trends and preferences in customer behavior, host success, and pricing strategies. Below are the standout findings:
Manhattan: The Epicenter of Airbnb Activity Manhattan dominates the Airbnb market with the highest number of bookings across all neighborhood groups. Notably, the top-earning hosts also have the majority of their bookings in this area, solidifying Manhattan as the most preferred destination for travelers.
Pricing Paradox: High Prices, Fewer Bookings Interestingly, neighborhoods with the highest average pricing tend to experience fewer bookings. This suggests that while premium areas exist, they are less frequently chosen by guests.
Price vs. Reviews: Consistent Across the Board When comparing average pricing with review scores, the pricing remains relatively consistent across various review ratings, indicating minimal correlation between price and customer review scores (out of 5).
Room Type Preferences Travelers overwhelmingly prefer Entire Homes/Apartments and Private Rooms as their accommodation types. Despite being the most popular, these room types also boast lower average pricing compared to other options.
Manhattan’s Room Type Breakdown Within Manhattan, 88% of the bookings are for Entire Homes/Apartments, reinforcing its appeal as a destination for guests seeking privacy and a complete space to themselves.
These insights offer a clear understanding of the current trends in the New York City Airbnb market, helping hosts and travelers make more informed decisions.
High Level Design Document Link
Low Level Design Document Link
Architecture Link
WireFrame Link
Report Link
If you have any feedback, please reach out to me at Linkedin