Skip to main content
Back to course
Log in
Get started
Someone wanted to learn this too, so Grasp built them a personal learning path.
Create your own
SQL for product designers
ยท
Module 4
Calculating Core Product Metrics
1
Counting with COUNT()
Use COUNT() to calculate totals, such as the number of signups or daily active users.
Use COUNT() to calculate totals, such as the number of signups or daily active users.
2
Calculating Summary Statistics with Aggregate Functions
Use AVG(), SUM(), MIN(), and MAX() to calculate summary statistics for user behavior.
Use AVG(), SUM(), MIN(), and MAX() to calculate summary statistics for user behavior.
3
Analyzing Metrics with GROUP BY
Group aggregated data using GROUP BY to analyze metrics across different segments (e.g., by country, by device type).
Group aggregated data using GROUP BY to analyze metrics across different segments (e.g., by country, by device type).
4
Aggregating Joined Data
Combine joins with aggregate functions to calculate cross-table metrics (e.g., average events per user).
Combine joins with aggregate functions to calculate cross-table metrics (e.g., average events per user).
5
Filtering Grouped Data with HAVING
Filter grouped data using HAVING to find segments that meet certain criteria (e.g., features used by more than 100 users).
Filter grouped data using HAVING to find segments that meet certain criteria (e.g., features used by more than 100 users).
End of course,
Back to course
Previous module
Connecting Product Data with Joins
Next module