Product Analyst Interview Questions

4,610 product analyst interview questions shared by candidates

Round 1 Part 2- Data interpretation and logical reasoning test on their website. There were 5 sets of DILR with 4-5 questions each set and time was allotted between 20-30 min for each set. The difficulty was similar to that of the CAT (Indian MBA entrance exam) or easier as more time was given to solve each set.
avatar

Product Analyst

Interviewed at Bending Spoons

4.7
Mar 23, 2023

Round 1 Part 2- Data interpretation and logical reasoning test on their website. There were 5 sets of DILR with 4-5 questions each set and time was allotted between 20-30 min for each set. The difficulty was similar to that of the CAT (Indian MBA entrance exam) or easier as more time was given to solve each set.

The business test was for you to explain marketing related decision for a product like Hello Fresh, then you had an ERD with some table and 8 SQL questions to answer with the code, and finally some questions related to AB testing decisions.
avatar

Junior Product Analyst

Interviewed at HelloFresh

3.3
Aug 5, 2019

The business test was for you to explain marketing related decision for a product like Hello Fresh, then you had an ERD with some table and 8 SQL questions to answer with the code, and finally some questions related to AB testing decisions.

6. Let's say you see data that looks at email sends by user state for a specific email: Dormant (not in last 30 days) 5% Core (DAU) 45% Casual (WAU) 30% Marginal (MAU) 15% Resurrected (wasn't in last 30 days, then came back as WAU) 5% The objective of email is to get people back to the site. What does this data tell you from a growth perspective? Are we under-sending to any user states?
avatar

Lead Business Analyst/Product Owner

Interviewed at Canva

3.9
Nov 28, 2017

6. Let's say you see data that looks at email sends by user state for a specific email: Dormant (not in last 30 days) 5% Core (DAU) 45% Casual (WAU) 30% Marginal (MAU) 15% Resurrected (wasn't in last 30 days, then came back as WAU) 5% The objective of email is to get people back to the site. What does this data tell you from a growth perspective? Are we under-sending to any user states?

Go through job description and the company website and their products. 1. Tell me about yourself. 2. Previous work tasks. 3. SDLC/ Product lifecycle. 4. Questions on whatever mentioned on your resume. 5. Strength/Weakness.
avatar

Product Operations Analyst

Interviewed at Akamai

4.3
Aug 10, 2018

Go through job description and the company website and their products. 1. Tell me about yourself. 2. Previous work tasks. 3. SDLC/ Product lifecycle. 4. Questions on whatever mentioned on your resume. 5. Strength/Weakness.

Q (Technical): A SQL question wherein I was provided with a table having Customer ID, Sales Amount, Transaction ID and Date. I was asked to aggregate them as Total sales, No. of unique customers and total transactions on a monthly basis. The follow-up question was building on this same problem, wherein I was asked to do the same aggregation, but now, for new and recurring users.
avatar

Product Analyst

Interviewed at BlackBuck

3.4
Nov 1, 2019

Q (Technical): A SQL question wherein I was provided with a table having Customer ID, Sales Amount, Transaction ID and Date. I was asked to aggregate them as Total sales, No. of unique customers and total transactions on a monthly basis. The follow-up question was building on this same problem, wherein I was asked to do the same aggregation, but now, for new and recurring users.

Viewing 281 - 290 interview questions

Glassdoor has 4,610 interview questions and reports from Product analyst interviews. Prepare for your interview. Get hired. Love your job.