How to use this guide

The Product Analyst is the person who tells a product team what is really happening and why. Not vanity dashboards, the analyst who can define the right metric, catch when it moves, design the experiment that proves a cause, and turn that into a decision a PM acts on. This guide takes you from first principles to the interview room.

Each chapter follows the same rhythm: the idea in plain language, why it matters on the job, worked examples and SQL, and interview-grade practice. A separate companion (the Top 25) collects the interview questions with full mentor answers.

The product analyst's loop#

Every chapter maps onto one motion: define what 'good' means → instrument and measure it → detect and diagnose change → experiment to find what works → communicate so the team acts. Master that loop and the tools become details.

What you should already know#

This guide assumes you can write basic SQL, SELECT, WHERE, JOIN, GROUP BY, and are comfortable with percentages and averages. If you're not there yet, start with the Data Analyst guide first; it builds those foundations. Everything specific to product analytics, events, funnels, cohorts, retention, experimentation, product sense, is taught here from the ground up.