#analytics

6 analytics interview questions, asked at Airbnb, Apple, Microsoft and 2 more companies. Last asked Sep 2026.

Model cumulative booking metrics and first and last booking timesSystem designA data engineering round: design the tables and pipeline that report cumulative booking metrics over time, along with each user's (or listing's) first and last booking time. Cover…
Last asked Sep 2026
Design trackable product links that reward every Nth visitorSystem designCompanies create and edit product pages with images and descriptions, generate unique links to share on social media, and see each link's reach and engagement. The platform also…
Last asked Aug 2026
Design an A/B testing platformSystem designDesign a platform that lets teams run A/B tests: define an experiment, assign users to variants consistently, log exposures and events, and compute results with confidence…
Last asked Apr 2026
Design view counting for product pagesSystem designDesign the backend for product pages on a large shopping site that records how many times each product is viewed. Cover taking in view events at high volume, counting them…
Last asked Apr 2026
Design an event analytics platformSystem designDesign the platform that collects product events from the app and makes them available for analysis. Cover how events are captured and ingested, how they land in the warehouse or…
Last asked Apr 2026
Design data pipelines for a short-video appSystem designDesign the data engineering behind a large short-video app: collecting events from clients, streaming and batch processing, the warehouse and data models that analysts and…
Last asked Jan 2026