EXL Service Business Analyst Interview Questions, Process, and Tips

Q1. Questions about python visualization libraries like seaborn and matplotlib
Add your answer

Q1. Questions about sub query, joins and unions in sql
Add your answer

Q1. Questions about measures and dimensions in tableau
Add your answer
Q2. How to draw a dual axis chart of bar and line chart
Ans. 
To draw a dual axis chart of bar and line chart, use Excel or any other data visualization tool.
• Create a bar chart with the data you want to display

• Add a second data series and choose line chart as the chart type

• Right-click on the second data series and select 'Format Data Series'

• Under 'Series Options', choose 'Secondary Axis'

• Adjust the formatting as needed to make the chart clear and easy to read
Answered by AI
Add your answer

Basic Aptitude, time and distance, time and work, basic class 10 maths

Q1. Guesstimate - detergent used in hospital in a day
Add your answer
Q2. Position of responsibility
Ans. 
I have held multiple positions of responsibility in my previous roles, including leading project teams and managing client relationships.
• Led a project team to successfully implement a new software system

• Managed client relationships and ensured customer satisfaction

• Served as a mentor to junior team members and provided guidance on complex projects
Answered by AI
Add your answer

Q1. Guestimate - flights in mumbai airport in a day
Add your answer
Q2. What is that makes you a suitable candidate and why EXL
Ans. 
I am a suitable candidate for the Business analyst role at EXL due to my strong analytical skills, experience in data analysis, and ability to drive business insights.
• I have a strong background in data analysis and have successfully implemented data-driven strategies in my previous roles.

• I possess excellent analytical skills which enable me to interpret complex data and provide valuable insights for decision-making.

• I h...read more
Answered by AI
Add your answer

Q1. About scrum, product backlog, requirement handling
Add your answer
Q2. Some scenario based questions- if manager is planning the sprint and there is no scrum master in organization, how do you as BA make sure that product quality is not compromised.
Add your answer

Apti and maths and English mcq

Puzzles of geeksforgeeks

Q1. SQL join types and difference
Ans. 
SQL join types include inner join, left join, right join, and full outer join.
• Inner join returns rows when there is at least one match in both tables.

• Left join returns all rows from the left table and the matched rows from the right table.

• Right join returns all rows from the right table and the matched rows from the left table.

• Full outer join returns all rows when there is a match in either table.
Answered by AI
Add your answer

Aptitude test consists of 35 mins in 40 mins

Q1. The interviewer is quite good and asked about SQL and projects in the resume.and he asks about the case study and that's it and I have shortlisted for second and final round but there i was failed
Add your answer

Q1. This was tough the interviewer was not good she asked many difficult questions in the case study and puzzles
Add your answer

Basic aptitude questions

Q1. About the projects and SQL queries
Add your answer
Q2. Puzzles and guesstimates
Add your answer

Q1. Family background
Add your answer
Q2. Some technical questions were also asked
Add your answer