XYZ Distributors Business Analyst Interview Questions and Answers

Q1. Knowledge about data summarisation.and some tools like Power bi and advance excel.
Add your answer

Q1. What do I do in my existing job?
Add your answer
Q2. Why do you want to leave your existing job?
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Why would you like to join our organisation?
Add your answer

Q1. Output of joins
Ans. 
Output of joins is a combination of data from two or more tables based on a common column.
• Joins are used to combine rows from two or more tables based on a related column between them

• Types of joins include inner join, outer join, left join, and right join

• The output of a join will include columns from both tables, with rows that meet the join condition
Answered by AI
Add your answer
Q2. Rank dense rank cte
Add your answer

SQL, Hackerank,CTEs, Window functions , mcq

SQL,Probability,Python

Orders at amazon down, find the root cause analysis

Q1. Guesstimate on the number of active flights over India during a particular instance.
Ans. 
There are approximately 2,000 active flights over India at any given time.
• India has a busy aviation industry with major airports in cities like Delhi, Mumbai, and Bangalore.

• On average, there are around 2,000 flights in the air over India at any given time.

• This number can fluctuate depending on the time of day, day of the week, and season.

• Factors like weather conditions, air traffic control, and airline schedules can al
Answered by AI
Add your answer