A Letter to the Community
For the foreseeable future, all in-person dbt events are cancelled. But we have some good stuff in the works.
dbt is four years old, and we are so grateful for the community that has grown alongside this project.
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.
Coalesce 2020, the first global conference for analytics engineers, will be held in NYC from August 20–21st. Tickets go on sale today. It’s going to be a very special event.
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.
The inability to bridge the chasm between IT and the business is the core dysfunction in modern data teams, and it’s also the biggest opportunity for progress.
With the dbt Integrated Developer Environment (IDE) you can orchestrate the entire analytics engineering workflow in your browser.
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.
The data team is a brand new thing: it’s not “IT”, it’s not finance, it’s not any of the typical business functions within an operating business. So...who does it report to? How does it interact with the rest of the organization? How big is it?
Analytics engineers provide clean data sets to end users, modeling data in a way that empowers end users to answer their own questions. Here are the market trends that gave rise to the newest role on modern data teams.
Meet Sagar Velagala, Operations Manager at Lola.com. He's a one-person analytics team at a fast-growing, ~100 person company. Here's the analytics strategy that underpins his success.
My love for group by 1, 2 developed when I was a fledgling analyst and has only grown. Even if you disagree, I hope this rant will inspire you to be more opinionated in your SQL style.
If your time is valuable, it should be important to you to operate with the highest possible leverage. This allows you to get more done with your fixed number of hours. Simple. Here's how analysts can operate with leverage.
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.
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.
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.
Modern data warehouses have upended the way that data teams function. Increasingly, companies are hiring a new kind of technical analyst to bridge the gap between data engineers and data analysts. Here's why and how you can hire one too.
Advice from analysts and data engineers at HubSpot, Managed by Q, GitLab, Wong Decision Intelligence, AskWonder, and Calogica
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.
The natural state of the universe is chaos: entropy tends to increase in closed systems, and there’s really nothing that we can do about that. So too is the nature of data warehouses: unless action is taken to maintain order.
dbt v0.14.0 lays the foundation for dbt Develop -- a query editor which leverages the brand new dbt server.
680 companies use dbt every week, 2100 members of dbt Slack, dbt Cloud processed 140k jobs from 200 accounts in June, and we're hosting regular dbt Meetups in 3 cities (NY, SF, London). What a year!
Holy crap! Within the past week we’ve seen the acquisitions of the two biggest players in the modern BI landscape, Looker and Tableau.
Unnesting arrays on Redshift is a pain, but it’s doable. This post walks through the entire process, start to finish.