Sam Brand

SQL for Product Managers

Histograms with SQL

Copy / paste and run these code snippets to do your own exploratory data analysis with SQL.

Analysis

Retention / Churn Analysis with SQL

Cohort retention is one of the most valuable tools in an analyst's toolbox. Here are a couple sample queries to get you started.

SQL 101

How to use BigQuery

Follow these instructions to run your first query.

Best BigQuery Datasets

A list of the top 10 most useful datasets available to query for free through BigQuery.

SQL for Product Managers

Funnels with SQL

Don't build funnels in SQL. Unless you have to.

SQL 101

I Learned SQL at the School of Stack Overflow

SQL is a super power. It can change your career. It changed mine.

Why Learn SQL

SQL is for analysts. Everyone is an analyst.

Analysis

Case Study: Clipboard Health Lyft Pricing Exercise

Here is my answer to the Clipboard Health product case study. Can you find my mistake?

SQL 101

SELECT FROM WHERE - Basic SQL Queries

Start here to run your first SQL queries on free public datasets.