Projects

A few threads that best represent how I like to work.

This page highlights a smaller set of projects and recurring themes: reusable SQL patterns, maintainable analytics systems, and tooling that reduces unnecessary friction.

Data Analyst SQL Cookbook

A standalone project collecting practical SQL techniques and examples for day-to-day analytical work.

Date Range Grouping Techniques

Two posts on grouping overlapping and non-overlapping date ranges show the kind of query design problems I enjoy most.

Grouping overlapping date ranges
Grouping non-overlapping date ranges

Notes on Maintainable Warehouse Work

Posts on dbt patterns, query shape, and implementation details that make analytical systems easier to reason about.

dbt anti-pattern: using this
Micro-improvement for window functions

Connecting Tools and Workflows

Practical work on how analytical tools fit into modern platform stacks without turning everything into ceremony.

Connect to Fabric Lakehouse using R
Create date dimension

I Love DuckDB

Talks are where I compress a topic down to its clearest explanation and most useful examples.

DuckDB talk
All talks