Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Seattle Washington AirBnB Dashboard
Project type
Data Visualization and Business Intelligence Dashboard
Date
July 2, 2024
Tools Used
Tableau
Airbnb 2016 Data Analysis with Tableau
OVERVIEW:
This project focuses on analyzing 2016 Airbnb data to provide comprehensive insights into the Seattle rental market. The goal is to assist hosts in planning pricing strategies, help potential investors assess property values based on location, and aid analysts in understanding seasonal trends.
INSPIRATION:
I was inspired to undertake this project to enhance my data visualization skills and provide actionable insights for the Airbnb market. The dynamic and rapidly growing short-term rental market presented an ideal opportunity to explore real-world data and derive meaningful conclusions.
CREATION PROCESS:
Data Collection:
Sourced the Airbnb Listings 2016 dataset from Kaggle.
Data Preparation:
Cleaned and preprocessed the data to ensure accuracy and relevance.
Dashboard Development:
Utilized Tableau to create interactive visualizations, including bar charts, line charts, and geographic maps.
KEY INSIGHTS:
Average Price per Bedroom:
Larger properties command higher average prices, with a clear upward trend from 1-bedroom to 6-bedroom properties.
Price Variations by Zipcode:
Significant geographic price disparities exist, with central zip codes around Elliot Bay commanding higher average prices.
Seasonal Revenue Trends:
Revenue peaks in mid-June and around Christmas, indicating high demand during these periods. The revenue remains relatively high from June to December.
Listing Distributions:
Most listings have 0-2 bedrooms, reflecting market preferences and availability.
CONCLUSION:
This project not only honed my Tableau skills but also provided valuable insights for stakeholders in the Airbnb market. The dashboard enables users to make informed decisions regarding pricing, investment locations, and optimal rental times, ultimately helping to maximize revenue and optimize property management.