Top 24
Prep plan
Updated weekly · Last refresh Sep 9

JOHN LEONARD Data Analyst Interview Questions

The questions to prepare for a JOHN LEONARD Data Analyst interview. Questions from real interview reports rank first. Updated daily.

24questions
~3htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 3 drills · ~102 min
Joining Strings and IntegersMedium

Tests practical SQL skills for type handling and data preparation in join operations.

sqlJOHN LEONARD
Solving an Unclear SQL ProblemHard

Tests your ability to drive clarity and solve ambiguous SQL problems.

ClarityJOHN LEONARD
Handling Missing ValuesMedium
Recently asked

Tests statistical and practical approaches to missing data without distorting analysis.

missing valuesdata cleaningdata integrityJOHN LEONARD
Choosing the Right VisualizationMedium
Recently asked

Tests judgment in selecting visualizations that match the data and the decision context.

Data Analysistechnical skillsdata visualizationJOHN LEONARD
Cleaning Messy DatasetsMedium
Recently asked

Tests practical data cleaning methods and attention to edge cases and quality.

data cleaningtechnical skillsdata integrityJOHN LEONARD
Professional Python and SQLMedium
Recently asked

Tests hands-on proficiency with core data languages used to analyze and transform data.

sqltechnical experiencepythonJOHN LEONARD
SQL and Tableau UsageMedium
Practice
Practice drill

Summarize each analyst's SQL activity and Tableau asset usage with joins, aggregations, and CASE classification.

analytics toolsexperienceJoinsDatadog
Top 5 Users Per CategoryMedium
Practice
Practice drill

Identify the five most active users in each category using aggregation and row numbering.

JoinsRankingData AnalysisAArete
SQL for Search Filters Leading to No ResultsMedium
Practice
Practice drill

Rank the three most common Airbnb search filter combinations associated with zero-result sessions.

null handlingJoinsData AnalysisAirbnb
More SQL & Data Manipulation 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
2
Behavioral & Leadership15 questions · ~120 min
Data Visualization Tools OverviewMedium

Assesses breadth of visualization tooling and ability to communicate quickly and clearly.

experiencedata visualizationJOHN LEONARD
Experience With Analytical ToolsMedium

Assesses your hands-on experience with tools used for analytics and reporting.

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