Nghiên cứu tình huống: Xây dựng mô hình dữ liệu E-Commerce với dbt

Get 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.

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.

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.