About this course

Course code TPDQ25DMFT
Duration 4 Days

This course covers the majority of content of both DataFlux Data Management Studio: Essentials and DataFlux Data Management Studio: Advanced It introduces and expands the knowledge of DataFlux Data Management Studio and includes topics for data explorations and profiling, data jobs to perform data management tasks (such as data quality and entity resolution), data monitoring, usage of DataFlux Expression Engine language, custom metrics, macro variables and process jobs.

Prerequisites

There currently are no prerequisites for this course.


Who should attend?

Data Quality Stewards

Delegates will learn how to

  • create and review data explorations
  • create and review data profiles
  • create data jobs for data improvement
  • establish monitoring aspects for your data
  • work with the DataFlux Expression Engine Language
  • create and use custom metrics
  • define and use macro variables
  • create process jobs.

Outline

Introduction and Course Flow

  • introduction
  • course flow

DataFlux Data Management Studio: Getting Started

  • introduction
  • quality knowledge base and reference sources
  • data connections

Working Through the PLAN Phase of the DataFlux Methodology

  • creating data collections
  • designing data explorations
  • creating data profiles
  • designing data standardization schemes

Working Through the ACT Phase of the DataFlux Methodology

  • introduction to data jobs
  • data quality jobs
  • data enrichment jobs (self-study)
  • entity resolution jobs


Working Through the MONITOR Phase of the DataFlux Methodology

  • defining business rules
  • data profiling with business rules and alerts
  • data jobs with business rules
  • data jobs with monitoring tasks

Additional Topics

  • multi-input/multi-output data jobs
  • using data job references within a data job
  • introduction to DataFlux Data Management server

Staging

  • overview of remaining course topics
  • clean data, new repositories, default macro variables

DataFlux Expression Engine Language

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

Custom Metrics, Macros, and More

  • working with custom metrics
  • working with macro variables
  • using multiple locales in a data job (self-study)

Process Jobs

  • introduction to process jobs
  • using variables in process jobs
  • conditional processing, work tables, and events
  • parallel processing in process jobs (self-study)

Tips, Tricks, and Other Topics

  • how data is processed in a data job
  • job optimization
  • tips for building and testing jobs
  • deploying jobs
  • promote to production
  • case study (self-study)

Case Studies

  • case study for 'essentials'
  • case study for 'advanced'


Software Addressed:

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

4 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.