Top 38
Prep plan
Updated weekly · Last refresh Aug 30

Merck KGaA Business Analyst Interview Questions

The questions to prepare for a Merck KGaA Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

38questions
~5htotal time
Track your progressSign up free to work through all 38 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 9 questions · ~72 min
Write User Stories and Acceptance CriteriaMedium

Explain the structure you use for user stories and how you define acceptance criteria that align stakeholders and control scope.

Feature PrioritizationSuccess CriteriaUser NeedsMerck KGaA
Your Strengths and WeaknessesEasy

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

Trade-offsSuccess CriteriaRisk AssessmentMerck KGaA
Define Success Criteria for InitiativeMedium

Define clear success criteria for a new engineering initiative before stakeholders drift toward conflicting definitions of success.

Trade-offsSuccess CriteriaRoadmappingMerck KGaA
More Execution questions with a free account
2
Metrics3 questions · ~24 min
Using Dashboards to Read KPIsEasy

Explain how visualization tools help analysts track KPIs, spot patterns, and support decisions.

KPIsData WranglingDiagnosisMerck KGaA
Ensuring Data QualityMedium

Tests your methods for validating, cleaning, and maintaining trustworthy data in analytics.

Lagging IndicatorsLeading IndicatorsDiagnosisMerck KGaA
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
SQL & Data Manipulation6 questions + 3 drills · ~78 min
Python for Data ManipulationMedium

Tests your hands-on experience using Python to transform and prepare data for analysis.

SubqueriesData WranglingCTEsMerck KGaA
SQL Query for Data ExtractionEasy

Tests your SQL proficiency for retrieving and shaping data for analysis.

JoinsGroup ByAggregationsMerck KGaA
Tools for Data AnalysisEasy

Tests your practical toolkit for analyzing data and communicating results.

Data WranglingAggregationsMerck KGaA
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
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
Unify CRM and Google Analytics ViewHard
Practice
Practice drill

Merge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.

SubqueriesJoinsData WranglingArtefact
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership20 questions · ~160 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 38 questions plus 3 hands-on drills to finish this plan.