AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
EXL
Service
Compare
Filter interviews by
EXL Service Senior Business Analyst Interview Questions and Answers
6 Interview questions
The triangle with sides 300, 350, and 400 has a greater area than the one with sides 300, 400, and 700.
Triangle Inequality Theorem: A triangle can only exist if the sum of the lengths of any two sides is greater than the length of the third side.
First Triangle: Sides 300, 400, and 700 do not satisfy the triangle inequality (300 + 400 is not greater than 700), hence it is not a valid triangle.
Second Triangle: Sides...
Logistic regression can predict binary outcomes, such as whether a patient has a disease based on various health metrics.
Predicting whether a customer will buy a product (yes/no) based on their demographics and past behavior.
Determining if a loan applicant is likely to default (yes/no) based on credit score and income.
Assessing the likelihood of a patient having a specific disease based on symptoms and test result...
SQL window functions allow for advanced data analysis by performing calculations across a set of table rows related to the current row.
Window functions operate on a set of rows defined by an OVER() clause.
Common window functions include ROW_NUMBER(), RANK(), and SUM().
Example: SELECT employee_id, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM employees;
Window functions do not change the number of r...
totalytd calculates the total year-to-date value, while datesytd calculates the year-to-date value based on specified dates.
totalytd sums up the values from the beginning of the year until the current date
datesytd calculates the sum of values within a specified date range for the year
totalytd is a predefined function in some programming languages like DAX in Power BI
datesytd requires specifying the start and end d...
What people are saying about EXL Service
A gateway is a node on a network that serves as an entrance to another network.
Gateway acts as a bridge between different networks
It controls access to the network it is connected to
Examples include routers, switches, and firewalls
To find the third highest salary in SQL, you can use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' twice.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' to find the highest salary.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' and 'WHERE salary < (SELECT TOP 1 salary FROM table)' to find the second highest salary.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' and...
EXL Service Senior Business Analyst Interview Experiences
15 interviews found
Anonymous
Selected
Relatively easy if you practice dsa
(1 Question)
- Q1. Basic DSA questions
(1 Question)
- Q1. Why do you want to join exl
- Ans.
I want to join EXL because of its reputation for innovation and excellence in the field of business analysis.
EXL has a strong reputation for innovation and excellence in the field of business analysis
I am impressed by EXL's track record of delivering high-quality solutions to clients
I believe that joining EXL will provide me with opportunities for professional growth and development
(1 Question)
- Q1. Salary expectations
(2 Questions)
- Q1. Difference between totalytd and datesytd
- Ans.
totalytd calculates the total year-to-date value, while datesytd calculates the year-to-date value based on specified dates.
totalytd sums up the values from the beginning of the year until the current date
datesytd calculates the sum of values within a specified date range for the year
totalytd is a predefined function in some programming languages like DAX in Power BI
datesytd requires specifying the start and end dates ...
- Q2. What is gateway
- Ans.
A gateway is a node on a network that serves as an entrance to another network.
Gateway acts as a bridge between different networks
It controls access to the network it is connected to
Examples include routers, switches, and firewalls
Skills evaluated in this interview
Good mcq on machine learning algo
(1 Question)
- Q1. SQL window function asked
- Ans.
SQL window functions allow for advanced data analysis by performing calculations across a set of table rows related to the current row.
Window functions operate on a set of rows defined by an OVER() clause.
Common window functions include ROW_NUMBER(), RANK(), and SUM().
Example: SELECT employee_id, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM employees;
Window functions do not change the number of rows r...
paru dhingra
(2 Questions)
- Q1. Puzzle questions
- Q2. Statistics questions
It was fairly easy and out of 100 students, 40 were selected
(1 Question)
- Q1. Question around python, resume projects
Selected
I applied via Approached by Company and was interviewed before Dec 2023. There were 2 interview rounds.
(2 Questions)
- Q1. SQL windowing function
- Q2. Machine learning basic questions
(2 Questions)
- Q1. Hypothesis testing
- Q2. Sql
Selected
I appeared for an interview before Mar 2024, where I was asked the following questions.
- Q1. Give an example of a scenario where you can use logistic regression model?
- Q2. A triangle has 3 sides as 300, 400 and 700. Another has 3 sides as 300, 350,400. Which will have greater area?
- Ans.
The triangle with sides 300, 350, and 400 has a greater area than the one with sides 300, 400, and 700.
Triangle Inequality Theorem: A triangle can only exist if the sum of the lengths of any two sides is greater than the length of the third side.
First Triangle: Sides 300, 400, and 700 do not satisfy the triangle inequality (300 + 400 is not greater than 700), hence it is not a valid triangle.
Second Triangle: Sides 300,...
Selected
I applied via Naukri.com and was interviewed before May 2023. There were 4 interview rounds.
Advanced Sas question
(3 Questions)
- Q1. SAS MACROS, FIRST.ID AND LAST.ID, MERGE, SQL,PROCS, PROC UNIVARIATE
- Q2. Third highest salary insql
- Ans.
To find the third highest salary in SQL, you can use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' twice.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' to find the highest salary.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' and 'WHERE salary < (SELECT TOP 1 salary FROM table)' to find the second highest salary.
Use the 'SELECT TOP 1' statement with 'ORDER BY salary DESC' and 'WHE...
- Q3. Delete duplicate in sql
- Ans.
Use the DISTINCT keyword in SQL to delete duplicates from a table.
Use the SELECT DISTINCT statement to retrieve unique rows from a table.
You can also use the GROUP BY clause with aggregate functions like COUNT() to remove duplicates.
Consider using the ROW_NUMBER() function to assign a unique number to each row and then filter out duplicates based on this number.
(1 Question)
- Q1. Marcos, procs in SAS
(1 Question)
- Q1. Salary expectation
Interview Preparation Tips
- Marcos, PROCS, SQL,
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Dec 2021. There were 5 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Discussion on salary and joining
- Q2. They were asked me scenario based questions for tableau and sql
- Q3. They were taking my technical round with tableau desktop and asked me to solved some questions
- Q4. Manager asked me some sql questions
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There were 3 interview rounds.
40 questions,45 minutes
(2 Questions)
- Q1. SQL, python, Excel
- Q2. Puzzles,guesstimates
(1 Question)
- Q1. Goal in life,why to join?, company related questions
EXL Service Interview FAQs
Tell us how to improve this page.
EXL Service Interviews By Designations
- EXL Service Business Analyst Interview Questions
- EXL Service Consultant Interview Questions
- EXL Service Executive Interview Questions
- EXL Service Assistant Manager Interview Questions
- EXL Service Senior Associate Interview Questions
- EXL Service Senior Executive Interview Questions
- EXL Service Data Analyst Interview Questions
- EXL Service Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Software Engineer Interview Questions
- Business Analyst Interview Questions
- Data Analyst Interview Questions
- Senior Associate Interview Questions
- Senior Executive Interview Questions
- Senior Consultant Interview Questions
- Senior Analyst Interview Questions
- Senior Manager Interview Questions
- Show more
Overall Interview Experience Rating
based on 9 interview experiences
Difficulty level
Duration
Senior Business Analyst Interview Questions from Similar Companies
EXL Service Senior Business Analyst Reviews and Ratings
based on 80 reviews
Rating in categories
|
Senior Executive
4.5k
salaries
|  ₹0.9 L/yr - ₹7.5 L/yr |
|
Assistant Manager
3.3k
salaries
| ₹4.1 L/yr - ₹16 L/yr |
|
Senior Associate
2.5k
salaries
| ₹1 L/yr - ₹8.5 L/yr |
|
Lead Assistant Manager
2.2k
salaries
| ₹6.5 L/yr - ₹24 L/yr |
|
Executive
2k
salaries
| ₹1 L/yr - ₹5.7 L/yr |
Genpact
DXC Technology
Mphasis
Sutherland Global Services
- Home >
- Interviews >
- EXL Service Interview Questions
