Top 22
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

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
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
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
Healthcare Analytics TermsMedium

Evaluates your ability to communicate healthcare analytics concepts accurately.

project experienceJohns 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
Cleaning Data for AnalysisMedium

Tests your data preparation approach for reliable marketing analytics.

data preparationdata cleaningtechnical skillsJohns Hopkins University
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
Flag Invalid Dashboard Revenue RowsEasy
Practice
Practice drill

Use GROUP BY and conditional aggregation to count data quality issues in a single NVIDIA dashboard source table.

Data WranglingCase WhenAggregationsNVIDIA
Clean Duplicate Transactions and Null CostsMedium
Practice
Practice drill

Deduplicate transactions and impute null costs before reporting customer spend.

Data WranglingCase WhenAggregationsApptio
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership12 questions · ~96 min
Explaining a Technical Concept ClearlyEasy

Tests communication, ownership, and stakeholder management when translating technical complexity into actionable business understanding.

Problem SolvingData Structurestechnical fundamentalsJohns 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.