Uber Data Scientist Mock Interview | Interview Coach (Ex-Google)

Подписаться 30 тыс.

Просмотров 9 тыс.

50% 1

👉 Land Your Dream Data Job. Visit www.datainterview.com 🚀
👉 Join the Data Scientist Interview Bootcamp: www.datainterview.com/bootcam...
====== ⭐ Details ======
Dan, a former data scientist at Google, conducts a mock interview for Uber's data scientist role. The interview is based on the technical screen which typically consists of SQL and product sense questions.
As an interview coach, Dan has helped several clients land their dream jobs as IC and managerial DS roles at top companies such as Google, Meta, Amazon and such.
Got questions? Message him at dan@datainterview.com
Make sure to check out 👉 datainterview.com/
====== ⏱️ Timestamps ======
00:00 Intro
01:45 SQL
16:23 Product Sense
====== 📚 Other Useful Contents ======
1. Principles and Frameworks of Product Metrics | RU-vid Case Study
Link: / principles-and-framewo...
2. How to Crack the Data Scientist Case Interview
Link: / crack-the-data-scienti...
3. How to Crack the Amazon Data Scientist Interview
Link: / crack-the-amazon-data-...
====== Connect ======
📗 LinkedIn - / danleedata
📘 Medium - / datainterview

Наука

Опубликовано:

3 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 23

@anggipermanaharianja6122 2 года назад

The SQL question is really a good one, good to see more question sample like this

@DataInterview 2 года назад

More coming!

@Aidan_Au 2 года назад

I can't believe that Dan just put this priceless content out for free! Imagine how much more valuable his coaching would even be! Your student Matt in Meta said that SQL and Case Study are usually the technical screen. I'll def get good at those before applying.

@DataInterview 2 года назад

Thanks Aidan as always :) -- Dan

@trangpham6025 2 года назад

shouldn't the cancellation rate in the first SQL question be sum(number_of_orders) with status_of_order = Cancelled / sum(number_of_orders)?

@DataInterview 2 года назад

The short cut is to just use an indicator function on the cancellation and take the average of that which gives you proportion

@ozmundsedler Год назад

@@DataInterview but you don't take into the account number of orders in this case, so the proportion won't be correct.

@huanchenli4137 8 месяцев назад

group by man@@ozmundsedler

@liverpooler1997 2 месяца назад

I think the candidate was nervous and spike before thinking many times in the product case. Maybe if she had a couple minutes to compose her thoughts, she coulda done better.

@user-wb7vz8fx9k Год назад

Hey Dan, first thanks for the great content! I wanted to ask if the CTE is really necessary here, because in my head we could do it with one query as follows: SELECT service_name, AVG(CASE WHEN status_of_order = 'cancelled' THEN 1 ELSE 0 END) as cancel_rate, AVG(monetary_value) AS avg_mont, MAX(number_of_orders) as max_count FROM RideStatus GROUP BY service_name ORDER BY cancel_rate DESC LIMIT 3;

@akshayiithyd 10 месяцев назад

This will only work if the cancel_rates are distinct

@firesongs Год назад

Really great case study q and analysis

@hemantsharma7986 2 года назад

This is great bro👏

@asdfgg7104 2 года назад

thanks

@rihaansatia2812 6 месяцев назад

shouldnt ther be a group by at the very end?

@yemunnsoe8450 8 месяцев назад

She's not really paying attention to the interviewer and is eager to share her thoughts and answers

@songsong2334 2 года назад

Thanks Dan!!!! Great question!! For the SQL question, my thoughts will be the following. ##Find out 3 service names with the highest cancel rate. With sn as( SELECT service_name from( SELECT DENSE_RANK()OVER(ORDER BY ROUND(SUM(CASE WHEN status_of_order ='cancelled' then 1 else 0 end)*100.0/Count(*),2), service_name) rnk GROUP BY service_name) sub where rank

@DataInterview 2 года назад

I would say, for redability, decouble the rank and case part into two separate subqueries. In the last part, you are missing GROUP BY.