Tweakstreet Foundation Course

This 5-day instructor-led course provides a strong foundation for working with Tweakstreet. It is aimed at Data engineers, Data analysts, and Data architects.

Participants gain a solid understanding and plenty of hands-on experience with key concepts and workflows through exercise labs.

Fact Sheet

Goals Participants are self-sufficient working data projects with Tweakstreet.
Delivery By experienced instructor online or in-person on-site.
Languages English or German.
Price EUR 1200 per participant.
Travel and accommodation expenses if instructor delivers course on-site.
Deliverables Instructor’s slide deck with reference solutions to all exercise labs.
Prerequisites Computer with stable internet connection. Administrative access to a local SQL database – such as Postgres or MySQL – for SQL exercise labs.
Tailoring We’re happy to tailor topics to your needs. Mix, match, or remove topics to suit your needs and budget.

Course Overview

Module 1 – Tweakstreet platform

  • Introduction
  • Components
  • Configuration
  • The Workbench
  • Control Flows
  • Data Flows
  • Formulas
  • The CLI

Module 2 – Reading and writing files

  • CSV
  • Text
  • XML
  • JSON
  • Microsoft Excel

Module 3 – SQL databases

  • JDBC Data Sources
  • SQL Scripting
  • Writing data to databases
  • Reading data from databases
  • Dimension Insert / Update

Module 4 – Data Transformation

  • Validation
  • Grouping
  • Sorting
  • Joining
  • Lookups

Module 5 – Project Organization

  • Shared Modules
  • Environment Management