EXL Service Senior Data Analyst Interview Questions and Answers

Q1. Can you elaborate on your work experience?
Ans. 
I have 5 years of experience in analyzing large datasets to extract valuable insights and make data-driven decisions.
• Analyzed customer behavior data to optimize marketing strategies

• Built predictive models to forecast sales trends

• Utilized machine learning algorithms to improve product recommendations

• Presented findings to stakeholders in a clear and actionable manner
Answered by AI
Add your answer
Q2. What questions were asked regarding your work experience?
Ans. 
Questions related to work experience in data science field.
• Asked about previous projects worked on

• Inquired about specific data analysis techniques used

• Discussed challenges faced and how they were overcome
Answered by AI
Add your answer

Q1. Sum and sumif, date functions, text join, pivot tables
Add your answer

DSA and ML, AI, Coding question

Q1. Case study which was easy
Add your answer

Q1. In depth questions on ML
Add your answer

1 hr exam it is easy to crack

Sql, python, Statistics mcq, Aptitude test. These were medium level questions.

Q1. SQL and python, time complexity
Add your answer
Q2. Make 2 lists a=[1,2,3,4] b=[9,8,5,5,2,3,3,4,1,1,10,9,2,3,4,10,10,9,7,7,8] Write a program to remove duplicate of b and keep only those elements of b which are not present in a, and the final list should ...read more
Ans. 
Remove duplicates from list b, keep elements not in list a, and sort in ascending order.
• Create a set from list b to remove duplicates

• Use list comprehension to keep elements not in list a

• Sort the final list in ascending order
Answered by AI
View 1 more answer
Q3. SQL question Remove duplicate from a table tab1
Ans. 
Use the DISTINCT keyword in SQL to remove duplicates from a table.
• Use the SELECT DISTINCT statement to retrieve unique rows from the table.

• Identify the columns that should be used to determine uniqueness.

• Example: SELECT DISTINCT column1, column2 FROM tab1;
Answered by AI
View 1 more answer

Given 2 case studies on data science and asked different possibilities to improve the models.

How to work with imbalance dataset.
How to remove null values, what is features engineering.
What is PCA
What is the working of XGBOOST

Q1. What was last project, tell me in detail. There were different technical questions related to my project
Add your answer