Analytics engineering blog · Notebook
Clean models,honest numbers.
Essays on SQL, dbt and metrics people can trust, a public notebook of 300 linked notes, and a book on SQL patterns, written in the open. I am Tanvi, an analytics engineer writing here since 2019.
click a node to jump in · a new essay every other Sunday
Where to start
The blog
Long essays on data modelling, metrics layers and the craft of analytics engineering.
read latestThe notebook
300 short, linked notes: SQL tricks, dbt patterns, tools I use and books I read.
enter notebookSQL patterns
A glossary of window functions, joins and anti-patterns, each with a runnable example.
open patternsThe book
SQL Patterns for Analysts, free to read online while I write it.
open book
Latest from the blog
all essays- Oct 12, 2026Your metrics layer is a contract, not a cache
- Sep 28, 2026Why every join deserves a test
- Sep 14, 2026Incremental models without the regret
- Aug 31, 2026Naming things in a warehouse
- Aug 17, 2026A year of dbt at a 40-person company
- Aug 03, 2026Window functions I use every week
- Jul 20, 2026Dashboards are the last mile, not the road
- Jul 06, 2026Interview: how a fintech team reviews SQL
Stay updated with my newsletter
Two emails a month: the new essay, three notes worth reading and one SQL trick. No spam, unsubscribe any time.
Or follow along by RSS, LinkedIn or GitHub.
Work in progress
SQL Patterns for Analysts
- Free to read online
- New chapter every month
- Every query runs in DuckDB
Analytics engineer, writer and teacher