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.
Refactoring SQL - Level 1
How to decompose SQL queries to make them easier to read, easier to maintain and debug.
How to Write Modular SQL
In this post we're going to learn one of the most important patterns in SQL: Modularity.
Exploring the ActivitySchema
A series of posts exploring data modeling via a single table called Activity Stream.
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.
How to Calculate Monthly Active Users (MAU) with SQL
Calculate MAU using simple SQL
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?
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
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
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