SQL for Product Managers
Steal these queries. They can help you do your job.
Sentiment Analysis & Natural Language Processing
- How to use BigQuery & SQL to classify user feedback with the Natural Language API and Gemini.
- How to use local LLMs to do NLP on sensitive data.
Histograms with SQL
Funnels with SQL
- Mixpanel and Google Analytics are awesome. But you'll never get intimate with the data flowing beneath your tools until you learn how to reproduce funnels in SQL. Here's how to reproduce funnels with SQL.
Retention & Churn with SQL
- Retention is a force multiplier to grow and sustain a successful product. Use this code to visualize cohort activation, retention, and churn.
Don't see what you're looking for? Reach out and let me know what else I should write about.