The Modern Cloud Warehouse Modeling Guide
A field guide to trustworthy analytical SQL models.
Grain, fan-outs, SCD2 joins, nested data, deduplication, incremental drift, tests, review contracts, and runnable BigQuery exercises.
Pipeline Patterns is about how analytical data systems actually work — and how to use that understanding to build pipelines you can trust and decompose the legacy ones you can't.
Resources
Start with the guide if you want the modeling judgment. Use the table tool when you need clean visuals for teaching, documentation, or posts.
A field guide to trustworthy analytical SQL models.
Grain, fan-outs, SCD2 joins, nested data, deduplication, incremental drift, tests, review contracts, and runnable BigQuery exercises.
Turn plain tables into crisp branded images.
Paste CSV, TSV, or markdown-style tables and export clean PNG visuals for Substack, LinkedIn, Medium, and teaching materials.
Teaching
Speaking
Mechanism-first sessions for analysts, data engineers, and technical business teams.
Each session is built around one idea in depth: what the system does, why it behaves that way, and what changes in practice once the mechanism is visible.
Speaking detailsYouTube
Short video explanations for data people who want the mechanism, not just the tool.
Pipeline Patterns is about how analytical data systems actually work — and how to use that understanding to build pipelines you can trust and decompose the legacy ones you can't.
Subscribe
New essays are published on Substack, where you can read, subscribe, and get future pieces by email.