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 for Experienced
Willis Towers Watson Data Analyst Interview Experiences for Experienced
1 interview 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
Top trending discussions
Interview questions from similar companies
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%';
- 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
Skills evaluated in this interview
I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.
Interview Preparation Tips
- Procurement
- Marketing
- Career goal
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
(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
Selected
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me about yourself
- Q2. Expected salary
Interview Questionnaire
1 Question
- Q1. Tell me about yourself
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. SQL, Power Bi, Python, Azure
Interview Preparation Tips
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
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 Company Website and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. SQL, python, Tableau
Interview Preparation Tips
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 Senior Advisor Interview Questions
- Willis Towers Watson Actuarial Analyst Interview Questions
- Willis Towers Watson Senior Analyst Interview Questions
- Willis Towers Watson Process Associate Interview Questions
- Willis Towers Watson Trainee Interview Questions
- Willis Towers Watson Senior Associate Interview Questions
- Willis Towers Watson Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Willis Towers Watson Data Analyst Interview Process for Experienced
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 5 reviews
Rating in categories
|
Senior Advisor
1.2k
salaries
|  ₹2 L/yr - ₹9.8 L/yr |
|
Advisor
684
salaries
| ₹2 L/yr - ₹5.8 L/yr |
|
Analyst
446
salaries
| ₹3.9 L/yr - ₹14.9 L/yr |
|
Senior Associate
422
salaries
| ₹3 L/yr - ₹9.5 L/yr |
|
Senior Analyst
317
salaries
| ₹7 L/yr - ₹27 L/yr |
Deloitte
Ernst & Young
PwC
KPMG India
- Home >
- Interviews >
- Willis Towers Watson Interview Questions >
- Willis Towers Watson Data Analyst Interview Questions for Experienced
