ShareChat Senior Product Analyst Interview Questions and Answers

Sql questions- mainly around window functions and joins

How would you understand if suddenly order dropped by 20% for flipkart
Statistics questions as well

Q1. What is your current work experience, and can you provide a case study on how to improve monetization for Netflix?
Add your answer

Q1. Case Study - Favourite product
Add your answer

Q1. Introduction about myself
Add your answer
Q2. Case Study based on rider retention
Add your answer

Increase Gpay txns by 5x

Q1. RCA of 5% drop in google docs
Ans. 
The Root Cause Analysis (RCA) of a 5% drop in Google Docs usage.
• Investigate recent changes or updates to Google Docs that may have caused user dissatisfaction.

• Analyze user feedback and reviews to identify any common issues or complaints.

• Check for any technical issues or bugs that may be affecting the performance of Google Docs.

• Review competitor products to see if there are any new features or improvements that may have...read more
Answered by AI
Add your answer

How to make a order management system

Q1. What are the reasons for your decision to change your current role?
Add your answer

Q1. Product Sense and Data intuitive skills
Add your answer

Q1. Talk about your analytical experience in your previous job
Ans. 
I have extensive experience in analyzing product performance data to identify trends and opportunities for improvement.
• Utilized data analytics tools such as Excel, Tableau, and SQL to analyze product metrics

• Identified key performance indicators (KPIs) and tracked them regularly to measure product success

• Conducted A/B testing to evaluate the impact of product changes on user behavior

• Collaborated with cross-functional te...read more
Answered by AI
Add your answer

Case study on Netflix
Case study on building a time machine

Q1. Tell us about yourself
Add your answer
Q2. Tell us about your previous experience
Add your answer
Q3. What is the reason for change
Add your answer