Uber Business Analyst Interview Experience
Business Analyst
Summary
AI Powered
The Uber interview experience for a Business Analyst position was comprehensive, consisting of several rounds focused on SQL questions, scenario-based inquiries, and guesstimates. Candidates can expect to tackle SQL queries addressing transaction data and user information, followed by analytical scenarios to assess their problem-solving capabilities. Overall, the interview process at Uber is rigorous and evaluates both technical knowledge and analytical thinking skills.
1
#1Extract Third Transaction of Every User
Medium
sql
database
transactions
Write an SQL query to extract the third transaction of every user, displaying user ID, spend, and transaction date.
#1
Extract Third Transaction of Every User
Write an SQL query to extract the third transaction of every user, displaying user ID, spend, and transaction date.
sql
database
transactions
Medium
#2Calculate Average Ratings for Each Driver
Medium
sql
data-analysis
ratings
Calculate the average ratings for each driver across different cities using data from rides and ratings tables.
#2
Calculate Average Ratings for Each Driver
Calculate the average ratings for each driver across different cities using data from rides and ratings tables.
sql
data-analysis
ratings
Medium
#3Identify Customers with Gmail Addresses
Medium
sql
database
email-filtering
Create an SQL query to identify customers registered with Gmail addresses from the 'users' database.
#3
Identify Customers with Gmail Addresses
Create an SQL query to identify customers registered with Gmail addresses from the 'users' database.
sql
database
email-filtering
Medium
#4Define Database Denormalization
Easy
sql
database
denormalization
What does database denormalization mean?
#4
Define Database Denormalization
What does database denormalization mean?
sql
database
denormalization
Easy
#5Analyze Click-Through Conversion Rates
Medium
sql
data-analysis
conversion-rates
Analyze the click-through conversion rates using data from ad_clicks and cab_bookings tables.
#5
Analyze Click-Through Conversion Rates
Analyze the click-through conversion rates using data from ad_clicks and cab_bookings tables.
sql
data-analysis
conversion-rates
Medium
#6Define a Self-Join
Easy
sql
self-join
database-concepts
Define a self-join and provide a scenario for its application.
#6
Define a Self-Join
Define a self-join and provide a scenario for its application.
sql
self-join
database-concepts
Easy
2
#1Probability Calculation for Recommended Routes
Medium
probability
analytics
What is the probability that at least two of three recommended routes for drivers are the fastest, given a 70% success rate?
#1
Probability Calculation for Recommended Routes
What is the probability that at least two of three recommended routes for drivers are the fastest, given a 70% success rate?
probability
analytics
Medium
3
#1Estimate Number of Uber Drivers in Delhi
Medium
guesstimate
market-analysis
Estimate the number of Uber drivers in Delhi.
#1
Estimate Number of Uber Drivers in Delhi
Estimate the number of Uber drivers in Delhi.
guesstimate
market-analysis
Medium
#2Estimate Cab Departures from Bengaluru Airport
Medium
guesstimate
market-analysis
How many Uber cabs leave Bengaluru Airport in a day?
#2
Estimate Cab Departures from Bengaluru Airport
How many Uber cabs leave Bengaluru Airport in a day?
guesstimate
market-analysis
Medium
A
Anonymous
Anonymous User