Airbnb-Europe Repository

Welcome to Airbnb-Europe – a project focused on analyzing Airbnb data from Europe using SQL and Tableau. This repository contains all the materials for the project, including the SQL analysis script, data files, and Tableau dashboard.

---

📋 Project Overview

This project analyzes a Airbnb dataset for Europe, originally sourced from Kaggle: Airbnb Cleaned Europe Dataset.

Key Features:

• SQL Analysis:
  The Airbnb.sql file contains queries and data manipulation routines to analyze various aspects of the dataset. The Airbnb upd.sql file contains more queries and data manipulation routines to analyze various aspects of the dataset.

• Tableau Dashboard:
  Explore insights visually with the Tableau dashboard file:

  • Airbnb Europe.twb (Tableau Workbook)
  • Airbnb Dashboard.pdf (Dashboard Snapshot)

• Data Files:
  The dataset is available in two formats:

  • Airbnb-Europe-Dataset.csv
  • Airbnb-dataset.json

---

🔍 Data & Analysis

• Data Source:
  The data was taken from Kaggle and is hosted in two variations (CSV and JSON).
• SQL Analysis:
  The SQL file includes queries to filter, aggregate, and derive insights about the Airbnb listings across Europe.
• Visualization:
  The Tableau dashboard provides interactive and static visualizations, offering insights into listing distribution, pricing, availability, and other key metrics.

---

🚀 How to Run

1. Clone the Repository:

   git clone https://github.com/Sabdikay/Airbnb-Europe.git
   cd Airbnb-Europe

2. Explore the SQL Analysis:

   • Open Airbnb.sql in your preferred SQL editor (e.g., MySQL Workbench, Navicat) to run and modify queries.

3. View the Data:

   • The dataset is available as Airbnb-Europe-Dataset.csv and Airbnb-dataset.json.

4. Dashboard Exploration:

   • Open the Tableau Workbook file Airbnb Europe.twb in Tableau Desktop.
   • Alternatively, view the snapshot in the PDF file Airbnb Dashboard.pdf.

---

💡 Key Insights

• Listing Trends:
  Discover patterns in pricing, occupancy rates, and distribution of Airbnb listings across major European cities.
• Market Analysis:
  Analyze seasonal trends, demand variations, and other market dynamics.
• Data-Driven Decisions:
  Leverage the SQL queries and Tableau visualizations to extract actionable insights for potential investments and market strategies.

---

📌 Repository Structure

Airbnb-Europe/
├── Airbnb.sql                  # SQL analysis script
├── Airbnb upd.sql              # SQL analysis script
├── Airbnb-Europe-Dataset.csv   # Dataset in CSV format
├── Airbnb-dataset.json         # Dataset in JSON format
├── Airbnb Europe.twb           # Tableau Workbook for dashboard
├── Airbnb Dashboard.pdf        # PDF snapshot of the dashboard
└── README.md                   # This README file

---

Dashboard:

---

🤝 Contributing

Contributions, issues, and feature requests are welcome! Feel free to check issues page if you want to contribute.

---

📜 License

This project is licensed under the MIT License.

---

📫 Get in Touch

For any questions or collaboration opportunities, please reach out via email or connect with me on LinkedIn.

---

Enjoy exploring the Airbnb data and uncovering insights about Europe's vibrant short-term rental market!
🚀📊✨