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 Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.
Interview Preparation Tips
- Procurement
- Marketing
- Career goal
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.
Interview Questionnaire
1 Question
- Q1. SQL, Power Bi, Python, Azure
Interview Preparation Tips
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 Campus Placement and was interviewed before Jun 2021. There was 1 interview round.
(1 Question)
- Q1. Questions on SQL, C++
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 2 interview rounds.
Aptitude have some basic questions that many of us can solve easily not that much difficult.
(2 Questions)
- Q1. Nothing much just simple questions about normal calculations, your Introduction, Be Frank keep smile and be confident.
- Q2. They also checked your communication skills, grammar skills or some times they assign you to write formal letter or e-mails which could be pretty difficult sometimes be prepared for to that too.
Interview Preparation Tips
I don't know if they do hiring directly.
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
Proficient in SQL, Python, and data visualization tools like Tableau
Strong analytical and problem-solving skills
Experience in data cleaning, data mining, and statistical analysis
Ability to communicate findings effectively to both technical and non-technical stakeholders
- Q2. Mostly behavior question from resume
General puzzle, and related to your resume
Interview Preparation Tips
Sql coding questions were asked.
Assignment on questions they provided.
Selected
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
Basic aptitude test like distance problem , age etc
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 4 reviews
Rating in categories
|
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 |
Marsh McLennan
Aon
Mercer
Gallagher
- Home >
- Interviews >
- Willis Towers Watson Interview Questions >
- Willis Towers Watson Data Analyst Interview Questions for Experienced
