dbt

dbt is a leading data transformation tool that has quickly become the standard for data transformation, testing, and documentation in the modern data stack. dbt centralizes modeling logic, ensuring a single source of truth for all business reporting. It enables analysts to work more efficiently, deliver consistent analyses and inspire confidence in business stakeholders’ decisions.

Why we love dbt

Active and supportive Slack community

Easy-to-use framework built on top of SQL

Built in testing, documentation, and dependency management

Open source and hosted SaaS options

Rapidly growing ecosystem of integrated tools

Native support for git-managed version control

How Brooklyn Data helps dbt users

As one of the first users of dbt and a preferred consulting partner of dbt Labs, we’re experts at building dbt models for business of all sizes. We have the technical skills and business context to translate KPIs and stakeholder requirements into robust, DRY (don’t repeat yourself) dbt models. Our team is skilled at the full dbt development lifecycle, including instrumenting data quality tests, writing documentation, and orchestrating your dbt models to run in production. For more advanced implementations, we can also implement CI/CD, blue-green deployments, and pre/post-hooks. We especially love coaching our clients’ in-house data team on dbt and the engineering workflow.

Construct a feature store for data science / ML

Create a central source of truth for business reporting

Build a 360 customer view for personalized communication