Oyo Rooms Business Analyst Interview Questions, Process, and Tips

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

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

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. 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