⬅️ Back to home
🌟 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