How-To

dbt Labs has added two more courses to its library of free resources for the emerging analytics engineer. Those new to dbt will find everything...

This piece is about how direct collaboration with engineers for event tracking is the best axe to wield in product analytics, and how our data...

dbt Labs recent underwent a massive overhauling of our OKR framework. Erica Louie, Head of Data, shares how we think about OKRs and a solution...

This playbook dives into how dbt Labs thinks and implements reverse ETL workflows for our internal analytics work.

Four modules designed to help the established analytics engineer plan for rapid growth.

Four modules of curated Coalesce content for teams just beginning their analytics engineering journey.

A startup's guide to modeling data following Kimball best practices

This article is written for job seekers. I’ve gathered a lot of data over the course of a month-long search and learned about what the...

A holistic data testing framework to help you catch data quality issues before they impact your stakeholders.

Marketing attribution has long been one of the stickiest problems in analytics. But with raw data, SQL, and dbt a previously complex problem can become...

If you’re a data analyst at a SaaS company or an ecommerce business with a subscription component, it is inevitable that you will be asked...

Analytics code is code. Which means that it will have bugs. And without rigorous processes in place to find and eliminate those bugs, code quality...

Data teams are successful when they build reserves of trust. One important way to build trust is by consistently delivering projects on time. Here are...

All data analysts have faced the problem–how do I model data when the record in the data warehouse keeps changing? In this post, I'll cover...

Version control is a critical part of the software engineering workflow, but for many analysts, writing and reviewing pull requests is still a relatively new...

Stephen Whitworth, Data Engineering Lead at Monzo, spoke at the London dbt Meetup a few weeks ago. Here are my thoughts on his talk and...

Unnesting arrays on Redshift is a pain, but it’s doable. This post walks through the entire process, start to finish.

I just went through the process of converting 25,000 lines of SQL from Redshift to Snowflake. Here are my notes.

If you’re a hotshot junior analyst and you want a guide for breaking through this skills plateau, this guide is for you.

This is a very stupid problem. I am not writing this post because it’s a fascinating topic—rather, I’m writing it in the hopes that you...

I got this question on my last post. It is a good one, and one that I’ve gotten a bunch of times over the past...