Every company that wants to make growth-oriented and customer-satisfying decisions should follow a data-driven strategy. Data provides us with completely objective information about what we are doing, how our business is performing, and how our customers feel about using our product or service. So, it is important to collect data, model it, and then leverage data as effectively as possible. When it comes to the need to model and transform data, there are two main approaches in the data engineering world: ETL (Extract, Transform, Load), and ELT (Extract, Load, Transform).
In the last years, the ELT approach has become very popular because it allows you to load raw data in your database, and then leverage the potential of the database technology in order to model and transform it. There are different technologies that enable the ELT approach, one of the most popular is dbt.
dbt stands for Data Build Tool, and it's a very powerful tool that allows you to start from raw data, apply transformations using SQL and Jinja functions (the synonym is macro), and create tables containing processed data.
In this lab, you will understand what is dbt and why it's super helpful to model and transform data. You will install it and create your first dbt project.
Upon completion of this lab, you will be able to:
This lab has no prerequisites.
Stefano studies Computer Science and is passionate about technology. He loves working with Cloud services and learning all the best practices for them. Google Cloud Platform and Amazon Web Services are the cloud providers he prefers. He is a Google Cloud Certified Associate Cloud Engineer. Node.js is the programming language he always uses to code. When he's not involved in studying or working, Stefano loves riding his motorbike and exploring new places.