Ixigo.com Business Analyst Interview Questions and Answers

Q1. Tell me about yourself
Add your answer

Q1. About the industry
Add your answer

I was asked with SQL querying questions.

Q1. Set of questions related to excel.
Add your answer
Q2. Vlookup, sumifs, pivot tables
Add your answer

Q1. Related to past work experience.
Add your answer
Q2. Scenario based questions related to business industry.
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

SQL questions and logical reasoning

Q1. Talked about resume, projects and general questions of maths and logical reasoning
Add your answer

A guesstimate and a case study on profitability

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