Amadeus Business Analyst Interview Questions and Answers

Q1. Tell me about yourself
Add your answer

Q1. About the industry
Add your answer

Ratios, charts ques, dirction ques

Guestimates, sql questions

Sql questions geeks for geeks

Q1. What are the use cases of self-join?
Ans. 
Self-join is used to join a table with itself to compare rows within the same table.
• Used to compare rows within the same table

• Helps in retrieving hierarchical data

• Can be used to find employees who report to the same manager
Answered by AI
Add your answer
Q2. How to extract nth highest salary?
Add your answer
Q3. What are the critical KPIs to be monitored after creating a new website?
Ans. 
Critical KPIs to monitor after creating a new website include traffic, conversion rate, bounce rate, and user engagement.
• Traffic: Monitor the number of visitors to the website to gauge its reach and popularity.

• Conversion Rate: Track the percentage of visitors who take a desired action, such as making a purchase or signing up for a newsletter.

• Bounce Rate: Measure the percentage of visitors who leave the website after vi...read more
Answered by AI
Add your answer
Q4. What would be the probability of getting at least one six after throwing 2 unbiased dice?
Ans. 
The probability of getting at least one six after throwing 2 unbiased dice is 11/36.
• The total number of outcomes when throwing 2 dice is 36 (6 sides on each die)

• The number of outcomes where at least one die shows a six is 11 (6 outcomes where one die shows a six, plus 1 outcome where both dice show sixes)
Answered by AI
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

Q1. Estimate population of Delhi? Give profitability of an airline company having operations at two different places?
Ans. 
Estimating population of Delhi and profitability of an airline company with operations at two different places.
• Estimating population of Delhi can be done by using census data, surveys, and demographic trends.

• Profitability of an airline company with operations at two different places can be calculated by analyzing revenue, expenses, and market share.

• For Delhi's population, the latest census data can be used to estimate ...read more
Answered by AI
Add your answer
Q2. Ppt round + random one word questions
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