How to Ace the Uber Excel Analytics Test (Second Edition)
SEE ALSO: How to Ace the Uber Interview
This course helps the student learn, prepare, and succeed on their upcoming Uber Excel analytics test. It includes a detailed overview of what to expect in the Uber Excel analytics test along with real interview questions and answers. This course comes with two .CSV files for the student to download and use to answer the questions provided in the video. The video then explains the answers in layman's terms.
What's included in the purchase
1 hr and 21 mins of streaming video and 136 pages of PDF slides where the instructor will cover the course details below.
Course Details
- Review the different Uber positions covered in this video, including:
- Operations and Logistics
- Marketing Manager
- General Manager
- Associate General Manger
- Marketing Manager
- Discuss the fifteen Uber metrics and terms, including:
- Completed Trips
- Demand
- Dispatch
- Driver
- Driver Supply
- ETA
- Eyeballs
- Fare
- Idle Time
- Peak Hours
- Requests
- Rider
- Surge Pricing
- Working Shifts
- Zeros
- Covers 30 multiple choice questions found in the Uber Excel analytics test, including:
- Between the 1st and the 5th of February, which date has the most completed trips?
- What hour of the day had the most completed trips on February 11th?
- What hour of the day from the 15 day period in February had the least number of requests?
- What is the percentage of all of the eyeballs that occurred on Fridays?
- What is the weighted average of requests per driver for the 15 day data set?
- Drivers' schedules are drafted in 4 hour shifts, and Uber wants to change this to 8 hour shifts. Calculate which shift has the highest request for the 15 day data set.
- When the number of unique drivers increases so does the number of eyeballs?
- On which day is the ratio the highest for the number of completed trips to requests?
- If you had 10 drivers to add to one hour throughout the 15 day data set, which hour would you add them to?
- How many hours of data are in this data set?
- Use the data to determine when the best end-of-day is for drivers.
- 10 additional practice problems, including:
- What is the probability of an Uber driver accepting your request?
- How many years will it take for UberBlack drivers to outnumber UberX drivers?
- What will be the change in Uber revenue after a fare increase?
- If Uber starts a promo, what is the maximum amount of fare reduction before loss of revenue?
- What is the maximum number of possible Uber candidates, given Uber’s eligible driver policy?
- What is the minimum number of possible Uber candidates, given Uber’s eligible driver policy?
- What is the probability of a Uber passenger getting to choose their seat first?
- Would an UberBlack vehicle beat Usain Bolt at the 100 meter sprint?
- What is the individual bill of an Uber trip split proportionally by trip distance?
- How many license plates in New York do not have any repeating numbers?
- 6 short and long questions and answers, including:
- Explain to someone who is not familiar with the term, what surge-pricing is and the main reasons behind why it's a good choice for Uber.
- Convince a chauffeur driver to switch to become an Uber driver.
- Explain how to engage local community groups with Uber.
- Write a letter aimed at Uber drivers who have an acceptance rate of between 70% and 79% to encourage them to accept more requests.
- Write a letter to restaurants asking if they would like to join the new UberEATS service starting in San Francisco.
Joseph is the instructor for the class. At Impact Interview, he is part of the digital instruction team. Prior to Impact Interview, Joseph had extensive experience in research development and analysis. He graduated with a Bachelor's Degree from Johns Hopkins University.
Frequently Asked Questions
Is this a live class or a recorded video?
You will be purchasing a recorded video and class slides, not a live class.
Do you have any upcoming live classes?
There are no live classes scheduled for the near future.
Refund Policy
Please confirm all purchases before you complete them as all sales are final. There are no refunds for digital content.
About the Author
Joseph is the instructor for the class. At Impact Interview, he is part of the digital instruction team. Prior to Impact Interview, Joseph had extensive experience in research development and analysis. He graduated with a Bachelor's degree from Johns Hopkins University.