A Letter to the Community
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.
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.
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.
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.
Thoughts on pricing strategy and what it communicates about your company's vision for the future of the market you're in.
Sinter just became dbt Cloud. Why the re-brand?
The role of the data engineer in a startup data team is changing rapidly. Are you thinking about it the right way?
The hardest thing about scaling a company is communication. Here's how our latest release will make data communication just a little bit easier.
This week marks the second anniversary of Fishtown Analytics. Here's what we learned.
I just went through the process of converting 25,000 lines of SQL from Redshift to Snowflake. Here are my notes.
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.
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.
dbt and Looker were built with the same ethos: analysts should be working in code.
Frequently asked questions about Looker explores and how to design them very well.
Modular analytics tools allow companies to choose components to fit their needs and switch out or augment components as their needs change. Here's what I think is missing from the market.
dbt (data build tool) enables data analysts and engineers to transform data in their warehouses.
dbt, our open source product for data modeling, is SQL-only. SQL can, by itself, accomplish a majority of analytical (non-data science) workloads.
Fishtown Analytics celebrates its one year anniversary today.
You need analytics.
Over the past nine months I’ve worked with over a dozen venture-funded startups to build out their internal analytics. In doing so, there’s a single SQL function that I have come to use surprisingly often.
Business intelligence tech has changed really dramatically over the past 3-4 years since the advent of cloud-based analytics databases.