Airbnb Lead Analyst Manager Interview Questions and Answers

Q1. Difference Between Rank and Dense Rank
Ans. 
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
• Rank does not skip ranks when there are ties, while Dense Rank does

• Rank will have gaps in ranks if there are ties, while Dense Rank will not

• Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
Answered by AI
Add your answer
Q2. Some Basic Joins
Add your answer
Q3. Socks Pair Puzzle Qustions
Add your answer

The questions were related to Data Interpretation/Logical Reasoning and general aptitude.

Q1. Questions related to SQL queries, window functions, 2-3 sql queries had to write
Add your answer
Q2. Statistics related questions, left skewed, right skewed etc.
Add your answer
Q3. Questions related to basics of ML
Add your answer

A company wants to open a new store, what would the factors you would consider.
A ride sharing company wants dynamic pricing in place of flat pricing, what factors you would consider.

Q1. General Project and HR related questions.
Add your answer
Q2. Things you want to improve in swiggy and metrics to measure and evaluate them.
Add your answer

Q1. Cohort Analysis in google analytics
Ans. 
Cohort analysis in Google Analytics helps track the behavior of specific groups of users over time.
• Cohort analysis groups users based on a common characteristic or behavior, such as sign-up date or acquisition channel.

• It helps in understanding user retention, engagement, and conversion rates for different cohorts.

• Example: Analyzing the retention rate of users who signed up in a particular month compared to users who si
Answered by AI
Add your answer
Q2. Types of join in sql and their differences
Ans. 
Types of joins in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: returns rows when there is a match in both tables

• Outer join: returns all rows from both tables, filling in NULLs for missing matches

• Left join: returns all rows from the left table and the matched rows from the right table

• Right join: returns all rows from the right table and the matched rows from the left table

• Full joi...read more
Answered by AI
Add your answer

Basis CAT like aptitude with 2 simple python coding question

Q1. What Central limit theorem
Ans. 
The Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.
• States that the sampling distribution of the sample mean will be approximately normally distributed regardless of the shape of the population distribution

• Helps in making inferences about the population mean based on the sample mean

• Important concept in statistics and hypothesis...read more
Answered by AI
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

Basic questions based on Sql

Q1. Guesstimators,puzzle
Add your answer
Q2. Puzzle.guesstimators
Add your answer

First there will be an assignment.

Q1. Hr will ask about your previous role and responsibilities in detail.
Add your answer

Q1. One on one with the hiring manager.
Add your answer

Q1. Senior Hr manager and service delivery manager round.
Add your answer