Top 49
Prep plan
Updated weekly · Last refresh Aug 30

WNS Data Analyst Interview Questions

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

49questions
~7htotal time
Track your progressSign up free to work through all 49 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 15 questions + 1 drill · ~137 min
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingWNS
Monthly Sales Aggregation by Product CategoryEasy
Practice

Aggregate monthly sales totals by product category using JOINs, GROUP BY, and date formatting.

WNS
Explain SQL Join TypesEasy

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

JoinsData WranglingGroup ByWNS
Second Highest Without AggregatesHard
Practice
Recently asked
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
More SQL & Data Manipulation questions with a free account
2
Statistics & Probability5 questions · ~42 min
Machine Learning FundamentalsMedium

Tests core ML concepts needed to interpret models and apply them responsibly.

RegressionCorrelationCausal InferenceWNS
Basic Linear Regression in PythonMedium

Tests understanding of regression modeling workflow and core implementation steps in Python.

RegressionCorrelationCausal InferenceWNS
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
Metrics5 questions · ~42 min
Cars Through a RoundaboutMedium

Tests estimation and metrics reasoning for real-world data problems with limited information.

Funnel AnalysisLeading IndicatorsDiagnosisWNS
Choose the Right Business MetricMedium

Tests metric selection, alignment to business goals, and understanding of measurement tradeoffs.

North Star MetricKPIsDiagnosisWNS
More Metrics questions with a free account
4
Behavioral & Leadership23 questions · ~195 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~8 min
Cars Count EstimationMedium

Evaluates your guesstimation approach and assumptions for a real-world business question.

EstimationProblem SolvingWNS
The finish line: interview-readyComplete all 49 questions plus 1 hands-on drill to finish this plan.