What you'll learn

Managing data efficiently can be a daunting task, especially when transforming raw, unstructured data into actionable insights. Traditional ETL tools are often complex, costly, and hard to scale. With dbt (data build tool) and Snowflake, you can streamline this process and automate data transformations for precise reporting and analysis.

In this course, Up and Running with dbt, you’ll gain the skills to efficiently transform and analyze data, ensuring accuracy and insight into business performance.

First, you’ll set up a dbt environment—both Cloud and CLI—and connect it to Snowflake to start transforming a financial dataset.

Next, you’ll master fundamental dbt commands and workflows to turn raw financial data into structured models, focusing on metrics like revenue and profit.

Finally, you’ll apply these skills to build a financial report, leveraging testing, documentation, and version control to ensure reliability.

By the end of this course, you’ll have the knowledge of dbt and data modeling needed to automate transformations, generate accurate reports, and provide actionable insights for business decisions.