Read Online Uber Analytics Test: Ace the Uber Analytics Excel Test DOC

"NOW WITH COMPLETE NEW CSV FILES AND ADDITIONAL QUESTIONS AND ANSWERS FOR VERSION 3.1 OF THE TEST"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. This book helps student 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. The book comes with two .CSV files for the student to download and use to answer the questions provided in the book. Course Outline1. 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. Additional Questions and Answers - Related to Version 3.1 of the Test.9. Conclusion - We’ll finally conclude the course in this section with some last minute tips.What You'll Get 140+ pages that walk you step by step on what needs to be done. 2 downloadable CSVs24/7 support on the actual test. Course Details1. Review the different Uber positions covered in this video, including: Operations and Logistics, Marketing Manager, General Manager, Associate General Manager, Marketing Manager2. Discuss Surge Pricing - an extremely important concept on the exam. 3. Discuss Uber metrics and terms, including:Completed TripsDemandDispatchDriverDriver SupplyETAEyeballsFareIdle TimePeak HoursRequestsRiderSurge PricingWorking ShiftsZeros4. Covers many many multiple choice questions found in the Uber Excel analytics test, including:a. Between the 1st and the 5th of February, which date has the most completed trips?b. What hour of the day had the most completed trips on February 11th?c. What hour of the day from the 15 day period in February had the least number of requests?d. What is the percentage of all of the eyeballs that occurred on Fridays?e. What is the weighted average of requests per driver for the 15 day data set?f. 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.g. When the number of unique drivers increases so does the number of eyeballs?h. On which day is the ratio the highest for the number of completed trips to requests?i. If you had 10 drivers to add to one hour throughout the 15 day data set, which hour would you add them to?j. How many hours of data are in this data set?k. Use the data to determine when the best end-of-day is for drivers.5. Sample of short and long answer questions and an approach to answer them: a. What is surge-pricing is and the main reasons behind why it's a good choice for Uber.b. Convince a non Uber driver to switch to become an Uber driver.c. Write a letter aimed at Uber drivers to encourage them to accept more requests.