Data Engineering Articles
Pipelines, warehouses, and the plumbing that makes data trustworthy. dbt, Snowflake, BigQuery, ELT patterns, and how to scale infra without runaway costs.
The BCG matrix was published in 1970. By 2023 it has outlived the typewriter, the fax machine, the original Star…
Every consulting engagement that starts with “our growth team and our finance team are looking at the same dashboard and…
LTV is the metric most likely to get a senior data person fired, in either direction. Report a number that’s…
The first time I built a waterfall chart was in 2014 for an e-commerce market sizing deck. The client wanted…
Database normalization is the discipline of structuring tables so each fact lives in exactly one place. Skip it and you…
Outliers are the points that make summary statistics lie to you. A single trailing zero in a data entry turns…
The YouTube Data API is the cheapest way to pull a structured table of every video on a public channel,…
The Health app on iOS quietly records about thirty metrics a day from the phone alone, and another forty if…