EXL Service Business Analyst Interview Questions and Answers for Freshers

Q1. General screening
Add your answer

Q1. Sql and tableau basic questions
Add your answer

Q1. Business and technical both more on sql and tableau experience
Add your answer

Q1. SQL questions fetching date from two tables
Ans. 
SQL query to fetch dates from two tables, demonstrating joins and date filtering.
• Use JOIN to combine data from two tables based on a common key.

• Example: SELECT a.date, b.event FROM tableA a JOIN tableB b ON a.id = b.a_id WHERE a.date > '2023-01-01';

• Consider using LEFT JOIN if you want to include all records from the first table.

• Use WHERE clause to filter results based on date conditions.

• Example: SELECT * FROM orders...read more
Answered by AI
Add your answer
Q2. Questions on how to tackle tough stakeholders
Ans. 
Effectively managing tough stakeholders requires communication, empathy, and strategic negotiation skills.
• Understand their perspective: Schedule one-on-one meetings to listen to their concerns and motivations.

• Build rapport: Share common goals and demonstrate how your project aligns with their interests.

• Communicate clearly: Use simple language and visuals to explain complex concepts, ensuring they feel informed.

• Be proac...read more
Answered by AI
Add your answer
Q3. Meaning of success for you
Add your answer

Basic to medium level aptitude questions not too tough

Q1. >Project based questions on ur resume >Coding questions based on the language in ur resume very basic. >Guesstimates >No of active credit cards user in india >Puzzles:from GFG >Standard Sql questions like ...read more
Add your answer

Q1. What is your future aspirations >Standard questions from statistics >Central tendency >Standard deviations >How much will you rate yourself out of 10
Ans. 
My future aspiration is to become a successful business analyst and contribute to the growth of the company.
• I aim to enhance my skills in data analysis and problem-solving.

• I want to work on diverse projects and gain experience in different industries.

• I plan to take up leadership roles and mentor junior analysts.

• I aspire to be a valuable asset to the organization and help achieve its goals.
Answered by AI
Add your answer

The first round usually contains aptitude, data interpretation and verbal.
Need to be quick because we hardly get 90sec for a question.

Q1. Technical Round would be from the skills mentioned on your resume. Since I had ML written on my resume he started asking about ML algorithms. Some of the questions were- what is a loss function? How do yo...read more
Add your answer

Q1. In this round the interviewer gave a problem and asked me to solve using python. This time he asked about my projects mentioned on the resume. He asked some of interests and he explained the working cultur...read more
Add your answer