SQL-FUNDAMENTALS5 MIN READ
Commit to a grain check
Create a concrete commitment to state and verify query grain.
A GROUP BY, revenue, conversion, or retention query that will be shared with another person this week. When I write or review this query, I will add a grain comment in the form: -- grain: one row per ___ per ___. Then I will run one check that compares the expected number of groups to the actual number of result rows. In 3 days, check whether you used the drafted SQL action and whether it changed the query result, review comment, or metric confidence. A dashboard query using COUNT, SUM, or GROUP BY that others rely on this week. A…
Read the full lesson
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in