This project is a Power BI dashboard analyzing Airbnb listings in New York City. Using the NYC Airbnb Open Data from Kaggle, this dashboard provides insights into Airbnb trends across NYC neighborhoods, including listing types, locations, pricing, and review patterns. It’s a valuable tool for understanding the Airbnb market in NYC and identifying potential opportunities or patterns in listing data.
The Power BI dashboard is organized into multiple sections, each providing a unique insight into NYC Airbnb listings:
- Room Type Distribution: A donut chart showing the percentage of listings by room type (Entire home/apt, Private room, Shared room). Helps users understand the market share of each room type in NYC.
- Geographic Map of Listings: This interactive map displays the locations of Airbnb listings across NYC. Users can filter listings by room type, Location, Neighbourhood, Price, Minimum Nights, and Number of Reviews, and zoom in on specific neighborhoods to see listing densities and patterns.
- Buttons to Switch Map View: Dark, Aerial, Road. Users can adjust the appearance of the map to visualize the exact location.
- Aerial and Table View Button: for viewing the instant summary of the current data in an interactive table.
- Reviews vs Month: A line chart visualizing the trend in Airbnb reviews throughout the year. Peaks and troughs may indicate seasonal patterns or trends in booking behavior.
- Airbnb Listings by Location: A clustered column chart showing the number of Airbnb listings in each NYC borough (Manhattan, Brooklyn, Queens, Bronx, Staten Island) with further breakdowns by room type. This chart highlights which boroughs have the highest listing counts.
- Average Price by Neighborhood: A bar chart displaying the average price of listings in prominent NYC neighborhoods. This can help identify the most and least expensive areas for Airbnb accommodations.
- Listing Name by Reviews: line and stacked column chart showing the most reviewed listings alongside their review counts, providing insights into popular listings and customer engagement.
- Listings A Card To show the number of listings.
- Sliders and slicers: for filtering data based on (Location, Neighborhood, Room Type, Minimum Nights, Number of Reviews, and Price)
- The Entire home/apt room type is dominating in New York City Airbnb Listings about 51.97% (25.41k) of the total listings. This suggests that many travelers to New York City prefer to have a full apartment or house to themselves during their stay.
- Private room shows the second largest dominance with 45.66% (22.33k) of the total listings. This indicates that private rooms are also a popular option for travelers, likely due to their affordability and the opportunity to meet other travelers.
- Shared rooms are the least common room type, making up only 2.37% (1.16k) of the total listings. This suggests that shared rooms are not as popular in New York City as in other destinations. Overall, the pie chart shows that the Airbnb market in New York City is dominated by entire homes and apartments, followed by private rooms. Shared rooms are the least common option.
-
Total Listings: 21.652k
Entire home/apt Listings: 13.2k
Private room Listings: 7.98k
Shared room Listings: 480 -
Total Listings: 20.098k
Entire home/apt Listings: 9.56k
Private room Listings: 10.13k
Shared room Listings: 413 -
Total Listings: 5.666k
Entire home/apt Listings: 2.1k
Private room Listings: 3.37k
Shared room Listings: 198 -
Total Listings: 1.09k
Entire home/apt Listings: 379
Private room Listings: 652k
Shared room Listings: 60 -
Total Listings: 373
Entire home/apt Listings: 176
Private room Listings: 188
Shared room Listings: 9 -
Manhattan: Mostly entire homes/apartments Brooklyn & Queens: Balanced mix of entire homes/apartments and private rooms Bronx: More private rooms Staten Island: Small number of listings, balanced mix This indicates that while entire homes/apartments are popular across all neighborhoods, private rooms are especially popular in Brooklyn, Queens, and Bronx, likely due to affordability and social interaction opportunities.
line chart shows a clear seasonal trend in Airbnb reviews, with a significant spike in July. Here are the key insights:
- Peak Season in June: Reviews hit their highest point in June, suggesting a peak in bookings, likely due to summer travel. This is a prime time for hosts to adjust pricing and availability.
- Low Activity Outside Summer: The review count remains relatively low and stable throughout the rest of the year, indicating lower booking activity during off-peak months.
- Seasonal Demand Pattern: This trend suggests that Airbnb demand in NYC is highly seasonal, with a surge in summer, which is helpful for hosts planning for peak seasons.
- The most expensive neighborhoods: Fort Wadsworth, Woodrow, and Tribeca have the highest average prices.
- There is a wide range of prices across neighborhoods. The most expensive neighborhood is more than 10 times more expensive than the least expensive neighborhood.
- Private Room has the highest number of reviews and a consistent review rate over time.
- HOME AWAY FROM HOME has the highest peak in reviews per month, indicating a surge in popularity at one point.
With this dashboard, we can interact and find many things in the New York City Airbnb Listings so download the dashboard project file open it with powerBI and enjoy.
Best Regards,
Aneesh Murali Nariyampully