🌟 Project 2: Airbnb Paris – Rental Performance Analysis

🥉 Context and Objectives

This project was part of a storytelling data workshop. The goal was to identify the factors influencing rental performance on Airbnb Paris by analyzing availability, pricing, property types, and quality indicators (ratings, response times…).

📊 Data Used

2 tables:

listings: 1 row per listing with static information (type, score, response time…)
calendar: 1 row per day and per listing with price and availability

Data analyzed in BigQuery and visualized with Looker Studio
Timeframe: full year in Paris

🛠️ Technical Skills Used

SQL joins between listings and calendar
Aggregations per listing (occupancy rate, average price…)
Creation of key metrics (occupancy rate, potential revenue)
Dynamic visual representations in Looker Studio (charts, maps, annotations)
Analytical storytelling focused on business insights

🧪 Analytical Approach

Data exploration in BigQuery
Joining tables on listing_id to combine static and dynamic data
Creation of per-listing metrics:

Occupancy rate (% of days booked)
Average nightly price
Average score and host response time

Correlation analysis between rental performance and those indicators
Building a Looker Studio dashboard to visually narrate the findings

📊 Key Insights

“Entire home” listings have higher occupancy than “private rooms”
Occupancy rate is strongly correlated with fast host response time
Listings rated above 9/10 have a potential revenue 30% higher than the average
Higher prices do not necessarily reduce booking rate if rating and location are good

🔗 Interactive Dashboard: View the report

💡 Recommendations

Train hosts to improve responsiveness to increase booking chances
Adjust pricing dynamically during low seasons
Highlight guest reviews and ratings to boost listing visibility

🎓 What I Learned

Effectively joining and combining multiple data sources in BigQuery
Exploring simple yet relevant correlations from partial data
Telling a clear business story through visuals in Looker Studio
Working in pairs on a concrete analytical problem and presenting it orally