The Data Bootcamp: Transform your Data using dbt™

About this course

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 u