EXL Service Data Analyst Interview Questions, Process, and Tips

Q1. About data science basics
Add your answer
Q2. About sql and basic question like 2nd highest salary
Ans. Use sub query to get only two records and then reverse it and limit to 1 record output
Answered Anonymously
Add your answer
Q3. Python code for factorial
Ans. 
Python code to calculate factorial of a number.
• Use a loop to iterate from 1 to the given number.

• Multiply each number with the previous result.

• Return the final result.
Answered by AI
View 1 more answer
Q4. What is recursion, list, and few more basic questions
Add your answer

Some random case study related to fraud analytics , like how to prevent fraud in bank. If u know certain places show high fraud numbers getting reported, wht will you do to prevent.
Answer: confirm if there is really fraud going on or some tech glitch. If yes report . Do deep dive analysis.
Find areas where high fraud frequency is found. Find its located to certain machines or shops ( if its localized ) or distributed over various shops or channels like atm, bank ,shop card swiping etc.
Once analysed either out these sources on hold until further investigation is complete.

Q1. This was basically salary Negotiation
Add your answer

Q1. Python string is changable or not
Ans. 
Python strings are immutable, meaning they cannot be changed once created.
• Python strings are immutable, so any operation that appears to modify a string actually creates a new string object.

• For example, when you use string concatenation or slicing, a new string is created instead of modifying the original string.

• To modify a string in Python, you would need to create a new string with the desired changes.
Answered by AI
Add your answer
Q2. Sql window function ?
Add your answer
Q3. Difference between having and where cause
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY clause to filter the groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after the GROUP BY clause, WHERE is applied before

• HAVING can only be used with SELECT statement that contains a GROUP BY clause

• Example: SELECT department, AVG(salary) FROM employees GROUP BY depar...read more
Answered by AI
Add your answer
Q4. Sql union and union all
Add your answer
Q5. Python using remove duplicate value
Ans. 
Use Python's set() function to remove duplicate values from an array of strings.
• Convert the array to a set to automatically remove duplicates

• Convert the set back to a list if needed
Answered by AI
Add your answer

Relation between 2 persons , probability, statistics etc

Q1. Convolition neural networks
Add your answer
Q2. Architecture of gans
Ans. 
Generative Adversarial Networks (GANs) are a type of deep learning model that consists of two neural networks, the generator and the discriminator, which are trained simultaneously.
• GANs consist of two neural networks - the generator and the discriminator.

• The generator creates new data instances, while the discriminator evaluates them.

• The two networks are trained in a competitive manner, where the generator tries to foo...read more
Answered by AI
Add your answer

Q1. There is table which holds details of matches played between the countries in first 2 columns and who won the match in 3rd column. write a query to get no. of matches played by each team and no. of matche...read more
Ans. 
Query to get number of matches played and won by each team from a table of match details.
• Use GROUP BY clause to group the data by team name.

• Use COUNT() function to get the number of matches played by each team.

• Use SUM() function with a condition to get the number of matches won by each team.
Answered by AI
Add your answer