Disclosure: when you buy through links on our site, we may earn an affiliate commission.

The Data Bootcamp: Transform your Data using dbt™

Learn dbt™ from scratch. Build data models, perform testing, generate documents & become an all rounded Data Engineer!
4.7
4.7/5
(17 reviews)
146 students
Created by

9.6

CourseMarks Score®

10.0

Freshness

9.1

Feedback

9.2

Content

Platform: Udemy
Video: 4h 7m
Language: English
Next start: On Demand

Top Data Engineering courses:

Detailed Analysis

CourseMarks Score®

9.6 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 6/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

9.1 / 10
We analyzed factors such as the rating (4.7/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.2 / 10
Video Score: 8.2 / 10
The course includes 4h 7m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.9 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
122 resources.
0 exercise.
0 test.

Table of contents

Description

Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course for you. Welcome to The dbt™ Bootcamp: Transform your Data using dbt™.

In this course you are going to learn all about dbt™, from setting up dbt™ cloud, connecting it to Snowflake or a warehouse of your choice, developing models, creating sources, doing testing, working with the documentation and much more.

This course is for beginners, we will go through a realistic project and cover each of the steps mentioned in a practical approach.

dbt™ is a data modelling tool that makes life much easier for analysts and engineers. It allows you to write SQL queries without having to worry about dependencies. dbt™, like traditional databases, is built on SQL, but it has additional functionality built on top of it utilizing templating engines such as JINJA.
This effectively lets you to retrieve, rearrange, and organize your data using additional logic in your SQL. You may then compile and run this code using dbt’s™ run command to retrieve just the pieces you need in the transformations. It can also be swiftly coded, tested, and adjusted without having to wait for it to process all your data. In addition to that, it’s automated documentation is a big time saver.
The project we will be working on is about a fictitious company called GlobalMart. GlobalMart sells household items like furniture, office equipment, Appliances and Electronics. They are in the process of hiring a small data team and would like to try out dbt™ for their data transformations. They require some reporting tables about their profits and want to use dbt™ to transform their data to get them what they want.

By the end of this course, we will work through the project and end up accomplishing the following:

1. Setting up a dbt™ Cloud Account
2. Connecting to a Database (in this case Snowflake)
3. Connecting dbt™ to a repository like GitHub
4. Understanding the dbt™ cloud interface
5. Building and Running Models in dbt™
6. Using Modularity in dbt™
7. Creating and Referencing Sources
8. Performing Tests in dbt™ including Singular and Generic Tests
9. How to Create and Generate Documentation in dbt™
10. How to Deploy in dbt™
11. How to use Jinja
12. Using Macros and Packages in dbt™
13. Using Seeds and Analyses in dbt™

This is a great, comprehensive which will really up-skill you not only in dbt but the extract, load and transform process as well.

Thank you so much for choosing this course and I’ll see you in the next lecture.

You will learn

✓ Learn how to use dbt end-to-end through a realistic project, hands-on project
✓ Learn the fundamentals of dbt including connecting to a data warehouse, developing models, working with sources, creating tests, deploying and much more
✓ Understand how dbt is beneficial in a modern data stack and how the Extract, Load and Transform process works
✓ Learn how to use Macros and Packages in dbt to simplify and reuse your code
✓ Learn how dbt can work with complex SQL queries
✓ Perform Testing in dbt such as singular tests, generic tests and source testing
✓ Develop documentation for your models, understand modularity and dependancies in dbt
✓ Learn about the dbt Project Structure and how to set up your own project
✓ Understand how to use JINJA in dbt
✓ Learn how to deploy in dbt under a schedule and investigate run time errors
✓ Learn how to use Seeds and Analysis in dbt

Requirements

• Basic SQL knowledge (optional)

This course is for

• Anyone wanting to get more experience in dbt (Data Build Tool)
• Anyone wanting to know more about Extract, Load and Transform Process
• Anyone wanting to start a career in Data Engineering
• Anyone wanting to gain more experience in Data Analytics

How much does the The Data Bootcamp: Transform your Data using dbt™ course cost? Is it worth it?

The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $19.99. So you save $5 if you enroll the course now.

Does the The Data Bootcamp: Transform your Data using dbt™ course have a money back guarantee or refund policy?

YES, The Data Bootcamp: Transform your Data using dbt™ has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the The Data Bootcamp: Transform your Data using dbt™ course, but there is a $5 discount from the original price ($19.99). So the current price is just $14.99.

Who is the instructor? Is Vantage Data a SCAM or a TRUSTED instructor?

Vantage Data has created 1 courses that got 17 reviews which are generally positive. Vantage Data has taught 146 students and received a 4.7 average review out of 17 reviews. Depending on the information available, Vantage Data is a TRUSTED instructor.
Learn with the team @ Vantage Data
Hey, we’re the team at Vantage Data. We are a group of data specialists who have decided to create fun, practical and comprehensive courses about currents tools, platforms and technology in the data space.
Other than being data nerds, we have a platform called Vantage Point which is a no-code, click & go business acceleration tool which enables data driven decisions across businesses all over the world.

9.6

CourseMarks Score®

10.0

Freshness

9.1

Feedback

9.2

Content

Platform: Udemy
Video: 4h 7m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

The Data Bootcamp: Transform your Data using dbt™ rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/the-data-bootcamp-transform-your-data-using-dbt/" target="_blank" title="The Data Bootcamp: Transform your Data using dbt™ on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/96.svg" width="200px" alt="The Data Bootcamp: Transform your Data using dbt™ rating"/></a>