lab challenge

Data Build Tool Challenge

Up to 2h
Get challenged in a real environmentProve your skills in a real-world, provisioned environment.
Push your limitsComplete an unguided mission within the time limit.
See resultsTest your problem-solving skills and track your progress.


In this lab challenge, you will need to prove your knowledge of the Data Build Tool (dbt) by creating a project, defining sources, creating different models, organizing and testing models, and building the dbt project. The objectives you will need to achieve represent valuable skills that Data Analysts and Data Engineers need to have. You'll be given a desired end state and be required to reach it using your knowledge of Data Build Tool. This lab challenge simulates building a solution in a real-world scenario. As with any real-world scenario, this lab will not guide you through the steps needed to complete it.


  • Good knowledge of SQL
  • Good knowledge of dbt

Intended audience

  • Data Analysts and Data Engineers, especially those focused on data modeling and transformation

What will be assessed

  • Your ability to use Data Build Tool
  • Knowledge of dbt models
  • Work with dbt tests

About the author

Learning paths

Stefano studies Computer Science and is passionate about technology. He loves working with Cloud services and learning all the best practices for them. Google Cloud Platform and Amazon Web Services are the cloud providers he prefers. He is a Google Cloud Certified Associate Cloud Engineer. Node.js is the programming language he always uses to code. When he's not involved in studying or working, Stefano loves riding his motorbike and exploring new places.

Covered topics


Data Build Tool Challenge - Basics
Data Build Tool Challenge - Data Modeling
Data Build Tool Challenge - Data Testing