SQL Window Functions for Real Product Analytics
ROW_NUMBER, RANK, LAG, LEAD and running totals—with real product analytics examples.
SQLProduct Analytics8 min read
Writing
Educational articles about SQL, product metrics, statistics, ML and MLOps through concrete decisions.
ROW_NUMBER, RANK, LAG, LEAD and running totals—with real product analytics examples.
How to define and interpret engagement metrics in the context of product decisions.
How to use Population Stability Index as contextual evidence alongside performance and business metrics.
How p-values and confidence intervals inform evidence without making the product decision for you.
External writing
Verified profile; no invented article-level links.