Skip to content
Business Analytics
All courses OffersPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Product Analyst Interview Questions & Answers

40 questions for Product Analyst interviews — 1 easy, 37 medium, 2 hard.

About the Product Analyst role

A product analyst helps product teams decide what to build and whether it worked. Daily work includes defining metrics, building funnels and retention cohorts, analysing event data with SQL, and designing and reading A/B tests. Interviews focus on product sense, metric diagnosis such as why DAU dropped, experiment design and statistics basics, SQL with window functions and clear communication of findings to product managers and designers.

Funnel and cohort analysis A/B testing SQL window functions Metric design Product sense
Solved for this roleStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

Write an Excel formula for month-to-date sales up to today.

Excel for Business AnalystsMedium
Save to ▾
Show answer
// Dates in Sales[Date], amounts in Sales[Amount] =SUMIFS(Sales[Amount], Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1, Sales[Date], "<=" & TODAY()) // EOMONTH(TODAY(),-1)+1 gives the first day of the current month
02

What is user activation and what is an 'aha moment'?

Product AnalyticsMedium
Save to ▾
Show answer
Activation is the point at which a new user first experiences the product's core value, such as completing a first lesson, sending a first payment or creating a first project. The aha moment is the specific early action that strongly predicts long-term retention, found by comparing retained and churned users. Teams then design onboarding to get more new users to that action quickly and track the activation rate.
03

What do statistical significance and p-value mean in an A/B test?

Product AnalyticsMedium
Save to ▾
Show answer
The p-value is the probability of seeing a difference at least as large as observed if the change truly had no effect. If it is below the chosen threshold, often 0.05, the result is called statistically significant. It does not mean there is a 95 percent chance the variant is better, and significance is not the same as business importance. Always report the confidence interval of the lift as well.
04

An order has a value of 600 rupees, product cost 360, delivery 60, payment fee 12 and a discount of 50. What is the contribution margin?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Net revenue after discount is 600 minus 50, which is 550 rupees. Variable costs are 360 plus 60 plus 12, totalling 432. Contribution margin is 550 minus 432, so 118 rupees per order, or about 21 percent of net revenue. This is what each order contributes towards fixed costs such as salaries and rent. If the discount were raised to 150, the order would contribute only 18 rupees.
05

What does the LTV to CAC ratio tell you and what is a healthy value?

Business Metrics and KPIsMedium
Save to ▾
Show answer
LTV to CAC compares the lifetime gross profit from a customer with the cost of acquiring them. A ratio around 3 to 1 is commonly treated as healthy. Below 1 means you lose money on every customer. Far above 5 may mean you are underinvesting in growth. Always compute LTV on gross margin, not revenue, and check it by channel, because blended averages hide loss-making channels.
06

What is Customer Acquisition Cost (CAC) and what is CAC payback period?

Business Metrics and KPIsMedium
Save to ▾
Show answer
CAC is total sales and marketing spend in a period divided by new customers acquired in that period. If you spend 10 lakh and gain 2,000 customers, CAC is 500 rupees. CAC payback period is how many months of gross profit from a customer it takes to recover that CAC. A shorter payback means the business can reinvest faster; many subscription businesses aim for under 12 months.
07

Write a SQL query to get each customer's first order date and first order amount.

SQL for Business AnalysisMedium
Save to ▾
Show answer
WITH ordered AS ( SELECT customer_id, order_date, amount, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date, order_id) AS rn FROM orders ) SELECT customer_id, order_date AS first_order_date, amount AS first_order_amount FROM ordered WHERE rn = 1;
08

How are OKRs different from KPIs?

Business Metrics and KPIsMedium
Save to ▾
Show answer
KPIs are ongoing health measures of the business, like monthly revenue, churn or on-time delivery, tracked continuously. OKRs are a goal-setting method: an Objective is a qualitative ambition for a quarter, and Key Results are two to four measurable outcomes that show it was achieved. A KPI that is off track often becomes the subject of an OKR, for example 'reduce churn from 5 to 3 percent this quarter'.
09

What are fixed costs and variable costs?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Fixed costs stay constant regardless of volume, such as rent; variable costs change with volume, such as raw materials.
10

What is an event tracking plan and why does it matter?

Product AnalyticsMedium
Save to ▾
Show answer
A tracking plan is a document listing every event the product should log, such as 'checkout_started', with its trigger, properties like price, plan or source, naming rules and owner. It keeps data consistent across web, Android and iOS, prevents duplicate or vague events and makes analysis trustworthy. Without one, teams end up with events like 'click1' and 'buttonClick' meaning the same thing, and analysis becomes guesswork.
11

How do you validate that a report's numbers are correct?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Reconcile totals with source tables using SQL, check filters and joins for duplication, compare with prior periods and verify with business owners.
12

Write a SQL query that shows revenue per region with one column per quarter.

SQL for Business AnalysisMedium
Save to ▾
Show answer
SELECT region, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 1 THEN amount ELSE 0 END) AS q1, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 2 THEN amount ELSE 0 END) AS q2, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 3 THEN amount ELSE 0 END) AS q3, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 4 THEN amount ELSE 0 END) AS q4 FROM orders WHERE EXTRACT(YEAR FROM order_date) = 2026 GROUP BY region;
13

How do you analyse variance between budget and actual?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Variance = Actual - Budget, shown as amount and percentage, with conditional formatting to flag large gaps and comments on the drivers.
14

Describe a time you had to present disappointing numbers to leadership.

Business Metrics and KPIsMedium
Save to ▾
Show answer
Situation: a new city launch was 30 percent below its order target after two months. Task: present the review to the leadership team. Action: I opened with the number directly, then broke the gap into traffic, conversion and repeat rate, showing repeat rate was the main problem. I came with three options with estimated impact and cost. Result: leadership approved a focused retention campaign instead of more ad spend, and repeat rate rose over the next quarter.
15

What is a break-even point?

Business Metrics and KPIsMedium
Save to ▾
Show answer
The sales volume where total revenue equals total cost. It equals fixed cost divided by contribution margin per unit.
16

How would you measure the success of a new feature?

Product AnalyticsMedium
Save to ▾
Show answer
Define a goal metric, a baseline and guardrail metrics, run an experiment or before-after comparison and review adoption, retention and revenue impact.
17

What are leading and lagging indicators? Give examples.

Business Metrics and KPIsMedium
Save to ▾
Show answer
Lagging indicators measure outcomes after they happen, such as monthly revenue, profit or churn. They confirm results but are hard to influence directly. Leading indicators move earlier and predict outcomes, such as demo bookings, trial activations, cart additions or support ticket backlog. A good KPI set pairs them: a sales team tracks qualified pipeline (leading) along with closed revenue (lagging) so it can act before the quarter ends.
18

Prepare a simple cost-benefit analysis for automating invoice processing.

Financial and Business AnalysisMedium
Save to ▾
Show answer
Costs: software 12 lakh in year 1 plus 3 lakh per year support, and 4 lakh for implementation and training. Benefits: 60,000 invoices a year at 10 minutes saved each is 10,000 hours; at 400 rupees per hour that is 40 lakh, plus around 5 lakh from fewer late-payment penalties. Year-1 net benefit is 45 - 16 = 29 lakh and payback is under six months. Then test sensitivity, for example if only half the time saving is realised.
19

Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?

Product AnalyticsMedium
Save to ▾
Show answer
Quantify both effects: extra sessions and revenue from notifications versus users lost through uninstalls and notification opt-outs, including their lifetime value. Segment by notification type and frequency to find which ones annoy users. Recommend frequency caps, personalised timing, relevance rules and easy preference settings, then test them with uninstall rate and opt-out rate as guardrails. Short-term engagement should not cost long-term users.
20

How would you improve a company's low app conversion rate?

Product AnalyticsMedium
Save to ▾
Show answer
Map the funnel, find the biggest drop-off, check usability and load time, run A/B tests on fixes and track conversion lift.
21

What is a CTE?

SQL for Business AnalysisMedium
Save to ▾
Show answer
A named temporary result introduced with WITH that makes long queries readable and reusable in the same statement.
22

A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?

Financial and Business AnalysisMedium
Save to ▾
Show answer
Profit is an accrual figure, while cash depends on timing. Check working capital first: receivables may be growing because customers pay late, inventory may be piling up, or suppliers may be demanding faster payment. Then look at large capex, loan repayments, and dividends. Review the cash flow statement and compute days sales outstanding and inventory days over time. Fixes include tighter credit terms, collection drives, inventory reduction and renegotiating supplier terms.
23

What is feature adoption rate and how do you measure it?

Product AnalyticsEasy
Save to ▾
Show answer
Feature adoption rate is the share of eligible active users who used a feature in a period. For example, if 4,000 of 20,000 monthly active users used saved searches, adoption is 20 percent. Measure it against eligible users only, track first use and repeat use separately, and compare retention of adopters versus non-adopters. High first use with low repeat use often means the feature is discoverable but not valuable.
24

Write a SQL query to show cumulative revenue by month.

SQL for Business AnalysisMedium
Save to ▾
Show answer
WITH monthly AS ( SELECT DATE_TRUNC('month', order_date) AS month, SUM(amount) AS revenue FROM orders GROUP BY 1 ) SELECT month, revenue, SUM(revenue) OVER (ORDER BY month) AS cumulative_revenue FROM monthly ORDER BY month; -- add PARTITION BY EXTRACT(YEAR FROM month) to reset each year
25

Daily active users dropped 10 percent week over week. How do you investigate?

Product AnalyticsMedium
Save to ▾
Show answer
Rule out data issues first: tracking changes, app release bugs, pipeline delays or bot filters. Check whether the drop is seasonal by comparing with the same week last year or a festival calendar. Then segment by platform, app version, country or city, acquisition channel and new versus returning users to locate it. Look at the funnel for the core action. Connect findings to releases, outages or marketing changes, then recommend fixes.
26

What is the AARRR or pirate metrics framework?

Product AnalyticsMedium
Save to ▾
Show answer
AARRR breaks the customer lifecycle into five stages: Acquisition, how users find you; Activation, their first good experience; Retention, whether they come back; Referral, whether they recommend you; and Revenue, whether they pay. Each stage gets one or two metrics, such as sign-ups by channel, activation rate, Day-30 retention, invite rate and conversion to paid. It helps find which stage is the weakest bottleneck.
27

A KPI on your dashboard dropped 40 percent overnight. What are your first steps?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Assume a data problem until proven otherwise, because real businesses rarely move 40 percent in a day. Check whether the refresh completed, whether source row counts look normal, and whether any tracking, pipeline or definition changed. Compare with a raw source query and a related metric, such as orders versus payments. If the data is fine, segment by channel, region and platform to locate the drop, then alert the owners quickly.
28

A feature launched two months ago is used by only 4 percent of users. What would you do?

Product AnalyticsMedium
Save to ▾
Show answer
Find out whether it is a discovery problem or a value problem. Check how many users saw the entry point, how many tried it and how many returned. If few saw it, test better placement or onboarding prompts. If many tried and few returned, interview users and review session recordings to understand why. Also check if the 4 percent are high-value users. Then decide to improve, reposition or remove it.
29

Explain Porter's Five Forces.

Case Studies and GuesstimatesMedium
Save to ▾
Show answer
A model assessing industry attractiveness through supplier power, buyer power, threat of new entrants, threat of substitutes and rivalry among competitors.
30

What are guardrail metrics in experiments?

Product AnalyticsMedium
Save to ▾
Show answer
Guardrail metrics are measures that must not get worse while you try to improve the primary metric. For a test aimed at increasing conversion, guardrails might be refund rate, page load time, unsubscribe rate and customer support tickets. If the primary metric improves but a guardrail drops significantly, the change is not shipped as is. They protect long-term health from short-term optimisation.
31

Tell me about a time your analysis changed a product decision.

Product AnalyticsMedium
Save to ▾
Show answer
Situation: the team planned to add more filters to the search page to fix low conversion. Task: I was asked to size the opportunity. Action: funnel analysis showed most drop-off happened after users opened a product page with no delivery date shown, not in search. I shared the data with session recordings. Result: the team prioritised showing delivery dates on the product page, conversion rose about 8 percent, and the filter work was deprioritised.
32

What is the difference between ROW_NUMBER, RANK and DENSE_RANK?

SQL for Business AnalysisMedium
Save to ▾
Show answer
All three number rows within a window ordered by a column. ROW_NUMBER gives a unique sequence 1, 2, 3 even for ties. RANK gives ties the same number and then skips, so 1, 1, 3. DENSE_RANK gives ties the same number without gaps, so 1, 1, 2. Use ROW_NUMBER to pick exactly one row per group, such as the latest order, and DENSE_RANK for 'top 3 distinct salary levels' type questions.
33

Describe a time you explained a complex technical topic to a non-technical audience.

Stakeholder CommunicationMedium
Save to ▾
Show answer
Situation: operations managers did not trust a new demand forecast that drove staffing. Task: explain it so they would use it. Action: I avoided model terms and showed how it used last year's same week, recent trend and festival calendar, with a chart of past forecasts against actuals. I compared the forecast range to a weather forecast. Result: managers started using it for rosters and gave feedback that improved it further.
34

How do you validate data before analysis?

SQL for Business AnalysisMedium
Save to ▾
Show answer
Check row counts against the source, nulls, duplicates on keys, value ranges, date coverage and that totals reconcile with finance reports.
35

What is the difference between OLTP and OLAP systems?

SQL for Business AnalysisMedium
Save to ▾
Show answer
OLTP handles many small day-to-day transactions; OLAP supports analysis over large historical data with aggregates and reporting.
36

The CEO wants one KPI to judge the customer support team. What would you propose?

Business Metrics and KPIsMedium
Save to ▾
Show answer
A single KPI can be gamed, so I would propose one headline with guardrails. The headline could be first-contact resolution rate, because it reflects solving problems, not just closing tickets. Guardrails would be customer satisfaction score after the ticket and median first response time. I would also watch ticket volume per thousand orders, which shows whether product issues are falling. Review targets quarterly with the support head.
37

Tell me about a time a SQL query you wrote gave wrong results. How did you catch it?

SQL for Business AnalysisMedium
Save to ▾
Show answer
Situation: my weekly sales report showed a 12 percent jump that no one could explain. Task: verify the number before it reached leadership. Action: I compared row counts before and after each join and found a new promotions table had multiple rows per order, duplicating revenue. I aggregated promotions per order first and added a test comparing totals with the source. Result: the corrected report went out the same day, and I now check grain on every new join.
38

What is the logical order in which a SQL SELECT query is executed?

SQL for Business AnalysisHard
Save to ▾
Show answer
Logically the database processes FROM and JOIN first, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY and finally LIMIT or TOP. This explains common errors: you cannot use a SELECT alias in WHERE because WHERE runs earlier, aggregate conditions must go in HAVING, and window functions cannot be filtered in WHERE, so you wrap them in a CTE or subquery. The optimiser may physically reorder steps, but the result follows this order.
39

Marketing and product teams define 'active user' differently and report conflicting numbers. How do you fix this?

Business Metrics and KPIsHard
Save to ▾
Show answer
Bring both teams together and list each definition, its purpose and its numbers. Agree on one company-wide definition tied to real value, such as a user who completed a core action in the last 7 days, and allow clearly named secondary metrics like 'visitors' for marketing. Assign an owner, document it in a metric glossary, implement it once in the warehouse or semantic model, and retire the duplicate dashboards.
40

A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?

UAT and BA DocumentationMedium
Save to ▾
Show answer
Go back to the requirement and acceptance criteria. If the system matches the agreed requirement, the developer is right, and the business need is a change request. If the requirement is unclear or the design misread it, it is a defect, and the requirement wording should be fixed. Discuss it in triage with both parties, using examples. Either way, close the loop with the tester so they understand the outcome and keep trusting the process.

Frequently asked questions

What does a Product Analyst do?

A product analyst helps product teams decide what to build and whether it worked. Daily work includes defining metrics, building funnels and retention cohorts, analysing event data with SQL, and designing and reading A/B tests. Interviews focus on product sense, metric diagnosis such as why DAU dropped, experiment design and statistics basics, SQL with window functions and clear communication of findings to product managers and designers.

Which skills are tested in a Product Analyst interview?

Expect questions on Funnel and cohort analysis, A/B testing, SQL window functions, Metric design, Product sense. Most rounds also ask you to explain a project and solve one practical problem live.

How do I prepare for a Product Analyst interview?

Revise Product Analytics, SQL for Business Analysis, Business Metrics and KPIs first using the topic sheets, practise the questions on this page aloud, then do one full mock interview to practise timing.

Topic sheets for this role

Product Analytics questionsSQL for Business Analysis questionsBusiness Metrics and KPIs questions

Other roles

Business AnalystIT Business AnalystOperations AnalystBusiness Analyst InternSenior Business AnalystProduct OwnerFunctional Consultant

More ways to practise

Company-wise Business Analytics questionsPackage-wise Business Analytics questionsExperience-wise Business Analytics questionsRole-wise Business Analytics questionsCity-wise Business Analytics questionsMost asked Business Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsBusiness Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsBusiness Analytics topic sheets