Dataform Intro Course

50+
courses held
4.8
score rating
100+
participants
CTRL ACADEMY

Dataform is a powerful tool for managing workflows and transformations within BigQuery.

This course is perfect for data professionals, analysts, and marketers who want to streamline data workflows in Google BigQuery using Dataform. You’ll learn how to optimize pipelines, manage complex transformations, and structure data efficiently when handling GA4 data.


We’ll cover installation, setup, and core functionalities, including SQLX, dependencies, and workflow execution. You’ll also explore advanced features like incremental tables, assertions, and workflow settings.


Two code lab session after the course day gives you the opportunity to work directly with the instructor to get answers to your specific questions. By the end of the session, you’ll have a solid foundation to integrate Dataform into your data strategy.

"I got chills. This is a game-changer for anyone working with BigQuery!"

Course Program

Introduction

  • An overview of the course objectives
  • Discussion on the current state of your data operations

Why do we need Dataform?

  • Exploring the challenges in managing SQL queries
  • Benefits Dataform brings to data pipeline organization

Structure Data Library

  • Understanding how to structure your data assets effectively within Dataform
  • Optimized data management focusing on Google Analytics 4

What is Dataform

  • Introduction to Dataform’s core functionalities
  • SQLX, dependencies, and workflow executions

Advanced features

  • Deep dive into Dataform's advanced capabilities
  • Packages, documentation, workflow settings, incremental tables, assertions, and more

Setting up Dataform

  • Step-by-step instructions for installing and configuring Dataform

Setting up Data Workflows

  • Setting up a data warehouse with prepped tables
  • Optimized querying for Google Analytics 4 data

Demonstration of Dataform and common features

  • Demonstration of Dataform's interface
  • Highlighting common tasks and operations

Applications

  • Discussion on leveraging Dataform within your company
  • Solving data challenges effectively

Course Leaders

Johan Strand

Johan Strand is an expert in technical implementation and data management. With several years of experience in analytics and data warehousing, he possesses extensive expertise in BigQuery and Dataform to optimize data flows and decision support for businesses. Johan has long shared his knowledge by lecturing and leading courses, both in professional training programs and at schools, where he teaches technical implementations and advanced data management solutions.

Johan Strand
Corporate Course
32,000 SEK ex. VAT
12 attendees (+1995 SEK pp)
Location: Remote or @Office
Full Day
Individual Registration
4,000 SEK ex. VAT
Location: Remote
Full Day
Bundled Offer
9,800 SEK ex. VAT
Location: Remote
Individual Registration
Certification