Learn analytics engineering with dbt

A two-day, in-person training program that teaches analysts the tools and knowledge needed to own the entire analytics engineering workflow.

About dbt learn

Analytics engineering is the data transformation work that happens between loading data into your warehouse and analyzing it. At dbt Learn, the Fishtown Analytics team will teach analysts how to use dbt to manage that workflow. The only technical requirement needed for dbt Learn is a practical knowledge of SQL and a willingness to learn Bash, Git, and version control. Attendees will learn about:

Data Warehouses
Automated Testing
Modeling Strategies
Performance Optimization
Writing DRY code
and more!

Agenda

dbt fundamentals
Data warehouse design
Understanding dbt + your BI tool
Testing + Continuous Integration
Documentation + Sources
Package management
Design patterns

Work applications
KPIs for business units
Optimizing your SQL code
Using Jinja & creating a macro
Incremental models
Paired problem sets
Presenting technical knowledge

What to Expect

Before you begin:

Webinar for SQL Foundations and Bash/Git/Version Control

Meet with an instructor for 15min to discuss your goals

Detailed set-up instructions

During:

A two-day course, taught by three instructors from Fishtown Analytics 👋

What is dbt and how does it fit into the analytics ecosystem?

dbt fundamentals, including building and testing data models, snapshotting slowly changing dimensions, environment management, and deploying dbt projects to production

Data warehouse design: how we practice Kimball-style modeling in dbt

Documenting your warehouse with dbt Docs

Utilizing dbt to alert on data quality and recency issues

Using dbt’s package management to federate ownership of large dbt projects

Modeling for performance: building tables incrementally

Using Jinja and macros to create dynamic, DRY data models

How to model strategically while thinking about scalability

A paired problemset everyday which students will present at the end of the day

Access to presentations and a curated list of resources to further learnings

After:

A cohort of peers to network with and learn from

Two weeks post-program to ask your instructors for support

A verified dbt Learn certificate