EXL Service Interview Questions, Process, and Tips

Q1. Tools used in Business Intelligence
Ans. 
Business Intelligence tools help in analyzing and visualizing data to make informed decisions.
• Power BI

• Tableau

• QlikView

• MicroStrategy

• SAP BusinessObjects
Answered by AI
Add your answer
Q2. SQL Experience
Add your answer

Q1. Second highest salary by department in SQL
Ans. 
Use SQL query with window function to find second highest salary by department
• Use ROW_NUMBER() function to assign a unique rank to each salary within a department

• Filter the results to only include rows where the rank is 2

• Join the results with the department table to get the department name
Answered by AI
Add your answer
Q2. Power BI DAX questions on using RANK function
Add your answer

Q1. Specifics of the project
Add your answer
Q2. Matching experience
Add your answer

60 mins, general aptitude questions (time bound)

Q1. Linear regression, Logistic Regression, Aptitude
Add your answer
Q2. Explain linear regression, like i am a newbie
Ans. 
Linear regression is a statistical method used to model the relationship between a dependent variable and one or more independent variables.
• Linear regression is used to predict the value of a dependent variable based on the value of one or more independent variables.

• It assumes a linear relationship between the independent and dependent variables.

• The goal of linear regression is to find the best-fitting line that repres...read more
Answered by AI
Add your answer

Q1. What is the biggest challenge you faced in your prev role ?
Ans. 
Managing a team with diverse personalities and work styles.
• Balancing the needs and preferences of team members.

• Resolving conflicts and misunderstandings among team members.

• Motivating and engaging team members to work towards common goals.
Answered by AI
Add your answer

Q1. What is P2P process?
Ans. 
P2P process stands for Procure-to-Pay process, which involves the steps from requisitioning goods/services to making payment.
• P2P process starts with creating a purchase requisition for goods/services needed by a department.

• The next step is to obtain approval for the requisition from the appropriate authority.

• Once approved, a purchase order is created and sent to the vendor.

• Goods/services are received and the invoice is...read more
Answered by AI
Add your answer
Q2. What is AP process?
Ans. 
AP process refers to the procedures and systems used by a company to manage and pay its invoices and bills.
• Involves receiving invoices from vendors

• Verifying the accuracy of the invoices

• Obtaining approval for payment

• Processing payments to vendors

• Reconciling accounts payable to ensure accuracy

• Maintaining records of all transactions
Answered by AI
Add your answer

Q1. What is p2p cycle
Ans. 
P2P cycle refers to the Procure-to-Pay cycle, which is the process of obtaining goods or services from a supplier to making payment for them.
• P2P cycle starts with the procurement of goods or services

• It involves receiving and approving invoices from suppliers

• Payment is made to the supplier for the goods or services received

• The cycle ends with reconciliation of payments and supplier accounts
Answered by AI
Add your answer
Q2. There is how many types of PO
Ans. 
There are three main types of purchase orders: Standard PO, Blanket PO, and Contract PO.
• Standard PO: Used for one-time purchases of goods or services.

• Blanket PO: Used for recurring purchases from a single supplier over a period of time.

• Contract PO: Used for long-term agreements with suppliers for specific goods or services.

• Each type of PO serves a different purpose and has its own set of requirements and processes.
Answered by AI
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