EXL Service Analyst Interview Questions and Answers

Retrieve the top 3 salaries from each department using SQL with ranking functions.

• Use the ROW_NUMBER() function to assign a unique rank to each salary within its department.

• Partition the results by department to ensure ranking is done within each department.

• Filter the results to include only the top 3 salaries per department using a common table expression (CTE) or subquery.

I have extensive experience in data analysis, project management, and stakeholder communication across various industries.

• Worked as a data analyst at XYZ Corp, improving data reporting efficiency by 30%.

• Led a project team to analyze customer feedback, resulting in a 15% increase in customer satisfaction.

• Utilized SQL and Python for data extraction and analysis, enhancing decision-making processes.

• Collaborated with ...read more

The annual demand for selling books to IITK students through e-commerce depends on various factors such as the number of students, their course curriculum, and their reading habits.

• The demand can be estimated by conducting a survey among the students to understand their reading habits and preferences.

• The demand can also be influenced by the availability of books in the campus library and bookstores.

• The demand may ...read more

Calculating the probability of two friends playing badminton in the same week given certain probabilities.

• Calculate the probability of both playing in the first week (a*a)

• Calculate the probability of both playing in the second week ((1-a)*b*(1-c))

• Calculate the probability of both playing in the third week ((1-a)*(1-b)*c)

• Calculate the probability of both playing in the last week ((1-a-b-c)*(1-a-b-c))

• Add up all the ...read more

I have a strong analytical background with experience in data analysis, problem-solving, and project management across various industries.

• Bachelor's degree in Statistics, where I developed a solid foundation in data analysis techniques.

• Interned at XYZ Corp, analyzing sales data to identify trends, which led to a 15% increase in revenue.

• Worked as a data analyst at ABC Inc., where I utilized SQL and Python to stream...read more

It is difficult to estimate the exact number of kgs of paneer used in Bangalore everyday without specific data.

• Estimate based on population size and consumption habits

• Consider the number of restaurants, hotels, and households in Bangalore

• Look at the average consumption of paneer per person in Bangalore