- Tool: Tableau Public
- Dataset: Seattle Airbnb Open Data (2016)
- Data Source: 🔗 Kaggle – Seattle Airbnb Open Data
🔗 View the interactive dashboard on Tableau Public
📌 Overview
This Tableau dashboard provides an in-depth visual analysis of Airbnb listings in Seattle, focusing on:
- 📈 Pricing trends by bedroom count
- 📍 Geographic price distribution by zip code
- 💼 Annual revenue patterns
- 🏘️ Listing inventory by property size
The goal is to uncover actionable insights for both prospective Airbnb hosts and travelers based on real open data.
📊 Key Visualizations & Insights
1. 💵 Avg Price per Bedroom
- Insight: A strong positive correlation exists between the number of bedrooms and average nightly price.
- Data Highlights:
- 1-bedroom: ~$96.2
- 2-bedroom: ~$175.4
- 6-bedroom: ~$584.8
- Takeaway:
- For Hosts: More bedrooms = higher earnings potential.
- For Travelers: Consider smaller units for more budget-friendly options.
2. 🛏️ Bedroom Listing Distribution
- Insight: The Seattle Airbnb market is heavily dominated by 1-2 bedroom listings.
- Data Highlights:
- 1-bedroom: 1,811 listings
- 2-bedroom: 483 listings
- Larger units (3+ bedrooms) are rare.
- Takeaway:
- For Hosts: There may be an opportunity in niche segments (3+ bedrooms) with less competition.
- For Travelers: Easier availability for 1–2 bedroom stays.
3. 🗺️ Price by Zip Code
- Insight: Certain zip codes command significantly higher average prices.
- Top Zip Codes by Price:
- 98119 (Queen Anne area)
- 98109 (South Lake Union)
- 98199 (Magnolia)
- Takeaway:
- For Hosts: Properties in premium zip codes offer higher revenue potential.
- For Travelers: Consider more affordable zip codes when planning your stay.
4. 📆 Revenue Over Time
- Insight: Airbnb revenue in Seattle trended upward from January to December 2016, with strong seasonality.
- Trend Highlights:
- Revenue grew from ~$1M to ~$2M during the year.
- Noticeable rise in summer and end-of-year months.
- Takeaway:
- For Hosts: Summer and holiday seasons are key opportunities to maximize pricing.
- For Travelers: Book early or during shoulder seasons for better rates.
📈 Overall Market Narrative
The Seattle Airbnb market (as of 2016) shows:
- 📏 Size Matters – More bedrooms drive higher prices.
- 🏘️ 1–2 Bedrooms Dominate – These listings flood the market, especially for solo travelers and couples.
- 📍 Location = Leverage – Hosts in key zip codes earn more per night.
- 📆 Upward Growth – The market was expanding, with clear seasonal revenue peaks.
💡 Future Enhancements
- Add revenue estimation per listing (price × availability_365).
- Introduce filters by room type or host status.
- Include predictive forecasting and host review analysis.
- Overlay event calendars to explain seasonal demand spikes.