WHAT TO EXPECT

The focus of this workshop will be to demonstrate how we can use both SQL and python together in the same workflow to run both analytics and machine learning models on dbt Cloud. We will also develop data pipelines with engineering best practices like CI/CD, version control, testing, and documentation as you code.

WHAT YOU WILL EXPLORE & LEARN

• How to use dbt with Snowflake to build scalable transformations using SQL and Python
• How to use dbt to prepare your data from sources to encoding
• How to train a model in dbt python and use it for future prediction
• How to deploy your full project

WHAT YOU WILL BUILD & CREATE INSIGHTS FOR

• A set of data analytics and prediction pipelines using Formula 1 data leveraging dbt and Snowflake, making use of best practices and code promotion between environments.
• Finding the lap time average and rolling average through the years
• Predicting the position of each driver based on a decade of data

WHAT YOU WILL NEED FOR THIS LAB

•  Snowflake account with ACCOUNTADMIN access
• A GitHub Account

IN PARTNERSHIP WITH