Top 22
Prep plan
Updated weekly · Last refresh Oct 17

Johns Hopkins University Data Analyst Interview Questions

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

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 3 drills · ~102 min
Quality Check Process for Large DatasetsMedium

Explain how to validate a large dataset using SQL with joins, aggregations, CTEs, and null handling.

Data Qualitylarge datasetsdata validationJohns Hopkins University
Handling Missing Data in SQLEasy

Explain practical SQL techniques for handling NULLs and missing values in product analysis without biasing metrics.

Data WranglingCase WhenAggregationsJohns Hopkins University
Analytical Models You UseMedium

Evaluates your modeling choices and your ability to justify them for analytical problems.

Data Analysisanalytical modelstechnical proficiencyJohns Hopkins University
Ensuring Data QualityMedium

Evaluates your methods for maintaining reliable, trustworthy data for research analysis.

Data Qualitydata integrityJohns Hopkins University
Validating Research DataMedium

Evaluates your validation practices to support accurate, reproducible research outcomes.

Accuracydata validationJohns Hopkins University
Cleaning Data for AnalysisMedium

Tests your data preparation approach for reliable marketing analytics.

data preparationdata cleaningtechnical skillsJohns Hopkins University
Data Cleaning and PrepMedium
Practice
Practice drill

Prepare valid encounter records by trimming text, excluding missing values, and removing invalid charges.

missing valuesdata cleaningData WranglingMassachusetts General HospitalCognizantDataVisor
Cleaning Messy DatasetsHard
Practice
Practice drill

Clean, standardize, deduplicate, and validate NHS appointment records before analysis.

analytical skillsdata preparationdata cleaningIIndustry-Leading National Security ConsultancyNHS
Handle Inconsistent Formatting Across SourcesMedium
Practice
Practice drill

Clean inconsistent names, regions, and currency values from a single source-records table.

data cleaningData Wranglinginconsistent dataWorld Wide Technology
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership12 questions · ~96 min
Fixing a Broken Planning ProcessMedium

Tests ownership and initiative in improving an inefficient process, with emphasis on root-cause analysis, influence, and measurable operational impact.

process improvementinitiativeOwnershipJohns Hopkins University
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 22 questions plus 3 hands-on drills to finish this plan.