Practice for the Nike interview with these recently asked interview questions.
| Question | Topic | Difficulty | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL | Medium | |||||||||||||||||||
As a data analyst in a fitness app company, you are tasked with analyzing the user’s daily step count. Write a SQL query to calculate the 3-day rolling average of steps for each user, rounded to the nearest whole number. Notes: The rolling average should only be calculated for days where there are 3 previous days of step counts, including the current day. The first 2 days for any user should be excluded. Example: Input:
Output:
| ||||||||||||||||||||
SQL | Easy | |||||||||||||||||||
SQL | Medium | |||||||||||||||||||
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Check your skills...
How prepared are you for working at Nike?
Most data science positions fall under different position titles depending on the actual role.
From the graph we can see that on average the Data Scientist role pays the most with a $164,096 base salary while the Business Intelligence role on average pays the least with a $105,000 base salary.
Discussion & Interview Experiences