Guide to writing analytics engineer and data analyst job descriptions
Learn how to write job descriptions for data analysts, engineers, and other data roles from Emilie Schario (30/60/90 day onboarding plans included)
Read articleFriday, May 20, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions.
|
Tuesday, May 31, 2022:
Early bird pricing for Coalesce 2022 tickets closes.
Friday, May 20, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions.
|
Tuesday, May 31, 2022:
Early bird pricing for Coalesce 2022 tickets closes.
Friday, May 20, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions.
|
Tuesday, May 31, 2022:
Early bird pricing for Coalesce 2022 tickets closes.
Friday, May 20, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions.
|
Tuesday, May 31, 2022:
Early bird pricing for Coalesce 2022 tickets closes.
Updates from the dbt Labs team + the dbt Community.
Learn how to write job descriptions for data analysts, engineers, and other data roles from Emilie Schario (30/60/90 day onboarding plans included)
Read article… just not a good one to keep! In this two part series you’ll learn how we rearchitected our scheduler to meet greater demand in dbt Cloud. For those looking for more technical detail, the second post will be written by and for engineers interested in troubleshooting distributed systems.
Experiencing dbt’s workflow on the lakehouse has never been easier.
Read articledbt Labs raised another round of funding– $222m at $4.2b valuation. Existing investor Altimeter led the round, with participation from Databricks, GV, Salesforce Ventures, and Snowflake. The raise will fuel our investment in building the next layer in the modern data stack.
Read articleOngoing incidents with dbt Cloud have created slowness and lack of availability. Here is a recap of what happened and our plans to fix this.
Read articleAs of January 1, 2022 I officially stepped down from my role as Chief Product Officer at dbt Labs. We've brought on Margaret Francis as our new CPO. I'm incredibly excited to be transitioning into an individual contributor role.
Read articleFour modules designed to help the established analytics engineer plan for rapid growth.
Read articleFour modules of curated Coalesce content for teams just beginning their analytics engineering journey.
Read articleCovering both dbt Labs and dbt Cloud, these certifications represent a long-standing commitment to information security and privacy.
Read articleThe metrics layer generated a lot of buzz at Coalesce, prompting some exciting and important conversations. In short: the dbt Server that will make metrics accessible will be source available. This will provide users control, while enabling us to build a sustainable business.
Read articleIn this talk, Jeff Sloan (Data @ Census, Treatwell, RJMetrics) argues that you should identify core product and business events synthetically within your data warehouse.
Read articleIn this workshop, we will share the key insights and design patterns that we have identified in helping numerous data teams build flexible, trustworthy customer-facing data experiences and machine learning platforms backed by dbt.
Read articleIn 2019, the data community realized there an emerging role called Analytics Engineer. In 2020 came Operational Analytics, and in 2021 Revenue Analytics.
Read articleYAML is hard. We all want to involve our business customers more in what we do, but the command line is just too scary for many.
Read articleIncremental models are core to dbt, and are a key solution to how data teams balance the need for computationally efficient and timeline data.
Read articleLast year we placed a big bet on foundational work — stability, reliability, and speed. 12 months, and a 600% increase in enterprise business later, we're focused on establishing dbt as the default standard for all enterprise data teams.
Read articleThe Data Mesh is an architectural paradigm that decentralises data into product teams over a centralised data team. Combining dbt and the data mesh creates an explosion of dbt users and with it many organisational challenges.
Read articleNever heard of data pipelines? Building your first data pipeline? Already have a data pipeline and just want to scope new trends? This is the workshop for you.
Read articleIn our talk we would like to walk you through our journey from our custom-built transformations to using dbt as the framework and platform for all our data needs.
Read articleData-driven teams will be behind the most amazing human achievements in the next decade, from curing cancer to developing self-driving cars.
Read articleAhmed will present a new data modeling approach called the activity schema. It can answer any data question using a single time series table (only 11 columns).
Read articleThis talk will explore the common challenges companies face when modeling hundreds of millions or even billions of events, and how to solve them. We'll discuss the differences between the cloud data warehouses as well as incrementalization, performance tuning and testing.
Read articleBy leveraging best practices from DevOps and software engineering, we’ve found that data teams can resolve broken pipelines faster, and long before stale dashboards, null values, or duplicate data issues impact downstream data consumers.
Read articleThe "modern data stack" and dbt are often positioned as the current best option for organisations to aim for and the end point of transformation projects. That this is not the end... this is just the beginning.
Read articleA talk oriented towards data team managers (current, future, aspiring). Here, we'll read aloud our "love letters" to our past and present managers.
Read articleLearn how Degreed is upskilling their insights analysts with analytics engineering skills!
Read articleWhat if dbt was able to connect to multiple databases at once and cut on costs and development time? Or even better, avoid lock-in into a data warehouse engine?
Read articledbt Core v1.0.0 has arrived. This major milestone enables users with production-grade workflows to safely and reliably build on top of dbt Core for years to come. Take a look at how we got here, and what's next for dbt.
Read articleIn this talk, I'll tell the story about our stack, our changing schemas and how I used dbt to make life easier for both the engineers instrumenting tracking as well as the executives consuming downstream reporting.
Read articleThis session is will help Team Leads and Committed End Users understand how they can integrate dbt, and the data warehouse into the very core of their product.
Read articleSnowflake is at the forefront of changing the way modern data teams work with the Data Cloud. In this session, Christian Kleinerman, Snowflake's SVP of Product,
Read articleIn our talk, we’d like to share a deep dive into how we do it and why it works. In particular, we’ll talk about our overall philosophy, then dig into our development workflows and CI/CD pipelines. Finally we will cover how we scaled all that to put data engineering tools into the hands of our entire GetUpside team.
Read articleHow might we make analytics a part of the company culture? Something that engineers care about as much as product managers?
Read articleTune in with Kevin Marr from Firebolt to learn about current trends in data warehousing and how they will impact tomorrow's data workflows.
Read articleCompanies today need a product analytics platform to enable product insights that are quick to access and easy to understand and act upon. How can you prepare?
Read articleA story of how 2 motivated actuaries implemented a solution to fix our broken actuarial data pipelines using the dbt CLI, without engineering or developers.
Read articleWhile dbt's open source roots has always made this much easier, we believe in a world where the entire analytics ecosystem grows with us, from Core, to Cloud, and beyond.
Read articleThis session is a deep dive into three ways the dbt Cloud API can be used to foster a culture of greater awareness: through real time monitoring, impact analysis, and historical understanding.
Read articleWe believe the future of analytics workflows is polyglot and will embrace better interoperability between languages and UIs.
Read articleA panel discussion about trends in the data space. Hear from venture capitalists on what's new and interesting in the ecosystem.
Read articleFor most people, the modern data stack isn’t a collection of architectural diagrams; it’s an experience.
Read articleJeremy will offer a highlight reel of the biggest changes included in dbt v1.0, as well as honorable mentions for some neat ideas that ended up on the cutting-room floor.
Read articleDatabricks, Delta Lake, & DBT provide the perfect trio for saving investment management firms money and boosting productivity by allowing analysts to deploy SQL pipelines much faster.
Read articleIn this talk, we will introduce Deepnote, a collaborative data science notebook and how you can use it with dbt to introduce more collaboration into your team’s data modelling and exploratory workflows.
Read articledbt Labs now offers five free courses 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 go deeper on topics like macros, materializations, and project refactoring.
Read articleThis talk is about envisioning the world of five years from now when every organization has an Analytics Engineering department.
Read articleIn this talk we will demonstrate how to get started with streaming analytics using the same analytics engineering skillset that keeps you productive in batch.
Read articleIf you are trying to figure out how one builds a diverse team, do not ask your black co-worker how you should go about doing it.
Read articleThis talk is about how modern data teams working in the “data as product” and “analytics engineering” models can benefit from using prototyping practices.
Read articleDelivering high impact, high velocity, high quality data products in highly volatile data contexts.
Read articleI propose we lobby against the title Data Scientist, instead choosing some variation of the Core Four Data Roles: Data Analyst, Analytics Engineer, Data Engineer, and Machine Learning Engineer.
Read articleHow I was able to adopt dbt coming from an industrial engineering background, and how it can be leveraged by end users with a quality control mindset to solve common business problems.
Read articleHave you ever felt that you were not the intended audience of the technology you consume? Are there software design paradigms that simply do not work for you?
Read articleUsing dbt artifacts we were able to create a central monitoring and alerting system that notified people if a specific dbt model failed.
Read articleI will illustrate these ideas with a demonstration of the {dbtplyr} dbt package which helps analytics engineers get the most value from controlled vocabularies by making it easier to effectively exploit column naming structures while coding.
Read articleHow my team decreased query time in Looker and saved Snowflake credits, by materializing views and tables and implementing tags for job schedules.
Read articleHiring is a critical point in influencing company and team culture and for bringing on folks who can really get the job done.
Read articleAttendees will walk away with some recommendations for creating their own data product strategy that will be useful no matter what scale they are operating on.
Read articleA dbt package is not only a way to make a particular process easier or more robust or more efficient – it can also be a way to productionize/share practices.
Read articleOne of our biggest wins so far has been finding clever ways to incrementalize our longest-running tables, while still solving for 2 main pain points.
Read articleWe'll show our method to automate source transformations. Aula's growth and a proliferation of nonrelational sources required constant manual maintenance to our dbt project -- which was sucking up the data team's capacity.
Read articleThis session will cover our own analytical use cases, as well as features Fivetran is building to support dbt in the open-source community, like our Visual Studio Code integration, Fivetran-managed dbt packages and our Transformations product line.
Read articleLearn what questions you should be asking before seeking out consultants, what a successful engagement should look like, and how to align your internal talent with external strengths that best serve your team.
Read articleTogether, we’ll demystify the git flow and build a mental model for how git works. You’ll leave the talk feeling ready to use git on every project you work on!
Read articleEver wondered how to build up a dbt project from the ground up? How do you know when good enough is good enough?
Read articleAs data analytics becomes a cornerstone for modern companies, understanding who owns what in the data organization has never been more confusing—or important.
Read articleThe modern data stack is the third generation of data analysis products to come to prominence since the 90's.
Read articleInvesting in analytics engineering was a game-changer for our ability to deliver value as a data organization, but it didn't happen overnight.
Read articleThis is an overview of how our Data team is structured, how we interact with the greater org, the general operations, and our expectations/responsibilities.
Read articleAre you interested in learning more about our dbt Meetups, or how to become a Meetup organizer in your community?
Read articleIn this panel, we'll bring on an assortment of thought leaders and data practitioners to discuss how and why companies are using cloud data warehouses for operations today.
Read articleReynold Xin is a technical co-founder and Chief Architect at Databricks. He’s also a co-creator and the top contributor to the Apache Spark project.
Read articleIf dbt is new to you, join us in this session to get up to speed. We'll go through the basics and give you all the information you need to get the most value out of this conference!
Read articleDec 6-10, 2021: Coalesce is back with 85 speakers, 65+ sessions, and a little razzle-dazzle. Targeting 4 time zones (EST, PST, GMT, and AEDT)—there are plenty of opportunities to join us live. Find out what’s new, what’s staying the same, and how to prepare.
Read articleExciting developments in our partnership with Snowflake.
Read articleYour code doesn't have to do the same thing everywhere it runs. Separate code from configuration - and set config based on context.
Read articleWhere to begin when migrating legacy SQL transformation code to dbt? In a new (free!) on-demand course, analytics engineers from dbt Labs unpack the refactoring process they've employed across dozens of projects.
Read articleChoosing between continuous delivery and continuous deployment based on business needs
Read articleIt's finally (almost) here. The best way to get ready is by upgrading *now* to the latest & greatest that dbt Core has to offer
Read articleWe are cancelling in-person events for the remainder of 2021. We know these are disappointing news but remain confident that it's the right decision for safely engaging with the dbt Community.
Read articleWith the DAG-in-the-IDE (now available to all dbt Cloud users), analytics engineers can seamlessly navigate the core structure of their dbt project with low friction and low cognitive load, making the entire development process more intuitive, pleasant, and efficient.
Read articleThe data world needs more purple people — generalists who can navigate both the business context and the modern data stack. Let's put aside skillset dichotomies, and learn to feel comfortable in the space between.
Read articleGive your business teams access to transformed data in the tools they use every day. Hightouch now integrates with dbt to help you bring “Reverse ETL” to your stack.
Read articleOver the past few months, the dbt Labs’ recruiting team has partnered with leaders from our Engineering and Analytics Engineering organizations to design the Foundry Program. This program will provide a gateway for those that are new to the field or looking to make a career change.
Read articleFishtown Analytics– now dbt Labs– was founded to bring analytics engineering to everyone. $150m in new funding will fuel the next phase of that journey.
Read articleOur friends at Materialize, the world’s first SQL-platform for processing streaming data, have officially launched a new dbt adapter, now available in open beta. Together, we’re opening the door for analysts to become first-class creators and users of streaming analytics.
Read articleThis SQL-first integration with Databricks means that analysts can build fully automated data pipelines in the same space that data engineers & data scientists work in their preferred frameworks.
Read articleStaging is a ✨new✨ quarterly event that brings dbt users (that’s you!) into the product development lifecycle (where I spend my days 😅).
Read articleWatch Evy Kho's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Andrea Kopitz's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Johnathan Brooks's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Jacob Mulligan and Dom Colyer's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Nadja Jury's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Krishna Naidu and Jose Galarza's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Jonathan Mak's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Caitlin Moorman's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Rob Winters, Bart Sandbergen, Virginia López-Gil Pérez, Teodora Vrabcheva and Simon Ouderkirk's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch John Napoleon-Kuofie's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Shannon Morales's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Chris Holliday, Amy Chen, Ryan Goltz and Ben Singleton's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Sam Foltin's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Alan Cruickshank's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Pietro Casella and Erik Ferm's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Bastien Boutonnet and Jean-François Lairie's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Benn Stancil's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Sam Bail's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Emilie Schario, Laurie Voss, Francisco Lozano and Brian de la Motte's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Ilse Ackerman, Alexis Johnson-Gresham, Colleen Tartow, PhD and Meghan Colón's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Andres Recalde's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Anna Bladey's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Dave Fowler's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Nick Schrock's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Emilie Schario and Taylor Murphy's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Drew Banin's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Drew Banin, Barr Moses, Jon Loyens, Matt Allen and David Wallace's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Emily Hawkins's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Christine Berger's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Stephanie Morillo and Janessa Lantz's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Vincey Au's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch David Murray's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Kenny Ning's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Jacob Frackson's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Tristan Handy's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Ashley Van Name's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Carly Kaufman, Mila Page and Ashley Van Name's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Jennifer Li, Boris Jabes, Jeremy Levy and Arjun Narayan's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Grant Winship and Sanjana Sen's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Andrew Escay, Christine Berger and Erica Louie's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleWatch Carly Kaufman and Claire Carroll's talk replay from the Coalesce analytics engineering conference in 2020.
Read articleMy thoughts on where our space has been and where it might be going.
Read articleSpark for analytics, for real: now in dbt Cloud
Read articleFishtown 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.
Read articleTranslating 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?
Read articleOur thoughts on what makes a great conference pitch and lessons for future iterations of Coalesce.
Read articleI originally wrote this as a part of our new analyst onboarding program back in June of 2017, shared with new analysts on their first day. It’s as true today as it was the day I wrote it, so I wanted to publish it more broadly. Maybe you’ll find it useful!
June 11, 2021 update – This post hasn’t aged as well as I would’ve hoped. George makes a strong statement in it: “Fivetran is not fundamentally a company that is focused on data transformation.” That statement appears to be less true today than it was in October of 2020. In a recent conversation, George indicated to me that data transformation had become a core part of the Fivetran strategy. And as the company moves towards the GA release of Fivetran Transformations, it’s become increasingly hard for the two companies to continue what was once an extremely close commercial relationship.
While we continue to be excited about Fivetran’s adoption of dbt as a standard for data transformation, the relationship between the two companies is a bit more like the relationship between Snowflake and AWS: sometimes allies, sometimes competitors. And that’s ok—these kinds of evolutions happen in fast-moving markets like the one we’re in.
We continue to have a lot of respect for Fivetran (and use their data ingestion product internally!). Many Fivetran employees make fantastic contributions to the dbt Community and the company is working on some tooling contributions that it hopes to release as open source software soon. All of this is fantastic.
As the ecosystem evolves, I do want to be extremely clear about our own stance: we believe that dbt Cloud is by far the most robust tool on the market for both authoring and productionizing dbt workloads. And as we continue to ramp our product and engineering velocity that gap will only increase. This shouldn’t be surprising—we’ve been working on this problem for five years now and it’s been our sole focus that entire time. It will continue to be our sole focus moving forwards.
Fishtown Analytics started as a consulting company that competed with other dbt service providers. We are now a venture backed software company and our business model has fundamentally changed. Our relationship with dbt service providers is now 100% partnership.
Read articleTwo amazing companies in the modern data stack–Fivetran and Census–have launched major integrations with dbt. Here's why I'm excited about this.
Read articleA startup's guide to modeling data following Kimball best practices
Read articleA recent post, Dashboards are Dead, sparked a conversation about the future of data reporting.
Read articleWe’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.
Read articledbt is no longer a niche product and dbt Slack is no longer a community of misfits...we’ve gone mainstream, folks.
Read articleThis 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.
Read articleA holistic data testing framework to help you catch data quality issues before they impact your stakeholders.
Read articleA Letter to the Community
Read articleFor the foreseeable future, all in-person dbt events are cancelled. But we have some good stuff in the works.
Read articledbt is four years old, and we are so grateful for the community that has grown alongside this project.
Read articleMarketing 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.
Read articleThe first global conference for analytics engineers
Read articleIf 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.
Read articleThe 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.
Read articleWith the dbt Integrated Developer Environment (IDE) you can orchestrate the entire analytics engineering workflow in your browser.
Read articleAnalytics 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.
Read articleThe data team is a brand new thing: it’s not IT, it’s not finance...so who does it report to? How big is it?
Read articleAnalytics engineers provide clean data sets to end users, modeling data in a way that empowers end users to answer their own questions.
Read articleMeet 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.
Read articleMy 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.
Read articleIf 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.
Read articleData 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.
Read articleAll 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.
Read articleVersion 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.
Read articleModern 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.
Read articleHow to screen for curiosity when making your next analytics engineering hire (example interview questions included).
Read articleAdvice from analysts and data engineers at HubSpot, Managed by Q, GitLab, Wong Decision Intelligence, AskWonder, and Calogica
Read articleStephen 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.
Read articleThe 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.
Read articledbt v0.14.0 lays the foundation for dbt Develop -- a query editor which leverages the brand new dbt server.
Read article680 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!
Read articleHoly crap! Within the past week we’ve seen the acquisitions of the two biggest players in the modern BI landscape, Looker and Tableau.
Read articleUnnesting arrays on Redshift is a pain, but it’s doable. This post walks through the entire process, start to finish.
Read articleThoughts on pricing strategy and what it communicates about your company's vision for the future of the market you're in.
Read articleWe just finished hosting the first dbt Learn. Here's why we did it, what we learned, and how you can get on board for the next one.
Read articleWe've set up Snowflake accounts for quite a few clients and have an approach that we rather like.
Read articleAs dbt is adopted by a wider community, we want to be extremely clear about when dbt is, and is not, a fit for your project. This guide will help you figure out if dbt is right for your data transformations.
Read articleThe Fishtown Analytics team is incredibly excited to announce that we’ve re-launched Sinter as dbt Cloud!
Read articleSinter just became dbt Cloud. Why the re-brand?
Read articleIn dbt’s latest release, we made some significant changes to how dbt processes these DAGs, and we’re seeing that these changes make dbt projects run about 30% faster.
Read articleThe role of the data engineer in a data team is changing rapidly. Are you thinking about it the right way?
Read articleThe hardest thing about scaling a company is communication. Here's how our latest release will make data communication just a little bit easier.
Read articleThe newest release of dbt, v0.11, ships with a built-in data documentation website for your dbt project.
Read articledbt 0.10.2 introduces data model aliasing to help you maintain a more organized data warehouse design.
Read articleSinter is the best way to deploy dbt in production at most organizations. It features rich scheduling functionality, accessible run logs and error alerting, and customizable job definitions. Today, it just got better.
Read articleThis week marks the second anniversary of Fishtown Analytics. Here's what we learned.
Read articleI just went through the process of converting 25,000 lines of SQL from Redshift to Snowflake. Here are my notes.
Read articleIf you’re a hotshot junior analyst and you want a guide for breaking through this skills plateau, this guide is for you.
Read articleThis 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.
Read articleToday, March 9th, 2018, dbt turned two years old. Wow. Here's where we've been and where we're heading.
Read articleI 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.
Read articledbt and Looker were built with the same ethos: analysts should be working in code.
Read articledbt version 0.9.1 adds support for late binding views in Redshift. This post will explain late binding views and explore some potential uses
Read articleFrequently asked questions about Looker explores and how to design them very well.
Read articleModular 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.
Read articleWant to go from syncing new data to having transformed data models built in minutes? Packages are going to be your friend.
Read articleWe’re thrilled to announce the release of dbt version 0.9.0, including support for pivoting out columns and ignoring incongruent tables.
Read articledbt (data build tool) enables data analysts and engineers to transform data in their warehouses.
Read articleThis post is one of the first things that new employees read upon joining our team.
Read articleHow to create historical records in your database using dbt data logs.
Read articledbt, our open source product for data modeling, is SQL-only. SQL can, by itself, accomplish a majority of analytical (non-data science) workloads.
Read articleFishtown Analytics celebrates its one year anniversary today.
Read articleYou need analytics.
Read articleOver 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.
Read articleThis post, originally published in 2016, was most recently updated in November 2017.
Read articleBusiness intelligence tech has changed really dramatically over the past 3-4 years since the advent of cloud-based analytics databases.
Read articleThere’s a new small business that just opened up in Fishtown and it’s not a gin bar or artisanal coffee shop.
Read articleOver the past three months I’ve been in the lab building Fishtown Analytics. There’s a lot of the company formation process that’s been fun for me. I love checklists, and treated the opening of this business as a really big one.
Read articleToday is a big day. Today, Magento announced it has purchased RJMetrics. The RJMetrics product will form the foundation of Magento Analytics, giving Magento users powerful tools to analyze their customers’ behavior.
Read articleWhen a software engineer starts on a new project, her first step is almost always to survey the ecosystem of open source software that exists in the problem space.
Read articleOver the past year, I and the folks at RJMetrics have had the opportunity to observe, and participate in, a significant evolution of the analytics ecosystem. The center of gravity in mature analytics organizations has shifted away from proprietary, end-to-end tools towards more composable solutions.
Read articleGit is the version control system of choice for data teams worldwide - see how we wield it internally at dbt Labs.
Read articleTwo fundamental technological advances, ETL tools and cloud data warehouses, enable analytics engineers to practice the ELT workflow.
Read articleFollow the career path of Adam Stone, an analytics engineer on Netlify's data team.
Read articleFind your next analytics job. Open roles listed for data analysts, analytics engineers, data engineers, data scientists and ML engineers.
Read articleOver the last four years, the data team at Snaptravel has grown from one analyst to almost a dozen, and they've experimented with five data team structures.
Read articleData testing helps your analytics team move faster - let's explore what to test, and when to test it.
Read articleExplore practical examples of modular data modeling techniques from traditional to modern and modular techniques.
Read articleExploring how we use data notebooks internally on the team, and how platforms like Hex & Querybook are making SQL-based notebooks a reality.
Read articleWe've all heard the buzz, but how does implementing a reverse ETL tool actually improve your operational analytics work in practice?
Read articleThe tale of migrating from a stored procedure-based ELT workflow to an ELT data transformation workflow on BigQuery, and the 3x productivity gains that ensued.
Read articleReporting quality can make or break your data team's reputation - will your colleagues cherish your visualizations, or question their validity?
Read articleFollow the career path of Tom Nagengast, an analytics engineer on Netlify's data team.
Read articleOrganize your organization's information with a high-quality data documentation process.
Read articleIn 2016, Tristan Handy wrote about the need for data analysts to start working like software engineers. How's that transition going?
Read articleCleanly transformed data is table stakes for predictive modeling. How can analytics teams collaborate to make transformed datasets easily accessible?
Read article