Data / Self-paced + live clinics
Analytics SQL for Product Teams
Funnels, cohort slices, and experiment readouts using disciplined SQL patterns.
Overview
Product analysts learn to write reproducible queries for weekly reviews. Scenarios include marketplace conversion drops and subscription churn with honest uncertainty callouts.
What is included
- Funnel reconstruction lab with edge-case users
- Cohort table design with survivorship bias discussion
- Experiment readout template avoiding p-hacking language
- Collaboration norms with data science partners
- Visualization handoff guidance for Metabase and Lightdash
- Office hours on communicating confidence intervals
- Ethical storytelling checklist
Outcomes you can show
- Deliver a funnel analysis memo with explicit filters.
- Produce a cohort chart SQL file plus plain-language summary.
- Run a mock review where you defend metric definitions.
Experience notes
“Cohort bias section in week three changed how I label charts—My Linh’s feedback on my memo was blunt in a useful way.”
FAQ
Do I need statistics coursework?
Basic averages and percentages suffice; we provide a primer on confidence without heavy math proofs.
BI tool required?
No. SQL output can be validated in any client; visualization modules are optional.
What is not covered?
We do not teach machine learning models; focus stays on transparent SQL reporting.