Vibe Harboe Christensen has completed
Case Study: Building E-Commerce Data Models with dbt
Start course For Free4 hr
2,750 XP
Loved by learners at thousands of companies
Course Description
Transform raw data into clean, reliable models using dbt (Data Build Tool) - a modern, SQL-based transformation framework used by data teams around the world. This hands-on case study course is designed for early-stage learners who want to build real-world skills through guided, practical exercises. You'll set up your own dbt environment, model data at scale, and write reusable code using dbt's built-in features.
Set Up Your Project and Explore the Data
Get started by setting up a dbt project and working with a real E-Commerce dataset. You'll structure raw data, configure profiles, and debug syntax issues while gaining insight into the business context behind each transformation step.Build and Validate Models
Learn to create scalable staging models and apply data quality checks to ensure your datasets are accurate and analysis-ready. You'll build a solid foundation for answering key business questions.Automate with Jinja
Finish the course by learning how to use Jinja to write reusable, maintainable code. You'll use variables, control flow, and loops to follow the DRY (Don't Repeat Yourself) principle to streamline your dbt workflow.Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.- 1
Setting up dbt
FreeGet practice building a dbt project from the ground up. Apply your skills at loading different types of data into the dbt project and setting up a variety of staging dbt models. This chapter focuses on the E and L parts of the ELT process.
Introducing the dbt case study50 xpCheck dbt installation100 xpInitialize the dbt project100 xpSetting up the dbt project and loading data50 xpLoad distribution center as a dbt seed file100 xpCreate distribution center staging model100 xpLoad and create user model via dbt source100 xpMore practice with dbt source and staging models100 xpDebug common errors100 xp - 2
Building dbt models
Dive deep into the weeds of dbt data modeling. Build the data pipeline from preliminary staging models to the final data mart models for answering critical business needs. Along the way, get experience creating data tests to guardrail against data quality drift.
Creating dbt descriptions and tests50 xpAdd dbt column descriptions100 xpAdd dbt column tests100 xpBuilding dbt data marts and snapshot models50 xpRefresher on dbt model hierarchy100 xpCreate mart model for customers100 xpCreate mart model for products100 xpDebugging common errors100 xpDebugging more errors100 xpBuilding dbt snapshot models100 xp - 3
Improving dbt with Jinja
Learn to enhance your dbt projects with Jinja by streamlining code, reducing redundancy, and improving maintainability. You'll practice using variables, loops, and macros to build more efficient transformation workflows.
Introducing Jinja with dbt50 xpWarming up with dbt compile100 xpWarming up with dbt compile 2100 xpUsing dbt compile to debug100 xpSetting variables with dbt Jinja100 xpSetting variables with dbt Jinja 2100 xpComplex usage of jinja with dbt50 xpUsing Jinja for loops on repeated SQL 1100 xpUsing Jinja for loops on repeated SQL 2100 xpMacros with Jinja100 xpTrimming whitespaces with Jinja100 xpRecap: dbt case study50 xp
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.collaborators
Join over 18 million learners and start Case Study: Building E-Commerce Data Models with dbt today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.