Codifying Timeless Patterns in Data and Business

Latest

Dec
31
How to Model Data by Refactoring SQL - Level 2

How to Model Data by Refactoring SQL - Level 2

How to model data by refactoring SQL queries across multiple dbt models to make them easier to read, maintain and debug.
4 min read
Dec
11
Refactoring SQL - Level 1

Refactoring SQL - Level 1

How to decompose SQL queries to make them easier to read, easier to maintain and debug.
3 min read
Dec
11
How to Write Modular SQL

How to Write Modular SQL

In this post we're going to learn one of the most important patterns in SQL: Modularity.
6 min read
Jul
11
Exploring the ActivitySchema

Exploring the ActivitySchema

A series of posts exploring data modeling via a single table called Activity Stream.
11 min read
Apr
26
Why Analytics Engineering is Here to Stay

Why Analytics Engineering is Here to Stay

While the title Analytics Engineer is relatively new, the role has always existed in one way shape or form. This is why I believe it’s here to stay.
2 min read
Dec
13
How to Calculate Monthly Active Users (MAU) with SQL

How to Calculate Monthly Active Users (MAU) with SQL

Calculate MAU using simple SQL
3 min read
Aug
26
Celebrate Your Data Analysts - Before It's Too Late

Celebrate Your Data Analysts - Before It's Too Late

Data analysts are quitting their jobs in masse because they feel they have no impact. What can you do to change things before it's too late?
5 min read
Mar
19
How I Learned Data Science in 90 Days

How I Learned Data Science in 90 Days

I first encountered data science (aka data mining, machine leaning, artificial intelligence, etc) back in 2014. I was a newly
4 min read
Mar
18
Learning Strategy from First Principles - A Review of Wardley Maps

Learning Strategy from First Principles - A Review of Wardley Maps

What's the first thing that comes to mind when you think about the word strategy? If you’re
9 min read
Mar
18
The Data Executive Playbook: How to use Wardley Maps to Determine Strategy in Modern Organizations

The Data Executive Playbook: How to use Wardley Maps to Determine Strategy in Modern Organizations

This blog post is an exploration of strategic play inside an organization viewed through the lens of a hypothetical data
6 min read