Next term
Not scheduled
If you are interested, please contact us
1-day
Data analysts, Analytics Engineer, Data Engineer
data warehouse, data analytics, dbt, ETL, ELT, data transformation, sql
icon repair

Modern Data Pipelines with DBT

In this one day workshop, you will learn how to create modern data transformation pipelines managed by DBT. Discover how you can improve your pipelines’ quality and workflow of your data team by introducing a tool aimed to standardize the way you incorporate good practices within the data team.

Requirements

  • SQL fluency - ability to write data transforming queries.

    Basic understanding of ETL processes.

    Basic experience with command-line

    Laptop with stable internet connection (participants will connect to Jupyter Notebooks  pre-created on Google Cloud Platform)

Training outcome

During the workshops participants will follow a shared step-by-step guideline with an overview from the perspective of augmenting the Data Team workflow with the dbt tool. We will work through typical data transformation problems you can encounter on a journey to deliver fresh & reliable data and how DBT can help to solve them. Jupyter Notebook environments will be provided for each participant.

Course agenda*

Part 1

Introduction to DBT

  • Framework overview

  • Typical use cases

  • Impact on data transformation development

Part 2

Core concepts of DBT

  • Data models

  • Seeds, sources

  • Tests

  • Documentation, maintenance and data lineage

  • Hands-on exercises

Part 3

Advanced DBT features

  • Macros & hooks

  • Snapshots

  • Extensions

  • Other tools to integrate with (overview only)

  • Hands-on exercises

Part 4

Scheduling, deployment, workflow

  • GID DataOps Data Platform

  • Airflow

  • DBT cloud

  • Hands-on exercises

* GetInData reserves the right to make any changes and adjustments to the presented agenda.

Instructors

Our workshops and training programmes are organised by experienced instructors with many years real-life Big Data experience. Get to know our team!

More information

All participants will get training materials in the form of PDF files containing slides with theory and exercises manual with the detailed description of all exercises.

Contact person

Klaudia Wachnio
+48 663 422 641
Piotr Krewski
+48 888 185 137

Testimonials

Completed in half the estimated time and with a fivefold improvement on data collection goals, the robust product has exponentially increased processing capabilities. GetInData’s in-depth engagement, reliability, and broad industry knowledge enabled seamless project execution and implementation.

Wojciech Ptak
CTO

GetInData had been supporting us in building production Big Data infrastructure and implementing real-time applications that process large streams of data. In light of our successful cooperation with GetInData, their unique experience and the quality of work delivered, we recommend the company as a Big Data vendor.

Miłosz Balus
CTO

GetInData delivered a robust mechanism that met our requirements. Their involvement allowed us to add a feature to our product, despite not having the required developer capacity in-house.

Stephan Ewen
CTO

Their consistent communication and responsiveness enabled GetInData to drive the project forward. They possess comprehensive knowledge of the relevant technologies and have an intuitive understanding of business needs and requirements. Customers can expect a partner that is open to feedback.

Wilson Yu Cao
Development Team Manager

We sincerely recommend GetInData as a Big Data training provider! The trainer is a very experienced practitioner and he gave us a lot of tips regarding production deployments, possible issues as well as good practices that are invaluable for a Hadoop administrator.

Mariusz Popko
Platform Manager

The engineers and administrators at GetInData are world-class experts. They have proven experience in many open-source technologies such as Hadoop, Spark, Kafka and Flink for implementing batch and real-time pipelines.

Kostas Tzoumas
CEO

Other Big Data Training

  • Machine Learning Operations Training (MLOps)

    Machine Learning Operations Training (MLOps)

    This four-day course will teach you how to operationalize Machine Learning models using popular open-source tools, like Kedro and Kubeflow, and deploy it using cloud computing.
  • Hadoop Administrator Training

    Hadoop Administrator Training

    This four-day course provides the practical and theoretical knowledge necessary to operate a Hadoop cluster. We put great emphasis on practical hands-on exercises that aim to prepare participants to work as effective Hadoop administrators.
  • Advanced Spark Training

    Advanced Spark Training

    This 2-day training is dedicated to Big Data engineers and data scientists who are already familiar with the basic concepts of Apache Spark and have hands-on experience implementing and running Spark applications.
  • Data Analyst Training

    Data Analyst Training

    This four-day course teaches Data Analysts how to analyse massive amounts of data available in a Hadoop YARN cluster.
  • Real-Time Stream Processing

    Real-Time Stream Processing

    This two-day course teaches data engineers how to process unbounded streams of data in real-time using popular open-source frameworks.

Contact us

Interested in our solutions?
Contact us!

Together, we will select the best Big Data solutions for your organization and build a project that will have a real impact on your organization.

The administrator of your personal data is GetInData Sp. z o.o. Sp.k with its registered seat in Warsaw (02-508), 39/20 Pulawska St. Your data is processed for the purpose of provision of electronic services in accordance with the  Terms & Conditions. For more information on personal data processing and your rights please see  Privacy Policy.

By submitting this form, you agree to our Terms & Conditions and Privacy Policy