KAYAK Business Analyst Interview Questions
The questions to prepare for a KAYAK Business Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how to analyze a complex dataset in SQL, including cleaning, aggregation, trend analysis, and communicating results.
KAYAKExplain how you used SQL aggregations and simple trend analysis to help a customer make a business decision.
KAYAKRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Replit
QuantcastCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Approach for estimating the impact of a product change before launch.
KAYAKDefine whether a process change improved team performance using leading and lagging metrics.
KAYAKDiagnose why ride bookings fell by breaking the booking funnel into conversion steps and isolating the failing stage.
KAYAKEstimate required sample size for an A/B test on a new feature using power analysis for a two-proportion test.
KAYAKEvaluate whether a product has true product market fit before increasing spend.
KAYAK