top of page

dbt Cloud-Big Query analytics engineering project

Date of project completion: March 2024

Source freshness: 2024

Source: Testing data from a British start-up

Credit: Ben O.R.

Goals:

  • To build an entire pipeline (from sources to reporting tables) on dbt Cloud

  • To apply dbt tests to the resulting pipeline

What steps were taken in this project?

​

  1. Uploading CSV files to BigQuery

  2. Connecting BigQuery-dbt Cloud-GitHub

  3. Working on dbt Cloud

    • Sources (and tests)

    • Intermediary models

      • Customer cohorts

      • Accrual revenue by product and region

      • Profit and loss by product and region

    • Reporting tables

      • Cohorts reporting

      • Mart: product distribution

      • Mart: customer segmentation

    • dbt test

      • Installing dbt_utils

      • Applying dbt_utils.expression_is_true

Captura de pantalla 2024-03-29 182255.png

© 2022 DLR's Analytics

bottom of page