Services

Getting Started with dbt

Why dbt?

dbt™ is a transformation workflow that lets teams quickly and collaboratively deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Now anyone who knows SQL can build production-grade data pipelines.

1

Deploy safely using dev environments. Git-enabled version control enables collaboration and a return to previous states.

2

Test every model prior to production, and share dynamically generated documentation with all data stakeholders.

3

Write modular SQL models with SELECT statements and the ref() function– dbt handles the chore of dependency management.

DEEP-DIVE

Getting Started with dbt

Rittman Analytics is a Preferred Consulting Partner for dbt, working with our clients, the community and the wider dbt ecosystem to get the most out of dbt and dbtCloud.

Data Centralization

Connect your ad network data data to your operational systems to find out which marketing channels bring in the most valuable customers; connect your CRM data to your finance data to include cost-of-sale into your customer profitability calculations; connect it all together to get a single, consistent view of each of your customers.

Team Mentoring and Enablement

Mentor and train your data team using a modern analytics workflow based on dbt, our RA Warehouse dbt framework and our project-proven delivery method.

Packaged Analytics Sources

RA Data Warehouse for dbt is a set of data models, data transformations and design patterns we use when building the data warehouse layer for our client analytics project, with pre-built modules for popular SaaS applications such as Xero, HubSpot, Salesforce, Google Ads and Stripe.