Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 3 Minute(s)
Language
English
Taught by
Jeremy Holtzman
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
3 views
Course Overview
Complete guide to Learning DBT including connecting it to a Data Warehouse
What you'll learn
Welcome to this course, Learn DBT from Scratch. DBT lets you build a system of transformations on your data, with tests, scheduled runs, multiple environments, flexibility, and more all without needing a team of engineers to set up and manage your workflow. By the end of this course, you will have:
set up DBT locally and on the cloud
connected DBT to Snowflake (or a data warehouse of your choice)
create your own SQL transformations on data
test your transformations
snapshot your data to keep track of how your data changes over time
learn DBT best practices
In this course, you'll be presented with the summarized information you need so that you can quickly get DBT implemented in your data pipeline (or in a brand new, data warehouse).
Why you should learn DBT
DBT is not one of the first technical skills most Data Scientists or Analysts think to learn. It’s not as exciting as machine learning algorithms, and it’s not as easy to show off as a fancy data visualization.
But DBT is an absolutely fundamental skill for any Data Scientist or Analyst due to all of its capabilities. Because DBT is so flexible, there are almost an endless amount of ways you can integrate DBT into your data architecture. Some features that DBT provides you that all Data Scientists and Analysts should be using in their work include:
Creating consistent aggregations for your analysis in a single location
Consistently testing your transformations and underlying data
Running your data transformations on a schedule
Test your code in a DEV environment
About DBT
DBT is pioneering modern analytics engineering. DBT applies the principles of software engineering to analytics code, an approach that dramatically increases your leverage as a data analyst. They believe that data analysts are the most valuable employees of modern, data-driven businesses and they build tools that empower analysts to own the entire analytics engineering workflow.
Course Content
- 6 section(s)
- 31 lecture(s)
- Section 1 Introduction
- Section 2 Connect DBT and Snowflake
- Section 3 Getting Started with Models & Tests
- Section 4 Deploying and DBT Cloud
- Section 5 Advanced Topics
- Section 6 Best Practices
What You’ll Learn
- Connect DBT to Snowflake or another database
- Create SQL transformations that use consistent logic
- Test SQL transformations and underlying data
- Run transformations on a schedule
- Add snapshots for slowly changing dimensional tables
- Test your code in a dev environment
- Learn DBT Best Practices
- Advanced DBT Topics
Reviews
-
AAdarsha Mukherjee
He didn't explain the setup properly, even the setup is only done for Mac. There is no information for Windows user. You will have to go on youtube or other portals to learn to setup... I choose this cource to save time, but it seems it is taking more time for research
-
AAbiroop Mohan
Short and sweet course, it goes through the important information about dbt.
-
SScott Matthews
It's mainly because the material is a bit out of date with the setup, and the fact that some tools were installed ahead of time makes the install steps seem more straightforward than they actually are. I expect to be able to see the warts of the process to fully know what I'm getting into.
-
SSwarnali Datta Ghosh
nice course with good explanation of most concepts
