The dbt Bootcamp: Transform your Data using Data Build Tool

Description

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

In this course you are going to learn all about Data Build Tool, 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.

 

Who 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

Interested in more? Check out our product, Vantage Point. Vantage Point (VP) is a no-code, click & go business acceleration tool which enables data driven decisions across your business. It drives interactivity across all parts of your organization by communicating value (KPIs), autogenerating tasks with cutting-edge ML/AI technology and enabling users to combine VP’s ML/AI recommendations with their own analysis. You can finally track the exact ROI impact throughout your entire business with Vantage Point.

Get in touch by following this link

dbt London Meetup!

dbt London Meetup!

Bringing communities together to connect, collaborate, and learn about DBT 25 May 2022 | 5pm | The Devereux hosted with All UK based folks, join the Vantage Data Team for some food, drinks and refreshments 🍻 and to chat all things data engineering and dbt. We...

read more

Written by

Devasha Naidoo

Senior Technology Architect

dbt Webinar: Let’s Get in Gear for Coalesce!

Bringing communities together to connect, collaborate, and learn about dbt October 13 at 5:00pm BST (UTC +1) | Zoom Webinar | Sign Up Below hosted with dbt has been taking the world by storm. Over the last few months, many of you have asked for more! More content,...

Data And Drinks – Meet the Snowflake and Vantage Team

Bringing communities together to connect, collaborate, and learn about Snowflake 13 June 2022 | 5 pm | Legacy Yard, Umhlanga, Durban hosted with You’re invited to join Snowflake & Vantage for an evening of Drinks, Data & delicious nibbles on the 13th June at 5...

Roll out The Red Carpet – dbt is ready to Change the Way We Transform Data.

I got introduced to DBT when I started at Vantage Data nearly a year back and although I’ve heard of DBT before, I really didn’t understand the full capabilities until I got my hands dirty. Looking back, all I can say is WOW! Using DBT together with something like...

REQUEST A DEMO

10 + 4 =