Uber Analytics Excel/CSV Test Book Now Available on Amazon

amazon, analytics test, books, excel test, interview preparation, uber -

Uber Analytics Excel/CSV Test Book Now Available on Amazon

Buy Uber Analytics Test Book from Amazon

We've very excited to announce that our popular course on Uber Analytics Test is now available on Amazon

The Uber Analytics Test is the second test in the entire interview for General Manager, Associate General Manager, Operations and Logistics Manager and Marketing Manager positions at Uber. 

If you pass the recruiter screen, the next step is to do this 2 hour timed online analytics test. 

The Uber Analytics Excel/CSV Test Book helps students learn, prepare, and succeed on their upcoming Uber Excel analytics test. It includes a detailed overview of what to expect on the Uber Excel analytics test along with real interview questions and answers. This book comes with two .CSV files for the student to download and use to answer the questions provided in the book. 

Book Outline 

  1. Test Details – Here we will cover what to expect on the test. 
  2. Theory - Here we’ll go through theory around Uber’s business model, pricing strategy, metrics etc. 
  3. Quantitative Questions – First CSV - On the test you will be presented with 2 CSVs. Questions are based on them and we’ll cover both a number of questions and answers in this section. 
  4. Quantitative Questions – Second CSV - We’ll go through questions and answers based on the second file in this section. 
  5. General Multiple Choice Questions - We’ll then look at general questions aimed at your knowledge of Uber’s business as a whole. 
  6. Short Answers – We’ll cover short answers that you’ll be expected to write. 
  7. Long Answers - We’ll cover long answers that you’ll be expected to write. 
  8. Conclusion - We’ll finally conclude the course in this section with some last minute tips. 

Buy Uber Analytics Test Book from Amazon


What You'll Get 

  1. 120+ pages that walk you step by step on what needs to be done. 
  2. 2 downloadable CSVs.
  3. 24/7 support on any questions you might have. 

Book Details 

  • Review the different Uber positions covered in the Book, including: Operations and Logistics, Marketing Manager, General Manager, Associate General Manger, Marketing Manager 
  • Discuss Surge Pricing - an extremely important concept on the exam.
  • Discuss 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 many many 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. 
    • Sample of short and long answer questions and an approach to answer them: 
      • What is surge-pricing is and the main reasons behind why it's a good choice for Uber.
      • Write a letter to drivers motivating them to use Uber more often.

    Buy Uber Analytics Test Book from Amazon