DataFlux Data Management Studio: Fast Track

This course covers the majority of content of both DataFlux Data Management Studio: Essentials and DataFlux Data Management Studio: Advanced.

Duration 4 Days
Certificate SAS Global
Language English

Fees 48000 + taxes


Power up your staff’s skills and boost your business

or Call us on +91 79 403 270 00


Course Description

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..

About Program

This course covers the majority of content of both DataFlux Data Management Studio: Essentials and DataFlux Data Management Studio: Advanced. It introduces DataFlux Data Management Studio and expands your knowledge by including 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..

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.

Format of Training

All the benefits of the classroom without the travel:

Led by an expert instructor who can virtually look over your shoulder. Discuss, share, exchange ideas with students from different countries

Classroom training options include courses offered in our regional training centers or via our Live Web classroom.

Taught by certified instructors at high-tech facilities across the country

  • A SAS expert at your side.
  • Focused learning away from the office
  • Networking opportunities
  • State-of-the-art facilities
  • Electronic course notes downloadable to your device and permission to print
  • Business Knowledge Series: in-depth courses on the latest business topics
  • We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.

Train when and where you want

  • Eliminate travel costs and time away
  • Enjoy award-winning e-Courses

SAS e-Learning courses do not include SAS software. You must have SAS software installed to complete the practice exercises.

Prerequisite

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

Training Features

 

  • understand 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.

Course Curriculum

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 (self-study)
  • 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 (Self-Study)

  • 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 Studies

  • case study for "essentials"
  • case study for "advanced"

Project

  • creating data collections (self-study)
  • designing data explorations
  • creating data profiles
  • designing data standardization schemes

FAQs

Each exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. Computer-based in format, SAS Global Certification exams comprise multiple-choice and/or short-answer questions, depending on the exam. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. Candidates are allotted varying time limits to complete the exam, depending on which exam is taken. Specific exam content and passing criteria are located within each exam. To encourage your feedback, SAS Global Certification exams include a feature that allows candidates to comment on specific test questions. Your opinions are important to us and are a critical component in test development. Additionally, SAS Global Certification requires candidates to accept the terms of the SAS Institute Inc. Certification Program CandidatCancele Agreement before taking a certification exam.

Short-answer questions require you type your answer in a text box, rather than select your answer from four options. Typically, you will provide a numeric answer or a short section of SAS programming code. When entering code, case is ignored, and all variations of SAS syntax that correctly complete the program are accepted as correct.

Course Fees

Classroom

  

  

48000

+ Applicable Taxes
Enroll Now

Live Web

  

  

48000

+ Applicable Taxes
Enroll Now