Dataford
Top 18
Prep plan
Updated weekly · Last refresh Aug 30

Zulily Business Analyst Interview Questions

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

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 3 drills · ~54 min
Clean Inventory with Nested IF and VLOOKUPMedium

Tests ability to use Excel logic and lookups to clean and reconcile inventory data.

null handlingData WranglingperformanceZulily
Pivot Vendor Performance by QuarterMedium

Tests ability to build dynamic Excel pivots for vendor performance reporting across changing fiscal periods.

Date FunctionsPivotAggregationsZulily
Excel Formulas for Unstandardized DataEasy

Tests practical Excel skills for merging messy data from different sources.

SubqueriesJoinsData WranglingZulily
Monthly Sales Summary by CategoryEasy
Practice
Practice drill

Aggregate January 2024 completed transactions by category using WHERE, GROUP BY, and SUM in PostgreSQL.

Data WranglingGroup ByAggregationsZulilyAbercrombie and FitchWalgreens
Compare Monthly User Retention CohortsMedium
Practice
Practice drill

Calculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.

Window FunctionsDate FunctionsAggregationsTrideumZulilyeBay
Compare Department Spend to BudgetMedium
Practice
Practice drill

Compare actual department spend against budget using joins, aggregation, and variance calculations.

JoinsGroup ByAggregationsRipplingZulily
2
Behavioral & Leadership11 questions · ~88 min
Contradicting Senior Stakeholder IntuitionMedium

Tests influence without authority when data conflicts with senior judgment, including stakeholder management and clear communication.

Conflict ResolutionStakeholder ManagementAnalysisZulily
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~32 min
Diagnose Rising Customer Acquisition CostsMedium

Diagnose why CAC doubled over three quarters by separating channel efficiency, funnel changes, customer mix, and measurement effects.

CACLeading IndicatorsDiagnosisZulily
Framework for Free Shipping DecisionHard

Tests strategic thinking and decision frameworks using customer, cost, and business impact considerations.

Strategic PlanningCost-Benefit AnalysisPricing StrategyZulily
Analyze Vendor Shortfall ImpactHard

Tests analytical impact assessment and actionable recommendations for merchandising during time-sensitive events.

Launch PlanningTrade-offsRisk AssessmentZulily
Improving Zulily ProfitHard

Evaluates your ability to propose actionable, revenue and cost-focused initiatives for Zulily.

Zulily

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 18 questions plus 3 hands-on drills to finish this plan.