AirbnbNewYorkCityAnalysis

Dashboard

AirbnbNewYorkCityAnalysis is a comprehensive data analysis and visualization project exploring short-term Airbnb rental trends across New York City (2008–2022). Using open-source Airbnb data, the project combines data cleaning, statistical summaries, and Tableau dashboards to uncover pricing patterns, borough-level distribution, and market insights.

Overview

This project was developed as part of a data visualization and analytics coursework project, leveraging public data and analytical tools to produce insights valuable to hosts, investors, and policymakers.

Core objectives included:

• Cleaning and preparing a large dataset (~190K listings)
• Identifying geographic and pricing trends
• Visualizing relationships between boroughs, listing types, and nightly rates
• Producing recommendations for hosts, investors, and regulators

Features

• Data Cleaning & Preparation — Addressed missing values, duplicates, and inconsistent entries to ensure reliable analysis.
• Exploratory Data Analysis (EDA) — Examined listing distribution, pricing trends, and host behavior using Tableau.
• Tableau Dashboard — Interactive visualization summarizing Airbnb market dynamics.
• Data Documentation — Comprehensive written report explaining methods, assumptions, and findings.
• Video Presentation — Overview of results and visualization walkthrough.

Project Structure

├── Data/
│   ├── AirbnbNewYorkData.xlsx
│   ├── AirbnbNewYorkDataCleaned.csv
│   └── AirbnbNewYorkDataOriginal.csv
├── Docs/
│   ├── AirbnbNewYorkReport.docx
│   └── AirbnbNewYorkReport.pdf
├── Images/
│   └── AirbnbLogo.png
├── .gitattributes
├── AirbnbNewYork.twbx
├── LICENSE
├── Presentation.MOV
├── README.md

Data Source

• Dataset: Airbnb Open Data – New York City (2008–2022)

Technologies Used

• Data Cleaning: Microsoft Excel
• Visualization: Tableau (.twbx workbook)
• Documentation: Microsoft Word / PDF
• Presentation: Video walkthrough (.MOV)

License

This project is licensed under the MIT License.