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

DICK'S Sporting Goods Business Analyst Interview Questions

The questions to prepare for a DICK'S Sporting Goods Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 6 questions · ~48 min
Handling Pressure During Critical DeliveryEasy

Explain how you handled a high-pressure work situation with competing demands, clear prioritization, and effective stakeholder management.

Trade-offsRisk AssessmentScope ManagementDICK'S Sporting Goods
Balancing Scope Quality and TimelineMedium

Describe a real example of choosing between scope, quality, and timeline while aligning stakeholders under delivery pressure.

Trade-offsRisk AssessmentScope ManagementDICK'S Sporting Goods
More Execution questions with a free account
2
Behavioral & Leadership3 questions · ~24 min
More Behavioral & Leadership questions with a free account
3
More topics6 questions · ~48 min
Build a Marketing KPI DashboardMedium

Design a dashboard that connects campaign activity, funnel conversion, and acquisition efficiency to business outcomes.

North Star MetricKPIsLeading IndicatorsDICK'S Sporting Goods
Use User Feedback to Improve ProductMedium

Tell the story of using user feedback to identify the right product change and make the improvement.

User ResearchFeature PrioritizationUser NeedsDICK'S Sporting Goods
Motivation for DICK'SEasy

Tests alignment with the role and motivation for joining DICK'S Sporting Goods.

Competitive AnalysisValue PropositionGrowth StrategyDICK'S Sporting Goods
Top Retail Locations QueryMedium

Tests SQL skills for deriving insights from retail performance and year-over-year trends.

Date FunctionsRankingAggregationsDICK'S Sporting Goods
Designing an Omni DashboardMedium

Tests metrics design, dashboard thinking, and translating strategy into measurable KPIs.

KPIsLeading IndicatorsDiagnosisDICK'S Sporting Goods
Brick-and-Mortar ChallengeMedium

Tests strategic thinking and the ability to connect data to real retail problems.

EstimationCompetitive AnalysisGrowth StrategyDICK'S Sporting Goods

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Top Three Selling Products SQLMedium
Practice
Practice drill

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
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice
Practice drill

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

The Home DepotAvisoWorld Wide Technology
The finish line: interview-readyComplete all 15 questions plus 3 hands-on drills to finish this plan.