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.
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?
Extracting Text Tags from Product Descriptions using Machine Learning
In the summer of 2019 I decided to enter the yearly company hackathon with a
project that had been brewing