EXL Service Senior Consultant Interview Questions, Process, and Tips

Q1. Rank vs dense rank
Ans. 
Rank assigns unique ranks to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.
• Rank function is used to assign a unique rank to each distinct row based on the specified column(s).

• Dense rank function is used to assign consecutive ranks to rows with the same values, without any gaps.

• For example, if we have scores of 90, 85, 85, 80, then rank would assign ranks as 1, 2, 2, 4 while
Answered by AI
Add your answer
Q2. Row level security
Add your answer

Q1. How to get the last row of any SAS dataset
Ans. 
Use the OBS option in a SET statement to read the last observation of a SAS dataset.
• Use the OBS option in a SET statement followed by the keyword 'END' to read the last observation of a SAS dataset.

• For example, to read the last observation of a dataset named 'mydata', use the following code: data lastobs; set mydata(obs=last end=last); run;
Answered by AI
Add your answer

Q1. KPI's for CLI and CLD
Ans. 
Key Performance Indicators (KPIs) for Customer Lifetime Income (CLI) and Customer Lifetime Duration (CLD)
• CLI KPIs could include average revenue per customer, customer retention rate, customer lifetime value

• CLD KPIs could include average customer lifespan, customer churn rate, customer engagement metrics

• Tracking CLI and CLD KPIs can help measure the financial impact and longevity of customer relationships
Answered by AI
Add your answer
Q2. Credit score variables and impact on strategy
Ans. 
Credit score variables impact strategy by influencing lending decisions and interest rates.
• Credit score variables include payment history, credit utilization, length of credit history, types of credit used, and new credit accounts.

• Higher credit scores typically result in lower interest rates and more favorable lending terms.

• Lenders use credit scores to assess risk and determine the likelihood of repayment.

• Strategies ma...read more
Answered by AI
Add your answer

Q1. Questions related to my work experience
Add your answer
Q2. A case study on how to improve sales using website analytics management and email marketing
Add your answer

Q1. Questions about past projects
Add your answer
Q2. Case on use of analytics in a retail sector. How would you as a consultant, structure the whole process (as the job was for an assistant project manager)
Add your answer

Basic SQL join and Python data wrangling questions.

Q1. Metrics that can be useful in a defined dataset.
Ans. 
Metrics such as mean, median, mode, standard deviation, and range can be useful in analyzing a defined dataset.
• Mean: average value of the dataset

• Median: middle value of the dataset when arranged in ascending order

• Mode: most frequently occurring value in the dataset

• Standard deviation: measure of the amount of variation or dispersion of a set of values

• Range: the difference between the maximum and minimum values in the da
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer