Top 50
Prep plan
Updated weekly · Last refresh Oct 17

KAYAK Business Analyst Interview Questions

The questions to prepare for a KAYAK Business Analyst interview. Questions from real interview reports rank first. Updated daily.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
StrategyStart here. 8 questions · ~65 min
2
Metrics9 questions · ~73 min
Diagnose Ride Booking Funnel DropMedium

Diagnose why ride bookings fell by breaking the booking funnel into conversion steps and isolating the failing stage.

Funnel AnalysisConversion RateDiagnosisKAYAK
Measure Process Change ImpactMedium

Define whether a process change improved team performance using leading and lagging metrics.

KPIsLeading IndicatorsDiagnosisKAYAK
More Metrics questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Statistics & Probability8 questions · ~65 min
Sample Size for Feature ExperimentHard

Estimate required sample size for an A/B test on a new feature using power analysis for a two-proportion test.

Power AnalysisSample SizeA/B TestingKAYAK
More Statistics & Probability questions with a free account
4
Execution9 questions · ~73 min
Explain Complex Analysis ClearlyEasy

Describe how you translated a complex analysis into a clear explanation for a non-technical audience and drove understanding.

Trade-offsSuccess CriteriaRisk AssessmentKAYAK
More Execution questions with a free account
5
SQL & Data Manipulation8 questions + 3 drills · ~95 min
JOIN and GROUP BY Query DesignEasy

Explain how to structure a SQL query with JOINs and GROUP BY to answer business questions with aggregated results.

JoinsGroup ByAggregationsKAYAK
Analyzing Large Behavioral DatasetsEasy

Explain how to analyze a complex dataset in SQL, including cleaning, aggregation, trend analysis, and communicating results.

JoinsData WranglingAggregationsKAYAK
Handling Missing DataEasy
Practice
Practice drill

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handlingUniversity of MinnesotaThe Home DepotNationwide
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymoCruise
Re-activate Lapsed CustomersMedium
Practice
Practice drill

Use a customer purchase aggregation to find previously active Repsol customers with no completed purchase in the last 30 days.

Window FunctionsDate FunctionsJoinsRepsol
More SQL & Data Manipulation questions with a free account
6
Product Sense6 questions · ~48 min
Assess Product Market FitMedium

Evaluate whether a product has true product market fit before increasing spend.

Product-Market FitUser ResearchValue PropositionKAYAK
More Product Sense questions with a free account
7
More topics2 questions · ~16 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.