Repository files navigation

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 & PerformanceNeighborhood Popularity & TrendsCustomer Pricing StrategiesGuest Reviews & SatisfactionBy 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.

1. Excel
2. Power BI
3. Power Query
4. PowerPoint

Watch the complete Dashboard videoLink

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 ActivityManhattan 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 BookingsInterestingly, 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 BoardWhen 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 PreferencesTravelers 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 BreakdownWithin 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 DocumentLink

Low Level Design DocumentLink

ArchitectureLink

WireFrameLink

ReportLink

If you have any feedback, please reach out to me atLinkedin