Top 31
Prep plan
Updated weekly · Last refresh Oct 17

CarGurus Business Analyst Interview Questions

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

31questions
~4htotal time
Track your progressSign up free to work through all 31 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~25 min
Diagnose Databricks Engagement DropMedium

Diagnose a 17% drop in Databricks weekly engaged users by decomposing DAU/WAU, retention, sessions, and instrumentation changes.

Leading IndicatorsDiagnosisEngagement MetricsCarGurus
Metrics for Improving RetentionMedium

Tests your ability to diagnose retention drivers and choose actionable metrics.

RetentionKPIDiagnosisCarGurus
More Metrics questions with a free account
2
SQL & Data Manipulation5 questions + 2 drills · ~62 min
SQL for User RetentionMedium
Practice

Measure monthly user retention by signup cohort using date calculations and aggregated activity.

Window FunctionsDate FunctionsCTEsCarGurus
Complex SQL Query WalkthroughMedium

Tests your SQL proficiency and your ability to translate business questions into queries.

Window FunctionsJoinsAggregationsCarGurus
Top Reps by Monthly RevenueMedium
Practice
Practice drill

Rank CarGurus sales representatives by monthly closed-sale revenue and return every representative tied for first place.

Window FunctionsDate FunctionsRankingCarGurus
Rolling Three-Month Average QueryMedium
Practice
Practice drill

Calculate monthly sales and regional rolling three-month averages in Teradata Vantage using aggregation and window functions.

Window FunctionssqlAggregationsTeradataCarGurusThe Hartford
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership19 questions · ~159 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~34 min
Incorporate User Feedback EffectivelyEasy

Approach for turning user feedback into product decisions without overreacting to isolated requests.

User ResearchFeature PrioritizationPain PointsCarGurus
End-to-End Data-Driven ProjectMedium

Tests your ability to frame problems, define requirements, and deliver measurable outcomes.

Success CriteriaRoadmappingScope ManagementCarGurus
Estimating Market SizeHard

Tests your strategy and quantitative reasoning for sizing opportunities and validating assumptions.

EstimationTAM/SAM/SOMMarket SizingCarGurus
Diagnosing Platform IssuesMedium

Assesses your product sense for identifying likely issues and framing next diagnostic steps.

user experienceCarGurus

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 31 questions plus 2 hands-on drills to finish this plan.