This course explains some advanced topics for the DataFlux technology through a combination of hands-on exercises, demonstrations, and classroom discussions.

The self-study version of this course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.

The e-learning includes:

• digital course notes for self-study
• Virtual Lab: 30 hours of hands-on software practice.

This course can help prepare you for the following certification exam(s): SAS Data Quality Steward for SAS 9.

Learn how to develop advanced skills and techniques of working with DataFlux Data Management Studio, including

• working with the DataFlux Expression Engine Language (EEL)
• creating custom metrics
• using macro variables
• using multiple locales in a data job
• creating process jobs.

Who should attend

Data quality stewards

Formats available	Standard Duration
Classroom:	3.0 days
e-Learning:	21 hours/180 day license	System Requirements

Before attending this course, you should attend DataFlux® Data Management Studio: Essentials or have equivalent knowledge.

This course addresses DataFlux Data Management Studio, DataFlux Data Management Server software.

Introduction

• overview of course topics
• introduction to course data

DataFlux Expression Engine Language (EEL)

• introduction to DataFlux Expression Engine Language (EEL)
• data profiling using Expression Engine Language (EEL)
• working with the Expression node: IF/ELSE statements
• working with the Expression node: RETURN statement
• working with the Expression node: Pushrow function
• working with the Expression node: grouping functionality

Custom Metrics, Macros, and More!

• introduction
• working with custom metrics
• working with macro variables
• using multiple locales in a data job

Process Jobs

• introduction to process jobs
• using variables in process jobs
• exploring conditional processing, work tables, and events
• exploring parallel processing using events
• exploring parallel processing using the Fork node
• exploring parallel processing using the Parallel Iterator node

Tips, Tricks, and Other Topics

• discuss how data is processed in a data job
• discuss job optimization
• discuss various tips for building and testing jobs
• discuss a command-line command for deployed jobs
• discuss topics for promoting to production