10+ Willis Towers Watson Data Analyst Interview Questions & Answers | Complete Prep Guide 2025

Willis Towers Watson Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

Anonymous

posted on 26 Feb 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

No response

I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR

(3 Questions)

Q1. Basics of power bi and sql

Add your answer

Q2. What are joins and types of join

Ans.

Joins are used to combine rows from two or more tables based on a related column between them.

Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FULL JOIN...

Answered by AI

Add your answer

Q3. How to add date table in power bi

Ans.

To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.

Create a new table in Power BI with a list of dates
Add columns for day, month, year, etc. for additional analysis
Establish relationships between the date table and other tables in the data model

Answered by AI

Add your answer

Round 2 - Technical

(4 Questions)

Q1. Sql scenario based question on joins

Add your answer

Q2. Window function questions

Add your answer

Q3. Performance tuning

Add your answer

Q4. Power bi dax question

Add your answer

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Anonymous

posted on 11 Jun 2022

I applied via Company Website and was interviewed in Dec 2021. There were 11 interview rounds.

Round 1 - Aptitude Test

A test designed to a determination a person ability in particular skill of field knowledge

Round 2 - Coding Test

Coding and decoding

Round 3 - Case Study

Devolpment of a particular person group or situation over a period of time

Round 4 - Technical

(1 Question)

Q1. Relating to a particular Subject art or carft or its techNical Terms

Add your answer

Round 5 - Group Discussion

Is a situation faced when individuals collectively make a choice from alternative before them

Round 6 - Assignment

A task or piEce of work allocated to someone a part of a job or course of study a home work assignment

Round 7 - Technical

(1 Question)

Q1. InvolVoing or concerned with applied and industrial science

Add your answer

Round 8 - Coding Test

Coding interview test candidate technical knowledge coding ability creativity typically on a white board

Round 9 - HR

(1 Question)

Q1. Managing an organisation employees

Add your answer

Round 10 - One-on-one

(1 Question)

Q1. Each player from one team is matched a single player from other team

Add your answer

Round 11 - Coding Test

The from are checked and returned to the census officer for coding

Interview Preparation Tips

Interview preparation tips for other job seekers - Straight From the job Seekers themselves

Top trending discussions

View All

Interview Tips & Stories

I have been shortlisted for an interview at Bloomberg for the investment / real estate reporter role. How can I prepare for the interview? What all do I need to keep in mind for my prep? Please help, I am very nervous! Thank you

Got a question about Willis Towers Watson?

Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Marsh McLennan

Anonymous

posted on 9 Oct 2023

Interview experience

Excellent

Difficulty level

Process Duration

Result

Round 1 - Resume Shortlist

Pro Tip by AmbitionBox:

Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.

View all Resume tips

Round 2 - Technical

(1 Question)

Q1. How would you analyze data using python

Ans.

Data analysis in Python involves importing data, cleaning and preprocessing, performing statistical analysis, and visualizing results.

Import data using libraries like pandas
Clean and preprocess data by handling missing values and outliers
Perform statistical analysis using libraries like numpy and scipy
Visualize results using libraries like matplotlib and seaborn

Answered by AI

Add your answer

Round 3 - HR

(1 Question)

Q1. Why would you want to join our organisation

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Answer to point

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Mercer

Anonymous

posted on 14 Feb 2024

Interview experience

Average

Difficulty level

Easy

Process Duration

Result

Selected

Round 1 - HR

(1 Question)

Q1. How good are you with numbers

Add your answer

Round 2 - Technical

(1 Question)

Q1. Vlookup, pivot table, sumif, average, graphs

Add your answer

Round 3 - Behavioral

(1 Question)

Q1. Do you know the role and responsibility of this position

Add your answer

Data Analyst Interview Questions & Answers

Deloitte

Anonymous

posted on 24 Jan 2022

I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test

Round 2 - Resume Shortlist

Pro Tip by AmbitionBox:

Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.

View all Resume tips

Interview Preparation Tips

Topics to prepare for Deloitte Data Analyst interview:

Procurement
Marketing
Career goal

Interview preparation tips for other job seekers - Location should be Delhi NCR,Monday would be good

Data Analyst Interview Questions & Answers

Ernst & Young

Anonymous

posted on 11 Oct 2020

I applied via Walk-in and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire

2 Questions

Q1. Cut Cake in 3 cut to maximum pieces

Add your answer

Q2. Basic SQL queries

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident even you don’t have experience in the relevant skill set.

You can be absorbed to much related profile of your interests.

They only check how better you represent yourself and your problem solving approach.

Data Analyst Interview Questions & Answers

PwC

Anonymous

posted on 15 Oct 2021

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire

2 Questions

Q1. Write a query where all the customer name start with A

Ans.

Query to retrieve all customer names starting with A.

Use the SELECT statement to retrieve customer names.
Use the LIKE operator with the pattern 'A%' to match names starting with A.
Specify the table and column name where the customer names are stored.
Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

Answered by AI

View 1 more answer

Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was extremely easy and smooth.

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

PwC

Anonymous

posted on 18 Sep 2021

Interview Questionnaire

1 Question

Q1. SQL, Power Bi, Python, Azure

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the Job Description properly. Clear you basics and prepare according to the JD

Data Analyst Interview Questions & Answers

Ernst & Young

Anonymous

posted on 25 Jun 2022

I applied via Campus Placement and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - Technical

(1 Question)

Q1. Questions on SQL, C++

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL, Python and ETL well along with great communication skills.

Data Analyst Interview Questions & Answers

Aon

Anonymous

posted on 8 Nov 2024

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - Coding Test

Sql coding questions were asked.

Round 2 - Assignment

Assignment on questions they provided.

Willis Towers Watson Interview FAQs

How many rounds are there in Willis Towers Watson Data Analyst interview?

Willis Towers Watson interview process usually has 6-7 rounds. The most common rounds in the Willis Towers Watson interview process are Technical, Coding Test and HR.

How to prepare for Willis Towers Watson Data Analyst interview?

Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Willis Towers Watson. The most common topics and skills that interviewers at Willis Towers Watson expect are Data Analysis, CRM, Data Modeling, ETL and SQL.

What are the top questions asked in Willis Towers Watson Data Analyst interview?

Some of the top questions asked at the Willis Towers Watson Data Analyst interview -

What are joins and types of j...read more
How to add date table in power...read more
Relating to a particular Subject art or carft or its techNical Te...read more

Tell us how to improve this page.

Willis Towers Watson Interviews By Designations

Interview Questions for Popular Designations

Willis Towers Watson Data Analyst Interview Process

based on 1 interview

Interview experience

Good

Deloitte Data Analyst Interview Questions

3.8

• 42 Interviews

PwC Data Analyst Interview Questions

3.4

• 15 Interviews

ZS Data Analyst Interview Questions

3.4

• 14 Interviews

Ernst & Young Data Analyst Interview Questions

3.4

• 11 Interviews

KPMG India Data Analyst Interview Questions

3.5

• 10 Interviews

BCG Data Analyst Interview Questions

3.7

• 5 Interviews

The Smart Cube Data Analyst Interview Questions

3.6

• 5 Interviews

Gallagher Data Analyst Interview Questions

3.7

• 4 Interviews

Aon Data Analyst Interview Questions

3.8

• 3 Interviews

Mercer Data Analyst Interview Questions

3.7

• 2 Interviews

View all

DG Ruparel College of Arts Science & Commerce, Mumbai Placement Questions

1 Interview

Mulund College of Commerce, Mumbai Placement Questions

1 Interview

View all

Willis Towers Watson Data Analyst Salary

based on 28 salaries

₹2.7 L/yr - ₹9.3 L/yr

9% less than the average Data Analyst Salary in India

View more details

Willis Towers Watson Salaries in India

Senior Advisor 1.2k salaries	₹0 L/yr - ₹0 L/yr
Advisor 677 salaries	₹0 L/yr - ₹0 L/yr
Analyst 451 salaries	₹0 L/yr - ₹0 L/yr
Senior Associate 441 salaries	₹0 L/yr - ₹0 L/yr
Senior Analyst 361 salaries	₹0 L/yr - ₹0 L/yr