Skip to main content
search
0
CartClose Cart
dbt

dbt Training

Harnessing the power of a modern data platform to build a flexible and future-proof data pipeline with dbt.

Scalefree – Upcoming Data Vault 2.1 Trainings – dbt Training

Why dbt Training by Scalefree?

Scalefree is an experienced dbt partner and recognized as a leading expert. We set up and optimized various dbt environments at our clients and are the creators behind heavily utilized, open-source packages such as DataVault4dbt for best practice Data Vault modeling and TurboVault4dbt for automated dbt model creation. Next to our training, we publish regularly best practices with dbt on our blog and monthly dbt Expert Sessions.

Investing in your team’s skills with our private, customizable training programs ensures a solid foundation for building successful and scalable data platforms. Our training is customizable to fit your team’s needs and align them with industry best practices, significantly reduce expensive and typical blunders in projects, and ultimately enhance your team’s efficiency and collaboration.

Request Your
Customized Training

In this page:

Private & Customizable

We offer private classes for your team, starting with a minimum of 8 attendees and a maximum of 15 to ensure a focused and high-quality learning experience for every attendee. Our curriculum is fully customizable, allowing you to choose the learning blocks that are most relevant to your team’s needs and project goals.

Pricing Information

Our training is priced per seat, with discounts available for larger groups. Travel expenses are excluded.

  • 1-Day Training: 798 EUR/seat
  • 2-Day Training: 1,198 EUR/seat
  • 3-Day Training: 1,498 EUR/seat

How Long Should My Training Be?

The ideal duration of your training depends on your team’s existing skills and specific needs. We’ll discuss this in detail with a Scalefree expert during our first call to define a fitting agenda together.

3-Day Training: Comprehensive & Collaborative

Our most comprehensive offering allows enough time for all core sections and their synergy effects. This extended format provides ample room for trainers to address all questions from your team, ensuring every attendee leaves with a clear and holistic understanding.

Shorter Training: Focused & Efficient

Shorter training versions (1 or 2 days) are perfect for teams with existing dbt and Data Vault experience. These trainings allow for a deeper dive into specific areas of interest or challenges, providing targeted solutions and practical knowledge to overcome project hurdles.

Factors to Consider

  • Available Skills: The current knowledge level of your team.
  • Team Questions: The amount of questions or uncertainties your team has.
  • Specific Challenges: How much time should be dedicated to going deeper into specific challenges.

dbt Training Learning Blocks

Our customizable training is built from the following learning blocks. You can mix and match to create the perfect curriculum for your team.

dbt Introduction

  • Embedding dbt in a modern architecture
  • Why dbt is so powerful
  • dbt Core vs Platform

Core Elements of dbt

  • Models
  • Materializations
  • Project overview

Leveraging Templates

  • Jinja
  • Macros
  • Packages

Testing in dbt

  • Singular, Generic & Unit Tests
  • Testing a Data Vault with dbt
  • Writing Custom Tests

Deployment & Orchestration

  • Environments & Jobs in dbt
  • Git Strategy & Deployments
  • Model Versions

Working with dbt

  • Debugging
  • Exposures
  • Studio, CLI, Canvas & Co
  • Selectors & Hooks

Data Vault 2.1

  • Refresher of Hubs, Links, and Satellites
  • Modeling Events & Transactions
  • PITs and Bridges
  • Information Delivery in dbt

Growing Projects

  • Model Contracts
  • Dbt Mesh
  • Catalog

Beyond dbt

  • Best Practices
  • Recommendations and Standards

DataVault4dbt

  • Data Vault Stages
  • Hubs, Links, and Satellites
  • Snapshot Tables & PITs

TurboVault4dbt

  • Functionality
  • Advantages of standardization
  • Use Cases

Your Path to a Customized dbt Training

Request
Your Training
Fill out the form and request your customized training
Define
Agenda
Defining a fitting agenda for your team with a Senior Expert from Scalefree
Receive
Your Offer
Getting an official offer for the defined training
Training &
Empowerment
Your customized training is delivered and empowers your team in dbt
Request Your
Customized Training

Example of a 2-Day Training Agenda

This section outlines one example agenda from a past DataVault4dbt training. The agenda was designed for clients with existing dbt knowledge and focuses on the practical application, customization, and best practices of DataVault4dbt. The goal is to equip participants with the skills to set up, adjust, and leverage the tool for efficient and automated Data Vault implementation.

Day 1:
Mastering DataVault4dbt Fundamentals

On the first day, the focus is on understanding the core concepts and basic implementation of DataVault4dbt to build a raw Data Vault.

Morning Session:
DataVault4dbt Introduction & Setup

  • Welcome and Introductions: We’ll go over the workshop objectives and agenda.
  • Data Vault 2.0 Refresher & dbt Integration: We’ll cover the key concepts of Data Vault 2.0 (Hubs, Links, Satellites) and discuss why it’s a powerful combination with dbt.
  • Installing and Configuring DataVault4dbt: A hands-on tutorial on adding DataVault4dbt to your dbt project, running dependencies, and customizing global variables like hashing algorithms.
  • Hands-on Lab: Participants will set up their first DataVault4dbt project and integrate the package.

Afternoon Session:
Building the Raw Vault with DataVault4dbt Macros

  • Staging Data: We’ll explain the stage macro and the best practices for preparing source data for Data Vault loading.
  • Implementing Hubs, Links, and Satellites: A detailed explanation and practical application of DataVault4dbt macros for identifying business keys (Hubs), capturing relationships (Links), and storing attributes (Satellites).
  • Hands-on Lab: Participants will apply the concepts to populate their Raw Vault using prepared staged data.

Day 2:
Advanced DataVault4dbt & TurboVault for Automation

The second day dives into advanced features and automation, exploring how to leverage TurboVault for a metadata-driven development approach.

Morning Session:
Advanced DataVault4dbt & Best Practices

  • Advanced Features: Learn about creating Point-in-Time (PIT) tables for historical analysis and Bridge Tables to simplify reporting relationships. We’ll also cover incremental loading and performance optimization.
  • Best Practices and Design Patterns: We’ll discuss naming conventions, hashing strategies, and methods for testing and validating data quality within your Data Vault.
  • Hands-on Lab: Participants will implement PIT or Bridge tables and apply testing methodologies.

Afternoon Session:
TurboVault for Data Vault Automation

  • Introduction to TurboVault: Discover how TurboVault uses metadata-driven development to automate Data Vault implementation and reduce manual effort.
  • TurboVault Setup & Metadata Modeling: We’ll walk through the installation of TurboVault and the process of designing the five key metadata tables (Hub Entities, Link Entities, Hub Satellites, Link Satellites, Source Data).
  • Hands-on Lab: Participants will create sample metadata and use TurboVault to generate DataVault4dbt-compatible dbt models automatically.
  • Q&A and Next Steps: We’ll address specific questions, discuss integration into your existing data landscape, and provide resources for continued learning.

Request Your Customized Training

Ready to empower your team? Fill out the form and we will get back to you to discuss your customized training.

Tim Kirschke Senior Consultant

Tim Kirschke
Senior Consultant

Phone: +49 511 87989342
Mobile: +49 160 5399711

Close Menu