A past coaching client of mine interviewed for an entry-level Data Science job in Los Angeles that paid $110k per year.

Here's the 19 interview questions they were asked:

(how many of these could you answer?)

𝐒𝐭𝐚𝐭𝐢𝐬𝐭𝐢𝐜𝐬 🔢

1. Explain the difference between population variance vs sample variance

2. Describe a p-value to a 13-year-old (8th grader)

3. What Does an R-Squared Value of 0.9 Mean?
𝐒𝐭𝐚𝐭𝐢𝐬𝐭𝐢𝐜𝐬 (Continued) 🔢

4. What are some metrics to evaluate how predictive your logistic regression model is?

5. Can you explain precision vs. recall? How does that relate to an ROC curve?
𝐒𝐐𝐋 ⚙️

6. What is a database view?

7. What's the difference between a primary key & a foreign key?

8. Have you had to troubleshoot a slow query before? How did you do it?

9. When should you use a Sub-Query vs. CTE?
𝐒𝐐𝐋 (Continued) ⚙️

10. Can you write a SQL query to find the 3-day rolling average?

(very similar to this Twitter SQL interview question on DataLemur)

https://t.co/ssEQvcrKgo
𝐒𝐐𝐋 (Continued) ⚙️

11. Can you write a SQL query to find the most frequently purchased pairs of items?

(very similar to the Walmart SQL Interview question on DataLemur)

https://t.co/J8rwcjp8P5
𝐏𝐲𝐭𝐡𝐨𝐧 🐍

12. Which Python libraries do you use?

13. What are some steps you take to clean dirty data?

14. In this dataframe, how would you remove all rows that met X condition?
𝐏𝐲𝐭𝐡𝐨𝐧 (Continued) 🐍

15. Can you write code to find this value in a JSON object?

16. After loading the IRIS dataset via scikit-learn, can you build a simple regression model, and interpret the output?
𝐌𝐢𝐬𝐜𝐞𝐥𝐥𝐚𝐧𝐞𝐨𝐮𝐬 🤷‍♂️

17. What are some ways you'd improve this sample Tableau dashboard, so a business stakeholder could get more value from it?

18. What metrics do you think are important to track for our business line? Do you see any potential flaws in those metrics?
𝐌𝐢𝐬𝐜𝐞𝐥𝐥𝐚𝐧𝐞𝐨𝐮𝐬 (Continued) 🤷‍♂️

19. Walk us through 2 of your past work projects.

What the most challenging technical and non-technical part of each project?
How many of these 19 questions could you answer?

Would you be able to land the $110k Data Science job?

BTW if you enjoyed this thread:

1. Follow me @NickSinghTech for more data interview tips!
2. RT the tweet below to share this thread & challenge your followers! https://t.co/GUkhNwMcRu
Looking for resources to study for #DataScience & #MachineLearning interviews?

Follow this 12-Week Roadmap 🧵👇

https://t.co/NLJ4oU6NbL
Also, don't forget, that #SQL is a KEY part of the Data Science and Data Analyst interview process.

Here's the 30 Day Plan to go from SQL Zero to SQL HERO!

🧵👇

https://t.co/7uRtIH1Y5F

More from All

॥ॐ॥
अस्य श्री गायत्री ध्यान श्लोक:
(gAyatri dhyAna shlOka)
• This shloka to meditate personified form of वेदमाता गायत्री was given by Bhagwaan Brahma to Sage yAgnavalkya (याज्ञवल्क्य).

• 14th shloka of गायत्री कवचम् which is taken from वशिष्ठ संहिता, goes as follows..


• मुक्ता-विद्रुम-हेम-नील धवलच्छायैर्मुखस्त्रीक्षणै:।
muktA vidruma hEma nIla dhavalachhAyaiH mukhaistrlkShaNaiH.

• युक्तामिन्दुकला-निबद्धमुकुटां तत्वार्थवर्णात्मिकाम्॥
yuktAmindukalA nibaddha makutAm tatvArtha varNAtmikam.

• गायत्रीं वरदाभयाङ्कुश कशां शुभ्रं कपालं गदाम्।
gAyatrIm vardAbhayANkusha kashAm shubhram kapAlam gadAm.

• शंखं चक्रमथारविन्दयुगलं हस्तैर्वहन्ती भजै॥
shankham chakramathArvinda yugalam hastairvahantIm bhajE.

This shloka describes the form of वेदमाता गायत्री.

• It says, "She has five faces which shine with the colours of a Pearl 'मुक्ता', Coral 'विद्रुम', Gold 'हेम्', Sapphire 'नील्', & a Diamond 'धवलम्'.

• These five faces are symbolic of the five primordial elements called पञ्चमहाभूत:' which makes up the entire existence.

• These are the elements of SPACE, FIRE, WIND, EARTH & WATER.

• All these five faces shine with three eyes 'त्रिक्षणै:'.

You May Also Like

Still wondering about this 🤔


save as q