Ixigo.com Business Analyst Interview Questions and Answers

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

Q1. Tell me about yourself
Add your answer

Q1. About the 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

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