Airbnb Data Warehouse Schema - Data Engineering Mock Interview

Join the waitlist for Exponent’s Data Engineering Interview Course: bit.ly/3BwDBpw
In this video, we dive into data modeling for Airbnb, focusing on building a star schema model for analytical purposes. The discussion covers capturing metrics such as customer satisfaction and business profitability through key fact tables like Booking, Revenue, and Review, while exploring important dimensions such as user, listing, and location to optimize Airbnb’s operational insights.
Want to practice peer-to-peer mock interviews? bit.ly/3Xmj8wq
Chapters -
Watch other mock interviews from Exponent:
Netflix Clickstream Data Pipeline: • Data Engineering Inter...
Probability, P-value and Confidence Intercals: • Probability, P-Value a...
Retry Transaction ft. Paypal Data Scientist: • Stripe Data Science Mo...
Amazon Data Science Interview: Linear Regression: • Amazon Data Science In...
👉 Subscribe to our channel: bit.ly/exponentyt
🕊️ Follow us on Twitter: bit.ly/exptweet
💙 Like us on Facebook for special discounts: bit.ly/exponentfb
📷 Check us out on Instagram: bit.ly/exponentig
📹 Watch us on TikTok: bit.ly/exponen...
ABOUT US:
Did you enjoy this interview question and answer? Want to land your dream career? Exponent is an online community, course, and coaching platform to help you ace your upcoming interview. Exponent has helped people land their dream careers at companies like Google, Microsoft, Amazon, and high-growth startups. Exponent is currently licensed by Stanford, Yale, UW, and others.
Our courses include interview lessons, questions, and complete answers with video walkthroughs. Access hours of real interview videos, where we analyze what went right or wrong, and our 1000+ community of expert coaches and industry professionals, to help you get your dream job and more!

[@karthikmat12]

great video! a question - wondering what are the pros/cons of a separate revenue_fact table. It basically just has three extra columns (payment method, currency and payment date) when compared to booking_fact. Maybe it makes more sense to combine both revenue and booking fact table? curious to hear any thoughts about this. Thanks!

[@vbatth]

Everyone's burning question: Tool is SmartDraw

[@testleadz015]

Excellent

[@hamzaehsankhan]

Why put attributes in the fact table?
For instance, shouldn't booking_status have a separate dim?
It is not an additive measure. It is an attribute no?

[@rishiraj2548]

Thanks

[@ATHARVA89]

What is the toolname used for modelling?

[@keithsweatshop]

Great question!

[@satkarjain6401]

what is the tool used here to draw ER ?

[@tryexponent]

It's called "SmartDraw"!

[@nwangwuuchechi7867]

What is the name of the tool used here?

[@tryexponent]

Hey nwangwuuchechi7867, the tool is called SmartDraw!