Easy everything in Product Management, page 9
Track an 'Export to CSV' button's usage and outcomes
This tests your ability to design a robust event schema, not just track a click. A great answer uses one custom event name with a 'status' parameter ('initiated', 'success', 'failure'). A red flag is suggesting multiple event names for one action.
Track a user event from frontend code to a BI tool
Tests your understanding of the modern data stack. A good answer traces the event from frontend capture, through an ingestion pipeline, into a data warehouse, and finally to a BI tool for analysis. A red flag is describing only one part of the journey.
How would you capture and persist UTM parameters for attribution?
Tests your grasp of state management and data persistence for analytics. A good answer covers capturing UTMs with JS, persisting them in a cookie, and associating them with a user record on the server during a conversion event.
Describe the client-side event for an 'Add to Cart' button
This tests your ability to design analytics events for future analysis. Name a standard event like add_to_cart and list item parameters (item_id, price, quantity).
How would you measure a sales forecast model's accuracy?
This tests your ability to connect statistical metrics to business impact. A great answer defines MAE (linear error cost) and RMSE (penalizes large errors), explains the choice depends on business context, and stresses using a test set.
Describe EDA for a 3-year daily user sign-up dataset.
Tests your structured approach to time series EDA. A good answer identifies trend, seasonality, and anomalies before modeling. A red flag is jumping to forecasting models or only mentioning the overall average growth, ignoring cyclical patterns.
How would you A/B test a 'Buy Now' button color change?
This tests structured thinking. A good answer defines a hypothesis, selects primary and guardrail metrics, and outlines the experiment's duration and analysis plan. A red flag is focusing only on clicks without considering business impact.
What does a p-value of 0.03 mean in an A/B test?
Tests your practical statistical literacy. A good answer defines the p-value (3% chance of this result if the null is true), compares it to alpha (0.03 < 0.05) to reject the null, and decides to ship.
Mean vs. Median for API Response Times?
Tests if you know latency data has outliers. A good answer chooses median because it's robust to extremes. Explain that mean gets skewed by a few slow requests (e.g., GC pauses), hiding the typical user experience.
Is 20% higher retention from Feature X causal or correlational?
This tests your ability to distinguish correlation from causation. A great answer questions the data, identifies confounding variables (e.g., power users), and proposes a randomized A/B test as the gold standard to prove causality.
DAU dropped 10%. What user segments do you investigate first?
Tests your systematic problem-solving. First, clarify the metric and timeline. Then, segment by platform, geography, and user tenure (new vs. returning). A red flag is jumping to external causes before ruling out internal issues like a bad deployment.
Bar Chart vs. Line Chart for Market Share Comparison?
Tests basic chart selection: comparing static categories vs. showing trends. A bar chart is correct for comparing discrete companies at one point in time. A line chart wrongly implies a time-series relationship. Red flag: choosing a line or pie chart.
When is a pie chart an appropriate choice for visualization?
Tests data viz principles for part-to-whole data. A good answer defines this use case, gives a clear example (market share), and lists pitfalls like too many slices or similar values. A red flag is defending them for complex data or time-series analysis.
Why use p50/p95 over mean for API response times?
Tests your grasp of statistical distributions for UX metrics. A good answer explains how outliers skew the mean, while percentiles (p50, p95) better represent typical and worst-case user experiences.
What is a data schema and why enforce it on ingestion?
This tests your grasp of data governance. Define a schema as a data blueprint. Explain that enforcement on ingestion prevents "garbage in, garbage out" by validating types and formats, ensuring data is usable for analytics.
How would you validate user-submitted email addresses at ingestion?
Tests your understanding of data validation beyond simple regex, focusing on robustness and system-level thinking. A good answer covers format checks, DNS/MX record validation, and blocking disposable services.
How would you handle 10% nulls in a key column?
This tests your ability to diagnose data issues before solving. First, investigate why data is null. Then, discuss trade-offs of dropping vs. imputing with the mean or median, considering the impact on the dashboard's accuracy.
What is a data warehouse vs. a transactional database?
Tests your grasp of read-optimized (OLAP) vs. write-optimized (OLTP) systems. A great answer defines warehouses for analysis, contrasts them with transactional DBs for operations, and explains the resulting differences in workload, schema, and data structure.
Build a pipeline to load CSVs into a database
Tests your grasp of event-driven architecture and basic ETL. A good answer outlines a trigger (storage event), a processing function (serverless), and a destination (database), mentioning error handling. A red flag is describing a manual or cron-based process.
ETL vs. ELT: Key differences and when to use each?
This tests your understanding of modern data architecture trade-offs. A good answer explains the T vs. L order, then links ETL to structured, legacy systems and ELT to flexible, cloud-native data lakes/warehouses.
We are hiring for this. Every open role lists the topics its interview covers, so you can prepare for the real thing rather than guessing.
See open roles