Q1
Walk me through how you would design a dashboard to track user engagement metrics for a SaaS product. What metrics would you prioritize, and which visualization tools would you use?
Why they ask this:* They want to assess your ability to translate business objectives into analytical frameworks, select appropriate KPIs, and communicate insights through visualization—core competencies for a Product Analyst.
Q2
Describe your experience with SQL. Write a query that would identify users who made a purchase in the last 30 days but haven't returned in the past 7 days, and explain how you'd use this cohort analysis in product decision-making.
Why they ask this:* SQL proficiency is essential for mid-level analysts who need to independently query databases and perform cohort analysis to inform product recommendations without relying on engineers.
Q3
How do you approach A/B test design and statistical significance? Walk through an example where you'd set up an experiment to test a new onboarding flow, including sample size calculation and success metrics.
Why they ask this:* This tests foundational knowledge of experimental design and statistical rigor—critical for ensuring product decisions are data-driven and not based on noise or bias.
Q4
Explain the difference between correlation and causation. Give a product example where you observed a correlation that wasn't causal, and how you validated the true relationship.