Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Willis Towers Watson Team. If you also belong to the team, you can get access from here

Willis Towers Watson Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Willis Towers Watson Data Analyst Interview Questions and Answers

Updated 26 Feb 2024

Willis Towers Watson Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 26 Feb 2024

Interview experience
4
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
  • 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
  • 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
Round 2 - Technical 

(4 Questions)

  • Q1. Sql scenario based question on joins
  • Q2. Window function questions
  • Q3. Performance tuning
  • Q4. Power bi dax question

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image 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
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
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
Round 10 - One-on-one 

(1 Question)

  • Q1. Each player from one team is matched a single player from other team
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

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

Interview experience
5
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
Round 3 - HR 

(1 Question)

  • Q1. Why would you want to join our organisation

Interview Preparation Tips

Interview preparation tips for other job seekers - Answer to point

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. How good are you with numbers
Round 2 - Technical 

(1 Question)

  • Q1. Vlookup, pivot table, sumif, average, graphs
Round 3 - Behavioral 

(1 Question)

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

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

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
  • Q2. Basic SQL queries

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.

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

Interview Preparation Tips

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

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. SQL, Power Bi, Python, Azure

Interview Preparation Tips

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

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++

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL, Python and ETL well along with great communication skills.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Sql coding questions were asked.

Round 2 - Assignment 

Assignment on questions they provided.

Contribute & help others!
anonymous
You can choose to be anonymous

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 -

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

Recently Viewed

REVIEWS

McKinsey & Company

No Reviews

REVIEWS

McKinsey & Company

No Reviews

REVIEWS

Willis Towers Watson

No Reviews

REVIEWS

ESAF Small Finance Bank

No Reviews

INTERVIEWS

The Smart Cube

No Interviews

INTERVIEWS

The Smart Cube

No Interviews

INTERVIEWS

Willis Towers Watson

No Interviews

INTERVIEWS

The Smart Cube

10 top interview questions

JOBS

McKinsey & Company

No Jobs

REVIEWS

McKinsey & Company

No Reviews

Tell us how to improve this page.

Willis Towers Watson Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Data Analyst Interview Questions from Similar Companies

ZS Data Analyst Interview Questions
3.4
 • 14 Interviews
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 Data Analyst Reviews and Ratings

based on 4 reviews

2.9/5

Rating in categories

2.5

Skill development

2.5

Work-life balance

2.5

Salary

2.9

Job security

2.9

Company culture

2.5

Promotions

2.5

Work satisfaction

Explore 4 Reviews and Ratings
Senior Advisor
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Advisor
677 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
451 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
441 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
361 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Willis Towers Watson with

Marsh McLennan

4.0
Compare

Aon

3.8
Compare

Mercer

3.7
Compare

Gallagher

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview