Top 20
Prep plan
Updated weekly · Last refresh Aug 30

The Johns Hopkins University Data Analyst Interview Questions

The questions to prepare for a The Johns Hopkins University Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 12 questions + 2 drills · ~123 min
Validate Power BI Revenue Before PublishHard
Practice

Reconcile a Power BI revenue KPI to source-of-truth payments using joins, aggregations, and window functions.

Data WranglingThe Johns Hopkins University
Explaining a Complex SQL AnalysisMedium

Explain a medium-complexity SQL query using CTEs, joins, aggregations, and CASE logic while tying it to a business problem.

business problemcomplex queriessqlThe Johns Hopkins University
Validating Data Before ReportingEasy

Explain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.

JoinsData WranglingQualityThe Johns Hopkins University
Spotting and Fixing Data Quality IssuesMedium

Tests attention to detail, root-cause analysis, and corrective actions for data quality.

Data Qualitydata cleaningdata validationThe Johns Hopkins University
Find Duplicate Records in SQLEasy
Practice
Practice drill

Use GROUP BY and HAVING to find duplicate patient records in a Johns Hopkins Medicine dataset.

Data WranglingGroup ByHavingEmersonAmazon DSPCareDx
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
Statistics & Probability6 questions · ~52 min
Administrative Claims Data WorkMedium

Tests ability to analyze high-volume healthcare administrative data and handle its quirks.

data cleaningdata validationThe Johns Hopkins University
Predictive Model ValidationHard

Tests end-to-end modeling skills including validation strategy and performance assessment.

RegressionHypothesis TestingStatistical SignificanceThe Johns Hopkins University
Exploratory Data Analysis ApproachEasy

Tests structured EDA thinking to uncover patterns, anomalies, and data quality issues.

RegressionCorrelationData WranglingThe Johns Hopkins University
More Statistics & Probability 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
More topics2 questions · ~17 min
End-to-End Healthcare AnalyticsMedium

Evaluates your ability to deliver healthcare analytics and clearly explain modeling choices.

project experienceThe Johns Hopkins University
More questions with a free account
The finish line: interview-readyComplete all 20 questions plus 2 hands-on drills to finish this plan.