EXL Service Senior Data Analyst Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a Senior Data Analyst with 5+ years of experience in analyzing complex data sets and providing actionable insights.
• 5+ years of experience in data analysis

• Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• Strong problem-solving skills and ability to communicate findings to non-technical stakeholders
Answered by AI
Add your answer
Q2. Asked about recent project
Add your answer
Q3. Types of join in sql
Ans. 
Types of join in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the 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: Returns ro
Answered by AI
Add your answer
Q4. Case when statement questions
Add your answer

SQL knowledge is must.
Any visualisation tool is preferred.
Python basic required.

Q1. Concepts of SQL Optimisation techniques CTE
Add your answer

On Machine learning and aptitude

Case study to assess our analytical skills

Q1. Sql questions — very rarely asked questions.. was very tough
Add your answer