Top 18
Prep plan
Updated weekly · Last refresh Oct 17

Nationwide Data Analyst Interview Questions

The questions to prepare for a Nationwide Data 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
A/B Testing & ExperimentationStart here. 3 questions · ~25 min
Marketing Campaign A/B Test DesignMedium

Design a marketing campaign experiment with a pre-registered metric plan, power calculation, and ship rule that respects guardrails.

ExperimentationHypothesis TestingA/B TestingNationwide
Determining Sample Size for SignificanceMedium

Tests your understanding of statistical power, variance, and experiment design tradeoffs.

Statistical SignificancePower AnalysisSample SizeNationwide
Recommendations for Marginal A/B ResultsMedium

Tests your ability to interpret experiment results and advise stakeholders on next steps.

Decision Makingincremental liftStatistical SignificanceNationwide
2
SQL & Data Manipulation4 questions + 3 drills · ~63 min
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByNationwide
Rolling 30-Day Spending ThresholdHard

Tests your skills in SQL-based aggregation and rolling window logic for behavioral insights.

Date FunctionsRunning TotalsAggregationsNationwide
WHERE vs HAVING in SQLMedium

Tests your understanding of SQL filtering at the row versus group level.

sqlNationwide
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
Rolling 7-Day Average QueryMedium
Practice
Practice drill

Calculate Deliveroo's daily order volume and rolling 7-day average using a date spine, aggregation, and window functions.

sql queryKoch Minerals & TradingDeliverooLLSEG (London Stock Exchange Group)
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership10 questions · ~82 min
Cross-Functional Teamwork in DesignEasy

Tests how you collaborate across functions in a design context, communicate clearly, and take ownership for team outcomes.

Stakeholder ManagementCommunicationLeadershipNationwide
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~8 min
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.