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.