Introducing the dbt case study

Case Study: Building E-Commerce Data Models with dbt

Susan Sun

Freelance Data Scientist

Why dbt?

dbt spans many sectors:

banking & financial services
e-commerce
education
government & civic tech
healthcare
renewable energy
transportation & logistics
... etc

dbt integrates well with the modern stack:

A diagram of dbt inside a sample tech stack

¹ https://docs.getdbt.com/docs/introduction https://www.getdbt.com/case-studies

A preview of what we are building

A generated diagram of dbt models

A preview of what we are building

Sample of dbt project:

Screenshot of a series of file directories auto-generated by dbt init subcommand. Top level folder is called looker e-commerce. Children folders are named analyses, macros, models, seeds, snapshots, and tests. There are also three miscellaneous files gitignore, dbt project yaml, and a readme markdown.

Recap of dbt commands:

# Checks if/where dbt is installed
which dbt 

# Checks the version of dbt installed
dbt --version

# Initializes a new dbt project
dbt init <project_name>

# Short for dbt --help
dbt -h

Let's practice!

Case Study: Building E-Commerce Data Models with dbt