How-To

Kyle Coapman | Laurent Goldsztejn 4 Nov 2022 November 4, 2022 Kyle Coapman, Laurent Goldsztejn

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 they need to get started (and badged!) in our dbt Learn Fundamentals course, while seasoned users can now go deeper on topics like advanced testing and deployments before sitting for the dbt Certification Exam.

Andrew Escay | Kira Furuichi 1 Aug 2022 August 1, 2022 Andrew Escay, Kira Furuichi

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 team went about benchmarking IDE performance.

Erica Louie | Kira Furuichi 5 Jul 2022 July 5, 2022 Erica Louie, Kira Furuichi

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 to measuring them that works for us.

Brandon Thomson | Kira Furuichi 28 Jun 2022 June 28, 2022 Brandon Thomson, Kira Furuichi

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

Lauren Craigie 21 Dec 2021 December 21, 2021 Lauren Craigie

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

Lauren Craigie 21 Dec 2021 December 21, 2021 Lauren Craigie

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

Andrea Fabry 17 Sep 2020 September 17, 2020 Andrea Fabry

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

Danielle Leong 25 Jun 2020 June 25, 2020 Danielle Leong

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 landscape looks like for the analytics engineer hiring pipeline.

Andrea Fabry 18 Jun 2020 June 18, 2020 Andrea Fabry

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

Claire Carroll 16 Mar 2020 March 16, 2020 Claire Carroll

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 beautifully simple.

Claire Carroll 17 Jan 2020 January 17, 2020 Claire Carroll

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 to analyze metrics like churn, upgrades, and downgrades. Here's how to do this with dbt.

Erin Vaughan | Janessa Lantz 7 Jan 2020 January 7, 2020 Erin Vaughan, Janessa Lantz

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 will degrade over time.

Tristan Handy 17 Sep 2019 September 17, 2019 Tristan Handy

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 four questions we've found to be useful in helping us spot the potholes that derail analytics engineering projects.

Claire Carroll 10 Sep 2019 September 10, 2019 Claire Carroll

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 how to solve this using dbt snapshots.

Erin Vaughan 5 Sep 2019 September 5, 2019 Erin Vaughan

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 habit. Here's a checklist we use to review analytics PRs.

Claire Carroll 22 Jul 2019 July 22, 2019 Claire Carroll

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 what the dbt community can learn from it.

Tristan Handy 14 May 2019 May 14, 2019 Tristan Handy

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

Tristan Handy 13 Jun 2018 June 13, 2018 Tristan Handy

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

Jason Ganz 8 Apr 2018 April 8, 2018 Jason Ganz

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

Tristan Handy 16 Mar 2018 March 16, 2018 Tristan Handy

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 avoid the headaches I've gone through.

Tristan Handy 29 Jan 2018 January 29, 2018 Tristan Handy

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 year and a half. This post is my attempt to answer it.

Tristan Handy 16 Jan 2018 January 16, 2018 Tristan Handy

dbt and Looker were built with the same ethos: analysts should be working in code.