Yatra Business Analyst Interview Questions and Answers

Q1. They will ask about your profile and past experience.
Add your answer

Q1. A peer level colleague will ask some basic knowledge check questions
Add your answer

This is literally a live coding test. For analytics expect SQL, python, R.

Q1. Interviewed by a manager of another team
Add your answer

Q1. Interviewed by dotted line reporting manager
Add your answer

Q1. Cross functional interview
Add your answer

Q1. Core Values Interview
Add your answer

There were some aptitude question, Pandas question, SQL queries.

Q1. Use SQL to filter duplicate entries.
Ans. 
Use SQL query with DISTINCT keyword to filter duplicate entries.
• Use SELECT DISTINCT column_name FROM table_name;

• DISTINCT keyword removes duplicate values from the result set.

• For example, SELECT DISTINCT name FROM employees;

• You can also use GROUP BY clause to eliminate duplicates.
Answered by AI
Add your answer
Q2. Questions on Excel Shorcuts.
Add your answer

Q1. SQL Questions are asked, learn joins and aggregate functions
Add your answer

Simple Case Study was discussed

Q1. Company fit check and salary expectations
Add your answer

SQL, General Aptitude Questions

10 minutes GD on general topics.

Q1. Case study related tl hospitality industry
Add your answer
Q2. Questions related to POR held in college
Add your answer

Q1. SQL, and puzzles
Add your answer

Q1. SQL Basic Question
Add your answer
Q2. SQL Medium Level Question
Add your answer

Q1. Live SQL Programming
Add your answer
Q2. Live Pyhton Programming
Add your answer

Q1. Case Study related to hotel industry
Add your answer
Q2. Root cause analysis of a scenario
Ans. 
Root cause analysis involves identifying the underlying reason for a problem or issue.
• Identify the problem or issue that needs to be analyzed

• Gather relevant data and information related to the problem

• Use tools like fishbone diagram or 5 Whys to dig deeper into the root cause

• Consider all possible factors that could have contributed to the problem

• Develop a plan to address the root cause and prevent future occurrences
Answered by AI
Add your answer

Basic aptitude question and 2 Sql question

Q1. 2 Sql question i on joins and other on window function
Add your answer
Q2. 1 Guestimate 1 Puzzle
Add your answer
Q3. Intoduction about your self
Add your answer
Q4. About your resume and interest
Add your answer

Q1. Details discussion on Previous projects and Situation based questioning
Add your answer