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

DICK'S Sporting Goods Data Analyst Interview Questions

The questions to prepare for a DICK'S Sporting Goods Data 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
SQL & Data ManipulationStart here. 11 questions + 1 drill · ~106 min
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice

Calculate the monthly spending trends for customers using window functions and joins.

DICK'S Sporting Goods
Top Three Selling Products SQLMedium
Practice

Rank completed product sales within each DICK'S region using joins, aggregation, and ROW_NUMBER().

JoinsRankingAggregationsDICK'S Sporting Goods
Top-N Products With Window FunctionsEasy
Practice
Practice drill

Find DICK'S top three products by units sold during the last 30 calendar days using filtering and aggregation.

Window FunctionsDate FunctionsRankingDICK'S Sporting Goods
More SQL & Data Manipulation questions with a free account
2
Metrics10 questions · ~87 min
Compare CAC Against LTVMedium

Calculate CAC and compare it with LTV to decide whether an acquisition campaign is economically viable.

CACcampaign viabilityLTVDICK'S Sporting Goods
Prioritize KPIs for a DashboardEasy

Choose a focused KPI set for a new dashboard by tying metrics to product value, business goals, and leading versus lagging signals.

KPIsLeading IndicatorsDiagnosisDICK'S Sporting Goods
More Metrics questions with a free account

Sign up to see every question

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

Get my prep plan
3
Statistics & Probability11 questions · ~96 min
Sample Size for A/B TestsEasy

Choose sample size and runtime by combining baseline rate, MDE, alpha, power, and expected traffic.

Power AnalysisSample SizeA/B TestingDICK'S Sporting Goods
Testing a Conversion Rate DropMedium

Explain how to test whether an observed 5% conversion rate drop is statistically significant in an experiment or before-after comparison.

Hypothesis TestingData AnalysisStatistical SignificanceDICK'S Sporting Goods
More Statistics & Probability questions with a free account
4
Pipelines10 questions · ~87 min
Backfilling Missing Pipeline DataMedium

Approach for safely backfilling missing data while preserving correctness, idempotency, and data quality.

ETLQualityDICK'S Sporting Goods
More Pipelines questions with a free account
5
Product Sense5 questions · ~44 min
Assess Product User Need FitEasy

Framework for determining whether a product is truly solving meaningful user needs, not just generating surface-level usage.

Jobs to Be DoneUser ResearchUser NeedsDICK'S Sporting Goods
More Product Sense questions with a free account
6
Behavioral & Leadership3 questions · ~26 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 1 hands-on drill to finish this plan.