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

You May Also Like

Хајде да направимо мали осврт на случај Мика Алексић .

Алексић је жртва енглеске освете преко Оливере Иванчић .
Мика је одбио да снима филм о блаћењу Срба и мењању историје Срба , иза целокупног пројекта стоји дипломатски кор Британаца у Београду и Оливера Иванчић


Оливера Илинчић је иначе мајка једне од његових ученица .
Која је претила да ће се осветити .

Мика се налази у притвору због наводних оптужби глумице Милене Радуловић да ју је наводно силовао човек од 70 година , са три бајпаса и извађеном простатом пре пет година

Иста персона је и обезбедила финансије за филм преко Беча а филм је требао да се бави животом Десанке Максимовић .
А сетите се и ко је иницирао да се Десанка Максимовић избаци из уџбеника и школства у Србији .

И тако уместо романсиране верзије Десанке Максимовић утицај Британаца

У Србији стави на пиједестал и да се Британци у Србији позитивно афирмишу како би се на тај начин усмерила будућност али и мењао ток историје .
Зато Мика са гнушањем и поносно одбија да снима такав филм тада и почиње хајка и претње која потиче из британских дипломатских кругова

Најгоре од свега што је то Мика Алексић изговорио у присуству високих дипломатских представника , а одговор је био да се све неће на томе завршити и да ће га то скупо коштати .
Нашта им је Мика рекао да је он свој живот проживео и да могу да му раде шта хоће и силно их извређао
1/“What would need to be true for you to….X”

Why is this the most powerful question you can ask when attempting to reach an agreement with another human being or organization?

A thread, co-written by @deanmbrody:


2/ First, “X” could be lots of things. Examples: What would need to be true for you to

- “Feel it's in our best interest for me to be CMO"
- “Feel that we’re in a good place as a company”
- “Feel that we’re on the same page”
- “Feel that we both got what we wanted from this deal

3/ Normally, we aren’t that direct. Example from startup/VC land:

Founders leave VC meetings thinking that every VC will invest, but they rarely do.

Worse over, the founders don’t know what they need to do in order to be fundable.

4/ So why should you ask the magic Q?

To get clarity.

You want to know where you stand, and what it takes to get what you want in a way that also gets them what they want.

It also holds them (mentally) accountable once the thing they need becomes true.

5/ Staying in the context of soliciting investors, the question is “what would need to be true for you to want to invest (or partner with us on this journey, etc)?”

Multiple responses to this question are likely to deliver a positive result.