Рет қаралды 69,801
Today I'm tackling a data analytics problem asked in data engineering and data science interviews. For most of these questions, there are multiple solutions involving both analytics and writing a SQL query.
Follow along and solve the case study on Interview Query: www.interviewquery.com/questi...
Relevant Links:
DoorDash analytics case study guide: www.interviewquery.com/p/door...
Analytics case study guide: www.interviewquery.com/p/data...
👉 Subscribe to my data science channel: bit.ly/2xYkyUM
Use the code "datasciencejay" and get 10% off data science interview prep 🔥 : www.interviewquery.com/pricin...
❓ Check out our data science course: www.interviewquery.com/course...
🔑 Get professional coaching here: www.interviewquery.com/coachi...
🐦 Follow us on Twitter: / interview_query
Ready to find data analysts and scientists who can tackle complex problems like the one in this video? Outsearch.ai leverages cutting-edge AI to identify top talent who possess the analytical skills and SQL expertise showcased here: www.outsearch.ai/?...
0:50 - Difference between product metrics and data analytics questions
2:32 - Data analytics problem description
3:00 - Framework for tackling data analytics
4:50 - Visualize the output
7:29 - Writing the SQL Query
9:03 - Where's the error?
Follow Jay on:
Twitter: / datasciencejay
LinkedIn: / jay-feng-ab66b049