🏡 Airbnb Prices in European Cities

📌 Project Overview

Understanding the key factors influencing Airbnb prices across different European cities.
Business Case:
As an Airbnb host, I want to identify property characteristics that influence price, as well as the most favorable cities for hosting so that I can select suitable properties for purchase and rental.

📂 Data Sources

🔗 Concatenation of 20 datasets
📍 Columns: city, day type, etc.

📊 Data Analysis & Preprocessing

• 🔍 EDA & Bivariate Analysis: Removing outliers, scatterplots, correlation heatmap
• 🤖 Machine Learning Model Selection: Predicting price, determining best ML model

📈 Visualization & Dashboard

🖥️ Tableau Interactive Dashboard

• Filters by column values
• KPIs: Avg, Max, Min Prices
• 🗺️ Price Map: Based on geographic coordinates

🏗️ Database Design & Transformation

• Entity-Relational Model
• Handling data inconsistencies

📌 SQL Insights & Advanced Analysis

• 📊 Standout insights from SQL queries
• 🔎 Key analytical challenges

🎯 Key Findings

✅ Major Visualizations & Insights
✅ Summary of findings based on visualizations

💡 Conclusions & Business Implications

• ✅ Reflection on initial hypotheses
• 🏡 Implications for Airbnb hosts

📂 Resources & References

• 📊 Dataset Source: Airbnb Prices in European Cities
• 📑 Presentation Slides: Project Insights & Findings