- 01
Assess
We review existing SQL, stored procedures or dbt projects, sources and reporting needs.
You receive dbt project assessment and modeling plan
- 02
Set up
dbt Core or dbt Cloud, environments, Git workflow and project conventions are put in place.
You receive Configured dbt project and Git workflow
- 03
Model
Sources, staging, intermediate and mart models are built, using star schema or Data Vault patterns.
You receive Tested dbt models for agreed subject areas
- 04
Test and document
Data tests, documentation and lineage are added for every model.
You receive Published dbt docs and test coverage
- 05
Automate
CI/CD runs builds and tests on every pull request and deploys on merge.
You receive CI/CD pipeline for the dbt project
- 06
Hand over
We leave a style guide, a contribution guide and a walkthrough so analysts and engineers can add models through pull requests.
You receive Style and contribution guides, onboarding walkthrough