Product News dbt + Databricks: Bringing analytics engineering to the lakehouse Spark for analytics, for real: now in dbt Cloud
Company News A License to build the future Fishtown Analytics has raised $29.5m in a Series B financing. New investor Sequoia Capital led the round with existing investors Andreessen Horowitz and Amplify Partners participating. Matt Miller of Sequoia joined our board.
Opinion There is no such thing as a “non-technical” data analyst Translating business logic into code is technical knowledge. Building a marketing attribution model, forecasting, or calculating MRR is technical knowledge. Understanding the inner workings of the business is technical knowledge. So...is there such a thing as a non-technical data analyst?
Community News Here’s what we learned from reviewing ~100 conference pitches Our thoughts on what makes a great conference pitch and lessons for future iterations of Coalesce.
Product News Slack DMs: George and Tristan discuss the future of Fivetran and dbt Fivetran's new native integration with dbt seems to be directly competitive with Fishtown Analytics' commercial offering, dbt Cloud, but is it? Here's why we don't see it that way, and why we think this is a great thing for the ecosystem.
Product News Welcome to the dbt ecosystem Two amazing companies in the modern data stack–Fivetran and Census–have launched major integrations with dbt. Here's why I'm excited about this.
How-To How I set up my conformed dimensional models A startup's guide to modeling data following Kimball best practices
Opinion Are dashboards dead? A recent post, Dashboards are Dead, sparked a conversation about the future of data reporting.
Community News Bringing back the magic to the dbt community — part one We’re taking some steps to bring back the ✨magic ✨ in the dbt community. First stop — focusing the different ways the dbt community interacts with each other.
Company News Four Years In: From Misfits to Mainstream dbt is no longer a niche product and dbt Slack is no longer a community of misfits...we’ve gone mainstream, folks.
How-To How to find a role in analytics engineering 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.
How-To The farm-to-table testing framework: How to catch data quality issues before they break your dashboards A holistic data testing framework to help you catch data quality issues before they impact your stakeholders.
Company News We're cancelling Coalesce. Here's what to expect instead. For the foreseeable future, all in-person dbt events are cancelled. But we have some good stuff in the works.
Company News Four years in (and it’s a strange time to celebrate) dbt is four years old, and we are so grateful for the community that has grown alongside this project.
How-To Modeling marketing attribution 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.
How-To Modeling subscription revenue 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.
Company News Analytics engineering for everyone 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.
Company News Announcing the dbt IDE With the dbt Integrated Developer Environment (IDE) you can orchestrate the entire analytics engineering workflow in your browser.
How-To How great data teams test their data models 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.
Building data teams How should I structure my data team? A look inside HubSpot, Away, M.M. LaFleur, and more 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?
Building data teams When did analytics engineering become a thing? And why? 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.
Building data teams The four priorities of a one-person analytics team: lessons from Lola.com 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.
Opinion Write better SQL: In defense of group by 1 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.
