dbt

Origin

dbt (data build tool) was developed by Fishtown Analytics starting in 2016. It brought software engineering practices like testing and versioning to SQL transformation.

Benefits

Modular SQL code with tests and documentation
Clear separation of extraction and transformation
Excellent integration into modern warehouses

Drawbacks

Focus on batch transformations
Requires a cloud warehouse as a foundation

Selected projects

All projects

Energy Industry

Data Foundation for Price and Scenario Management in Energy Sales

Supported the further development and operation of a central data solution for price control, planning, and scenario analyses in an energy sales environment. The solution processes extensive business and technical data flows, checks their quality, and consolidates them into reliable source data for operational and medium-term decisions. This included the modeling and automation of data pipelines, the provision of relevant KPIs, and ensuring a verifiable data foundation for reporting and management.

Learn more

Planning a project with dbt?

We bring experienced experts to your project. Talk to us.

Request a call