Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Chewy Business Analyst Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 15 questions · ~121 min
Diagnose Conversion Drop Post LaunchMedium

Diagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.

Funnel AnalysisConversion RateDiagnosisChewy
Using Dashboards to Read KPIsEasy

Explain how visualization tools help analysts track KPIs, spot patterns, and support decisions.

KPIsData WranglingDiagnosisChewy
More Metrics questions with a free account
2
Execution7 questions · ~57 min
3
SQL & Data Manipulation11 questions + 3 drills · ~119 min
Reconciling Conflicting Report MetricsHard

Explain how to reconcile conflicting report totals using joins, aggregations, CTEs, and validation logic.

JoinsData WranglingQualityChewy
Validate Dashboard Metrics with SQLEasy

Explain how to validate dashboard metrics by reconciling source data with SQL aggregations and grouped checks.

JoinsData WranglingAggregationsChewy
Active Subscription Revenue by CustomerEasy
Practice
Practice drill

Join customers, subscriptions, and products to list active subscriptions with next shipment date and product revenue.

JoinsData WranglingAggregationsChewy
Top Brands by StateMedium
Practice
Practice drill

Rank Chewy's top three pet food brands in each state by units sold during the last 30 days.

Window FunctionsJoinsAggregationsChewy
Revenue by Product CategoryEasy
Practice
Practice drill

Calculate Chewy order revenue for the previous quarter using joins, date filtering, and category aggregation.

JoinsGroup ByAggregationsChewy
More SQL & Data Manipulation questions with a free account
4
Statistics & Probability3 questions · ~24 min
Correlation vs Causation in AnalysisEasy

Explain why two metrics moving together does not prove that one causes the other, and how to assess causality more carefully.

RegressionCorrelationCausal InferenceChewy
More Statistics & Probability questions with a free account
5
Product Sense3 questions · ~24 min
Why Chewy and Simple SolutionMedium

Assesses your motivation for Chewy and your ability to simplify complex analysis for stakeholders.

User NeedsProblem SolvingChewy
More Product Sense questions with a free account
6
Behavioral & Leadership9 questions · ~73 min
More Behavioral & Leadership questions with a free account
7
More topics2 questions · ~16 min
Estimate U.S. Pet Supplies Market SizeMedium

Tests your ability to build a structured market sizing approach with reasonable assumptions.

EstimationTAM/SAM/SOMMarket SizingChewy
More questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.