Dataford
Dataford
Top 18
Prep plan
Updated weekly · Last refresh Oct 17

Zulily Business Analyst Interview Questions

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

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
Excel Formulas for Unstandardized DataEasy

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

SubqueriesJoinsData WranglingZulily
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
Top Warehouse Bottleneck IdentificationMedium
Practice
Practice drill

Use PostgreSQL joins, aggregation, and ranking to identify active warehouse stations with high queue time and low throughput.

null handlingJoinsperformanceZulily
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
24-Hour Email Conversion RateMedium
Practice
Practice drill

Calculate unique-user email conversion within 24 hours using joins, date arithmetic, and aggregation.

Date FunctionsJoinsConversion RateZulily
2
Behavioral & Leadership11 questions · ~88 min
Resolving a Critical Data AnomalyMedium

Tests ownership of data quality issues, root-cause analysis, and clear stakeholder communication under pressure.

Problem SolvingOwnershipdata anomalyZulily
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
Improving Zulily ProfitHard

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

Zulily
Analyze Vendor Shortfall ImpactHard

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

Launch PlanningTrade-offsRisk AssessmentZulily
Framework for Free Shipping DecisionHard

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

Strategic PlanningCost-Benefit AnalysisPricing StrategyZulily

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.