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

Eli Lilly and Business Analyst Interview Questions

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

40questions
~6htotal time
Track your progressSign up free to work through all 40 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~62 min
Active Customer List by CityEasy
Practice

Retrieve active customers from a single table, grouped by city with a customer count and sorted by highest count.

JoinsData WranglingAggregationsEli Lilly and
Inner Join vs Outer JoinEasy

Tests your SQL join knowledge and ability to reason about result sets.

JoinsData WranglingEli Lilly and
Window Functions SQL QueryMedium
Practice
Practice drill

Rank Eli Lilly products by regional completed prescription revenue using aggregation, joins, a CTE, and RANK().

Window FunctionsRankingRunning TotalsEli Lilly and
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
2
Metrics3 questions · ~25 min
Critical Metrics for Product LaunchMedium

Choose the most important launch metrics, balancing early signals, long-term outcomes, and a clear KPI hierarchy.

KPIsConversion RateLeading IndicatorsEli Lilly and
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
Execution5 questions · ~42 min
Your Strengths and WeaknessesEasy

Tests self-awareness and how you position yourself for success in an Account Executive role at Aqr.

Trade-offsSuccess CriteriaRisk AssessmentEli Lilly and
More Execution questions with a free account
4
Behavioral & Leadership23 questions · ~191 min
More Behavioral & Leadership questions with a free account
5
More topics4 questions · ~33 min
Find Pain Points from FeedbackMedium

Use customer feedback to identify the biggest pain points in the user journey.

User ResearchUser NeedsPain PointsEli Lilly and
Evaluate New Market AttractivenessHard

Assess whether a new market is worth entering by weighing size, competition, economics, and strategic fit.

Competitive AnalysisSWOTMarket SizingEli Lilly and
Deep Learning Algorithm ExplanationHard

Evaluates your technical understanding of deep learning concepts and mechanisms.

Deep LearningAlgorithmsEli Lilly and
Pharma Case Study AnalysisHard

Tests your strategy and analytical rigor for pharma business decisions.

EstimationCompetitive AnalysisMarket SizingEli Lilly and
The finish line: interview-readyComplete all 40 questions plus 2 hands-on drills to finish this plan.