Developer & Data Engineer Training
Hands-on scripting with the ODSL language — build event workflows, timeseries, smart curves, quality checks, and automated data pipelines. Includes the full QuickStart Developer track and general tutorials.
Core concepts, data model, and your first hands-on exercises with events and timeseries.
Core Concepts
The OpenDataDSL data model — objects, services, events, timeseries, datasets, and quality checks.
Working with Events in ODSL
Create a training environment, define event types, add and update events using ODSL scripts.
Working with Events in Excel
Download, edit, and upload events using the OpenDataDSL Excel Add-in.
Build derived timeseries from events and apply currency and unit conversions.
Creating EventTimeSeries
Build EventTimeSeries from event lists with filters and custom index fields.
Smart TimeSeries
Apply currency and unit conversions using expression-based SmartTimeSeries.
Forward Curves
Coming SoonConstruct and manage forward curves from event data and Smart Curve expressions.
Configure dataset monitoring, write quality check functions, and track daily data delivery.
Dataset Monitoring
Configure datasets in the portal to track expected daily delivery and completeness.
Quality Checks in ODSL
Write quality and critical check functions and attach them to a dataset.
Alerts & Notifications
Coming SoonConfigure alerts for delivery failures and quality check violations.
Schedule data loads, automate curve builds, and integrate with external systems.
Introduction to Automations
Coming SoonCreate and schedule automations to trigger scripts and data workflows.
Loading External Data
Coming SoonUse extractors and transformers to load data from FTP, HTTP, and cloud storage.
ETRM Integration
Coming SoonMap data identities to downstream ETRM systems using data identities.
A fast-paced track covering all aspects of ODSL development — from language basics through to ETL and automation.
ODSL Code Basics
Variables, looping, conditional statements and testing.
Variable Types
Scalars, dates, durations, calendars, timeseries, curves, and custom types.
Functions
Built-in string, date, list, statistical, and curve functions. Writing your own.
Services
Active variables, variable services, remote services, and external data services.
Searching
Finding and filtering data, unique values, profiles, and geo-spatial queries.
Data
Creating, saving, and updating TimeSeries and Curve data.
Analysis
Aggregation pipelines, distinct queries, and statistical functions.
ETL
Extracting from URLs and files, transforming with pipelines, loading via batch.
Automation
Workflows, actions, phases, processes, and cron scheduling.
Topic-specific tutorials covering tooling, environments, searching, timeseries, and smart curves.
Running ODSL Code
All the ways to run code in VS Code — full script, region, and selected text.
Working with Data Environments
Creating, switching, listing, and deleting data environments.
Smart Curves
Creating, testing, and chaining Smart Curves with single and multiple inputs.
Searching with the find Command
Full syntax reference and service-by-service examples for the find command.
Working with TimeSeries
Calendars, observations, statuses, saving, and reading back timeseries data.