Top Data Science Interview Question And Answer Mistakes 2021 [Asked By Amazon]

We're going to cover the #1 most common mistake made on data science interviews. This mistake is made by both inexperienced and experience data science professionals; it happens both on interviews and in the work setting; and the mistake takes place when trying to solve the most common data science question. Let's cover it so that you don't make the same mistake.

Platforms I recommend to practice data science real scenarios:

______________________________________________________________________

______________________________________________________________________
Timestamps:

Intro: (0:00)
Description of the most common mistake: (0:34)
Coding example of mistake: (1:00)
How to properly solve the question: (4:50)
Reason why you're making these mistakes: (7:30)
Recommendations to improve: (8:10)

______________________________________________________________________
Contact:

If you have any questions, comments, or feedback, please leave them here!
______________________________________________________________________

#datascience #sqlinterviews #codinginterviews

[dominic]

7:14 people make this mistake because of the phrasing of the question. "customer" should be changed to "customer(s)" and "first name" should be changed to "first name(s)". this way, the question suggests the possibility that the solution can contain more than one person.
8:09 what is "data at scale issues"?

[culpgrant]

What do you think about using the RANK function to handle the case of ties?

[NeelanshuniSingh]

Hi, just one thing if we could aggregate the total order value at customer level between the dates then we can accurately get the results. As in solution, it might be case that one customer has various order value and after aggregating we get total order value for each customer and then decide which is the top ones.

[abhisheksinghchouhan]

Your explanation very and easy to understand..but your site name is very difficult to remember

[IanWitherow]

Trying out the StrataScratch question - I'm returning two records, Mia and Farida, both with 400 for the total and their respective order dates, but it's not accepting it. The Expected Output button is showing 430 for the order totals, but I'm not seeing that order total in the data. Am I missing something?
Edit: Ah, multiple orders on the same date, got it. Was thrown off since you had 400 in your video there.

[hta-bi]

Hello,
Thank you for the great video.
I have a question!
Since we typed in the subquery limit 1, why the overall output still returning 2 rows?
cheerz!

[huseyindansman]

select top 1 with ties (ms sql server), I was trying to do it exactly the way I do in ms sql server then found out it doesnt work out in postgreSQL

[niveditakumari]

Hey, we can also do this using DENSE_RANK() ?

[vikrant.]

Your github is not updated since past one year Nate?