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. We observe that a small chunk of users get a majority of orders on meesho. Is this a problem and how would you go about solving this?
Add your answer

Q1. There is a problem of duplicate listings on meesho where multiple sellers list the same item. This causes a problem as users' search results have the same item listed multiple times. How would you go about...read more
Ans. 
Implement a system to detect and merge duplicate listings on Meesho platform.
• Utilize machine learning algorithms to identify similar listings based on product attributes and images.

• Implement a manual review process to verify potential duplicates before merging them.

• Provide incentives for sellers to report and merge duplicate listings.

• Regularly monitor and update the system to adapt to new duplicate listing patterns.

• Com...read more
Answered by AI
Add your answer

Q1. You are the PM at meta. How would you decrease the number of fraud posts?
Ans. 
Implement stricter verification processes, utilize AI for detection, and increase penalties for fraudsters.
• Implement stricter verification processes for account creation

• Utilize AI algorithms to detect patterns of fraudulent behavior

• Increase penalties for users found to be posting fraudulent content
Answered by AI
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

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

How to increase rides for Uber - Business focused case.