The Product Analyst
Turning user behavior into product decisions, the way the best teams actually do it.
Reading guide
Full 14-chapter Product Analyst guide
Concepts, frameworks, and SQL, from first principles to interview room.
~100 min · 14 chapters
Read guideInterview Q&A
FreeTop 25 Product Analyst Interview Questions
Grouped by round, answered the way a senior analyst would say it.
SQL & data · Metrics & product sense · Analytical cases · Experimentation · Behavioral
Open Top 25 Q&ATable of contents
- 1
How to use this guide
~4 min read
- 2
1. What a Product Analyst actually does
~6 min read
- 3
2. Metrics, the heart of product analytics
~12 min read
- 4
3. SQL for product analysts
~10 min read
- 5
4. Funnels, cohorts & retention
~9 min read
- 6
5. A/B testing & experimentation
~11 min read
- 7
6. Product sense & diagnosing metric changes
~8 min read
- 8
7. Segmentation & understanding your users
~6 min read
- 9
8. Tools, instrumentation & data quality
~6 min read
- 10
9. Communicating insights & driving decisions
~6 min read
- 11
10. Landing the role, interview preparation
~7 min read
- 12
11. Worked case studies
~8 min read
- 13
Appendix A: ten principles to carry into the job
~3 min read
- 14
Appendix B: quick-reference glossary
~4 min read