Airbnb data interview guide
Two-sided marketplace metrics — hosts, guests, bookings and rankings.
typical interview loop
- 1.Recruiter screen
- 2.Technical screen: 2–3 SQL questions in a shared editor (~45 min)
- 3.Onsite: SQL / Python coding, product-sense metrics case, behavioral
- › Ranking within groups (ROW_NUMBER / DENSE_RANK) is a staple.
- › Think about both sides of the marketplace.
most-tested topics
Window functions
2
groupby
2
agg
2
JOIN
2
GROUP BY
2
WHERE
1
Based on 8 reconstructed Airbnb-style questions.
practice path
1 free · 7 Pro- 1Filter active listings by citysqlEasy
- 2Highest rated listing per citysqlHard
- 3Host listing summarypandasMedium
- 4Maximum booking overlappythonHard
- 5Nightly price bucketspythonEasy
- 6Occupancy revenue per hostpandasMedium
- 7Revenue per citysqlMedium
- 8Top-rated listing per citysqlMedium
Unlock all 8 Airbnb questions with Pro.
upgrade