Money View Production Analyst Interview Questions and Answers

Would give data and stats and tell us to interpret or metric

Q1. Case Study of zomato ?
Add your answer
Q2. Some basic math questions. Simultaneous equations .
Add your answer

Q1. Tell me brief about your self
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets using SQL, Python, and R

• Skilled in creating insightful reports and dashboards using Tableau and Power BI

• Strong communication skills to present findings to stakeholders

• Certified in data analysis and machine learning techniques
Answered by AI
Add your answer
Q2. What are youre strenth and weekness
Ans. 
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Getting caught up in details (provide example)
Answered by AI
Add your answer

Q1. What is your aim
Add your answer
Q2. Tell us your experience in college
Add your answer

Online test on Hackerrank 7 questions in 120 minutes. 4 questions were easy last 3 were mainly focused on Retention and retained user definition that was too specific to the cred use case.

Q1. You are PM of Netflix what will be the top 3 metrics you will look at and why?
Ans. 
The top 3 metrics I would look at as the PM of Netflix are subscriber growth, user engagement, and content performance.
• Subscriber growth: This metric indicates the success of Netflix in acquiring new customers and expanding its user base. It helps measure the effectiveness of marketing strategies and the overall popularity of the platform.

• User engagement: This metric measures how actively users are interacting with the...read more
Answered by AI
View 3 more answers
Q2. Differentiate between row number and dense rank?
Ans. 
Row number is a sequential number assigned to each row, while dense rank assigns a unique rank to each distinct value.
• Row number is assigned in sequential order to each row in a result set.

• Dense rank assigns a unique rank to each distinct value in a result set.

• Row number is not affected by ties, while dense rank is affected by ties.

• For example, if there are two rows with the same value in a dense rank, they will both r...read more
Answered by AI
Add your answer
Q3. Find out the total time spent by the employees if you have the data for their sign-in and sign-out.
Ans. 
To find the total time spent by employees, calculate the difference between sign-in and sign-out times for each employee and sum them up.
• Iterate through the data for each employee

• Calculate the time difference between sign-in and sign-out for each employee

• Sum up the time differences to get the total time spent by all employees
Answered by AI
Add your answer
Q4. You have country name rank the names so that one particular company comes on top always
Add your answer

Q1. Swiggy revenue is dropping in the last 3 months. Do and RCA as an analyst. What are all the different things you will look at?
Add your answer

Aptitude tests + 3 Rounds

First round of test consisted of sql questions , medium and easy level

Q1. Mostly sql questions like cumulative sum
Add your answer

Q1. This interview was more focused on the decision making in different scenarios
Add your answer

Sql mainly windows function aggregate function

How would you imprpve netflix recommendation system.

Q1. Some stat question
Add your answer