Dataford
Top 25
Prep plan
Updated weekly · Last refresh Sep 10

LexisNexis Legal & Professional Data Analyst Interview Questions

The questions to prepare for a LexisNexis Legal & Professional Data Analyst interview. Questions from real interview reports rank first. Updated daily.

25questions
~3htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 3 drills · ~110 min
Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByLexisNexis Legal & Professional
Apply Performance TuningMedium

Assesses your approach to identifying bottlenecks and improving query and pipeline performance.

Performance TuningLexisNexis Legal & Professional
Tableau RelationshipsMedium

Assesses your knowledge of Tableau data modeling concepts and how they affect analysis.

data relationshipsLexisNexis Legal & Professional
Window Functions for Top UsersMedium
Practice
Practice drill

Use aggregation and ROW_NUMBER to find the top three Lexis+ users by total session duration within each region.

Window FunctionsData AnalysissqlLexisNexis Legal & ProfessionalAmazon Lab126Andela Products
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
SQL Query OptimizationMedium
Practice
Practice drill

Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.

Performance Tuningdatabase optimizationindexesDDroisysCapgeminiNomura
More SQL & Data Manipulation questions with a free account
2
Pipelines6 questions · ~48 min
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityLexisNexis Legal & Professional
Star Schema DesignMedium

Evaluates your dimensional modeling understanding and ability to implement it for analytics.

star schemaData ModelingLexisNexis Legal & Professional
ETL Insert, Truncate, UpdateMedium

Tests your practical experience with data loading strategies and their impact on correctness.

ETLLexisNexis Legal & Professional
More Pipelines 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
Behavioral & Leadership8 questions · ~64 min
Responding to Model FeedbackEasy

Tests how you handle direct feedback on analytical work, especially your openness, rigor, and ability to improve the model and your process.

resiliencefeedbackanalytical modelsLexisNexis Legal & Professional
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~8 min
Choosing Visualizations for StakeholdersMedium

Tests product sense and communication skills by matching visuals to audience needs and decision goals.

stakeholder communicationLexisNexis Legal & Professional
The finish line: interview-readyComplete all 25 questions plus 3 hands-on drills to finish this plan.