CRED Senior Product Analyst Interview Questions, Process, and Tips

Orders related assignment which focused on SQL Joins, Group by, and ranked window functions

Q1. Previous experience as per resume. Deepdive on one of the recent projects
Add your answer
Q2. Guesstimate - Number of cars sold in India in a day
Ans. 
Approximately 20,000 cars are sold in India in a day based on industry estimates.
• Consider the total annual car sales in India and divide by 365 days

• Take into account the population of India and the percentage of people who own cars

• Factor in the popularity of car brands and types in the Indian market
Answered by AI
Add your answer
Q3. Puzzle - Coins valued from 1 to 100. How will you distribute equally between 10 people
View 1 more answer

Q1. In-depth understanding of recent project
Add your answer
Q2. Case interview - Whatsapp launched a new feature "Groups". How would you measure the success / failure of the feature? What metrics would you use?
Add your answer

SQL and metrics based questions

Q1. How would you find the top triplet from data set
Ans. 
To find the top triplet from a data set, sort the data in descending order and select the first three values.
• Sort the data in descending order

• Select the first three values

• Consider ties if applicable
Answered by AI
Add your answer
Q2. Questions around the aptitude test
Add your answer

Q1. Top Metrics for Instagram platform
Ans. 
Top metrics for Instagram platform include engagement rate, reach, impressions, follower growth, and click-through rate.
• Engagement rate measures the level of interaction with your content.

• Reach refers to the number of unique accounts that have seen your content.

• Impressions refer to the total number of times your content has been viewed.

• Follower growth measures the rate at which your follower count is increasing.

• Click-t...read more
Answered by AI
Add your answer
Q2. How would you find the batsmen with fastest 5000 runs
Ans. 
To find the batsmen with fastest 5000 runs, we need to analyze the data of all the batsmen who have scored 5000 runs or more.
• Create a database of all batsmen who have scored 5000 runs or more in their career.

• Sort the database based on the time taken by each batsman to reach 5000 runs.

• Identify the batsman who reached 5000 runs in the shortest time.

• Verify the accuracy of the data and the methodology used to calculate the...read more
Answered by AI
Add your answer
Q3. Which is better. 5% discount to get 30% increase in trips or 10% discount to get 50% increase in trips or 15% discount to get 65% increase in trips, considering avg trip value is constant
Ans. 
15% discount to get 65% increase in trips is the best option.
• The percentage increase in trips is directly proportional to the discount offered.

• The increase in trips should be weighed against the decrease in revenue due to the discount.

• In this case, the 15% discount offers the highest increase in trips while still maintaining a reasonable revenue.

• It is important to consider the long-term effects of offering discounts on
Answered by AI
Add your answer