Cohort and Retention Analysis in SQL: A Step-by-Step Guide
Cohort retention analysis in SQL, step by step: define cohorts, write the retention matrix query, read the triangle, and choose N-day or bracket retention.
WRITING / NOTES FROM THE FORGE
Data Analytics
5 articles tagged Data Analytics.
SQL Window Functions Explained With Practical Examples
SQL window functions explained with runnable examples: ROW_NUMBER vs RANK, LAG and LEAD, running totals, moving averages, and the ROWS vs RANGE frame trap.
How to Build KPI Dashboards People Trust: Metrics Layers Explained
Build KPI dashboards people trust with a semantic metrics layer: define metrics once, pick north star and input metrics, design clear views, and govern change.
A/B Testing Explained: A Practical Guide to Statistics for Product Teams
A/B testing explained for product teams: hypotheses, sample size and power, what p-values and confidence intervals really mean, peeking, SRM, and Python code.
Data Analyst vs Data Scientist vs Data Engineer: Roles, Skills, and Tools
Data analyst vs data scientist vs data engineer: what each role actually does, the skills and tools it needs, how they work together, and how to choose a path.