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. Attendees will learn about:

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

The only technical prerequisite is a working knowledge of SQL. Prior familiarity with the command line and version control is helpful but not necessary.

Agenda

Day One - Foundations

  • Analytics engineering in 2020
  • dbt fundamentals
  • dbt Project Design
  • Testing & Continuous Integration
  • Data sources + freshness
  • Documenting data models
  • Collaboration Session

Day Two - Applications

  • Polishing your dbt Project
  • Jinja - the templating language behind dbt
  • dbtonic Jinja
  • Importing Packages and Projects
  • dbt Materializations & Incremental Models
  • Patterns + techniques
  • Collaboration Session

What to Expect

Before you begin:

  • Guided tutorial for getting started with dbt on Snowflake
  • Primers for SQL Foundations and Bash/Git
  • During:

  • A two-day course, taught by instructors from Fishtown Analytics 👋
  • Integrated working sessions for hands-on exploration of dbt features
  • Dedicated time for questions and small group working sessions
  • Access to presentations for reference and training your team
  • After:

  • A cohort of peers to network with and learn from
  • Office Hours to meet with your instructors 1-2 weeks after the course
  • A verified dbt Learn certificate
  • Interested in attending a future session?

    FAQ

    Is there a free online version?

    Our self-service version of Learn is currently in development and we are eager to put it into production. The dbt docs are an excellent resource in the meantime for learning dbt and analytics engineering.

    Who should attend dbt Learn?

    If some of the following statements are true for you, then dbt Learn will likely be a good fit:

    • I'm thinking about building models incrementally.
    • My dbt project doesn't have tests.
    • I'm interested in learning about the latest workflows and tools in analytics.
    • I am unsure how to debug errors.
    • I want the official dbt training.
    • I'm not someone who regularly adopts new software just by reading documentation.

    We have found dbt Learn to be particularly powerful for the following roles:

    • Data Analysts who have been using dbt for ~3 months.
    • Self-starters in the analytics space - some working SQL knowledge
    • Data Engineers who are new to dbt
    • Data Team Managers
    • Analytics Consultants

    Is it possible to see a course syllabus ahead of time?

    We are constantly updating and improving on dbt Learn! We provide registered students with a detailed agenda a few weeks before each session. The agenda lists some topic areas we always cover and our lessons are available to preview.

    The cost of the event is prohibitive for me, is there any flexibility on the price?

    We are committed to making dbt, and knowledge of analytics engineering, accessible to as many people as possible. To that end, we have a diversity scholarship available to decrease or waive the cost of participation.