Spotify Data Analyst Interview Questions and Answers

Q1. Find 3rd transaction of user from uber cab dataset
Ans. 
To find the 3rd transaction of a user from the Uber cab dataset.
• Identify the user's transactions in the dataset

• Sort the transactions by date/time

• Select the 3rd transaction of the user
Answered by AI
Add your answer
Q2. Find last quarter ordered product from logistics dataset
Ans. 
To find the last quarter ordered product from logistics dataset.
• Identify the date range for the last quarter

• Filter the dataset for orders within that date range

• Identify the product ordered in the last quarter
Answered by AI
Add your answer

Q1. Question on SQL self join
Ans. Written code for the same basis the problem given
Answered Anonymously
Add your answer
Q2. Basic questions on tableau and power bi
Add your answer

SQL Round

Q1. What are your salary expectations?
Add your answer
Q2. Salary Expectations and discussion about the salary
Add your answer

Q1. 1. First question was, from my project asked me that explain one project.
Ans. I have done three project, out of this three project one project was movie recommendation syatem. That i was explained. Then some counter question from project like how did you convert text to numerical, which technique you used here. I able to give all questions answer from project.
Answered by adventurouseggnog
Add your answer
Q2. 2. After they asked me, what is your subject preference?
Ans. My subject preference was NLP, Deep Learning, ML. Afrer that asked some question from NLP like what is term document matrix, tf-idf, word embedding, Gradient descent, why we have to change learning rate after every epoch, how lr change, precision recall.
Answered by adventurouseggnog
Add your answer
Q3. 3. My one projcet was sentimental analysis that was by LSTM model. So, next question was explain how LSTM model work and architecture .
Ans. Then I was explained workin flow of LST model and architecture. Then asked me did you know bidireectional LSTM. I said yes, then explained.
Answered by adventurouseggnog
Add your answer
Q4. 4. One question was from sql. what is the condition for primary key? last question one case business case study. this is all about my interview. My interview was 50 min and selected for HR round.
Add your answer

Q1. Phone call round, just asked me are you interested to come here.
Add your answer

Q1. Kubernetes and Docker
Add your answer

Leetcode hard level coding with 4-5 questions

Q1. Machine Learning algorithms, Statistics, NLP
Add your answer