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

McKesson Business Intelligence Analyst Interview Questions

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

13questions
~2htotal time
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 3 drills · ~70 min
Explaining Visualization Tool ExperienceEasy

Explain how you use SQL analysis to build dashboards, choose visuals, and communicate insights to stakeholders.

ToolsData WranglingMcKesson
Walking Through a Complex SQL QueryMedium

Assesses your SQL reasoning, debugging skills, and ability to translate business needs into queries.

sql queryMcKesson
BI Tools and PlatformsMedium

Evaluates your practical experience across core BI and data platforms used for analytics delivery.

sqlpower biMcKesson
Ensuring Data QualityMedium

Tests your data quality controls, validation practices, and trust-building with stakeholders.

Data QualityAccuracyMcKesson
Looker BI Tool ExperienceMedium

Evaluates your hands-on ability to build, model, and deliver analytics using Looker.

bi toolsMcKesson
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
SQL Data Quality ChecksHard
Practice
Practice drill

Detect missing fields, duplicate transaction keys, invalid amounts, and merchant reference issues with PostgreSQL CTEs and joins.

Data Qualitynull handlingdata integritySigmoid
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore

Sign up to see every question

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

Get my prep plan
2
Behavioral & Leadership8 questions · ~64 min
Explaining Data Issues to StakeholdersMedium

Tests whether you can translate complex trends or data quality issues into clear business language and drive stakeholder alignment.

Data QualityStakeholder ManagementCommunicationMcKesson
Aligning Competing Stakeholder PrioritiesMedium

Tests stakeholder management under pressure, especially prioritization, influence without authority, and clear communication.

Stakeholder ManagementCommunicationDealing With AmbiguityMcKesson
Implementing a Team Efficiency ProcessEasy

Tests leadership through process change, ownership of team effectiveness, prioritization, and communication during adoption.

CommunicationLeadershipOwnershipMcKesson
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 13 questions plus 3 hands-on drills to finish this plan.