AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Willis Towers Watson
Compare
Filter interviews by
Willis Towers Watson Data Analyst Interview Questions and Answers
Willis Towers Watson Data Analyst Interview Experiences
2 interviews found
Anonymous
I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.
(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...
- 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
(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
I applied via Company Website and was interviewed in Dec 2021. There were 11 interview rounds.
A test designed to a determination a person ability in particular skill of field knowledge
Coding and decoding
Devolpment of a particular person group or situation over a period of time
(1 Question)
- Q1. Relating to a particular Subject art or carft or its techNical Terms
Is a situation faced when individuals collectively make a choice from alternative before them
A task or piEce of work allocated to someone a part of a job or course of study a home work assignment
(1 Question)
- Q1. InvolVoing or concerned with applied and industrial science
Coding interview test candidate technical knowledge coding ability creativity typically on a white board
(1 Question)
- Q1. Managing an organisation employees
(1 Question)
- Q1. Each player from one team is matched a single player from other team
The from are checked and returned to the census officer for coding
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
tejas jain
I applied via Newspaper Ad and was interviewed in Aug 2024. There were 3 interview rounds.
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
(2 Questions)
- Q1. What is DSA , sorting , difference between array and linked list
- Ans.
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
DSA stands for Data Structures and Algorithms
Sorting is the process of arranging data in a particular order
Arra...
- Q2. Written a SQL query
(2 Questions)
- Q1. Coding question like add numbers
- Q2. Experience on your project
- Ans.
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
Developed predictive models to forecast customer behavior and optimize marketing strategies
Conducted market research to identify trends and opportunities for growth
Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Skills evaluated in this interview
(2 Questions)
- Q1. Power BI Difference between ALL() and ALLSELECTED()
- Ans.
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
ALL() removes all filters from the specified column or table.
ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.
Example: ALL('Table') would remove all filters on the 'Table' in the query context.
Example: ALLSELECTED('Column') would remove filte...
- Q2. Excel Difference between COUNT() and COUNTA()
- Ans.
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
COUNT() counts only cells with numerical values.
COUNTA() counts all non-empty cells, including text and errors.
Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
(2 Questions)
- Q1. Resume based questions like explain the projects that you have done.
- Q2. Sample dataset questions
Skills evaluated in this interview
priyam Gawade
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Graduated with a degree in Statistics
Proficient in programming languages like Python and R
Experience in analyzing large datasets and creating data visualizations
Strong problem-solving skills
- Q2. Why should we hire you
- Ans.
I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.
I have a degree in Data Science and extensive experience in analyzing complex datasets.
I am proficient in programming languages such as Python, R, and SQL, as well as data visualization tools like Tableau.
I have successfully completed projects where I identified trends, patterns, and outl...
(2 Questions)
- Q1. What is use of excel in this data field
- Ans.
Excel is a powerful tool for data analysis, visualization, and reporting in the field of data analytics.
Excel can be used for data cleaning and manipulation before analysis
It allows for easy organization and sorting of large datasets
Excel's pivot tables and charts help in visualizing data trends and patterns
Functions like VLOOKUP and SUMIF can be used for data analysis
Excel can be used for creating reports and dashboar
- Q2. Difference between vlookup & hlookup
- Ans.
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column. HLOOKUP does the same but horizontally.
VLOOKUP stands for vertical lookup, while HLOOKUP stands for horizontal lookup.
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
HLOOKUP searches for a value in the first row of a table and re...
Chaithra Anil
(2 Questions)
- Q1. First screening was aptitude test
- Q2. Discuss technical skills
(1 Question)
- Q1. The interview was pretty simple.
Selected
(1 Question)
- Q1. How good are you with numbers
(1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs
(1 Question)
- Q1. Do you know the role and responsibility of this position
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.
Basic aptitude questions liek tiem distance, percentage , ratio, work and hour
Excel, Numpy, Pandas, basic ML
Case study talking about how to optimise the supply chain using data analytics
(1 Question)
- Q1. Hard DP level DSA question
Selected
I applied via Company Website and was interviewed in May 2024. There were 2 interview rounds.
Easy to crack, case study
(1 Question)
- Q1. SQL queries were asked
Willis Towers Watson Interview FAQs
Tell us how to improve this page.
Willis Towers Watson Interviews By Designations
- Willis Towers Watson Advisor Interview Questions
- Willis Towers Watson Actuarial Analyst Interview Questions
- Willis Towers Watson Senior Advisor Interview Questions
- Willis Towers Watson Process Associate Interview Questions
- Willis Towers Watson Senior Analyst Interview Questions
- Willis Towers Watson Trainee Interview Questions
- Willis Towers Watson Analyst Interview Questions
- Willis Towers Watson Associate Interview Questions
- Show more
Willis Towers Watson Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Willis Towers Watson Data Analyst Reviews and Ratings
based on 4 reviews
Rating in categories
|
Senior Advisor
1.3k
salaries
|  ₹2.5 L/yr - ₹9.9 L/yr |
|
Advisor
668
salaries
| ₹2 L/yr - ₹5.2 L/yr |
|
Analyst
506
salaries
| ₹3.9 L/yr - ₹14.1 L/yr |
|
Senior Associate
449
salaries
| ₹3 L/yr - ₹9.5 L/yr |
|
Senior Analyst
364
salaries
| ₹7 L/yr - ₹27.1 L/yr |
Marsh McLennan
Aon
Mercer
Gallagher
- Home >
- Interviews >
- Willis Towers Watson Interview Questions >
- Willis Towers Watson Data Analyst Interview Questions
