About this course

Course code TPDQEX
Duration 1 Day

SAS Certifications are among the most globally recognised credentials in the industry. This event includes a study session in the morning followed by the SAS Data Integration Development for SAS®9 exam in the afternoon. Online certification tutorials are also available free of charge through the SAS Professionals TV on the SAS Professionals Network. Here are more details about exam topics, preparation and logistics.

Prerequisites

Prior to this event you should be knowledgeable in:

  • create and review data explorations and data profiles
  • create data jobs for data improvement
  • parameterize jobs and business rules within DataFlux Data Management Studio
  • create, maintain and apply business rules and tasks
  • understand the QKB components and various definition types
  • apply QKB components to address data quality issues
  • expand basic functionalities using Expression Engine Language (EEL)
  • use macro variables
  • create process jobs
  • configure the Data Management Server to run jobs

You can attain this knowledge by attending the DataFlux Data Management Studio: Fast Track and DataFlux Data Management Studio: Customize the Quality Knowledge Base (QKB) courses


Who should attend

  • Individuals wanting to sit the SAS® Certified Data Quality Steward for SAS 9 exam.

Delegates will learn how to

  • Understand the logistics for sitting the SAS Certified Data Quality Steward for SAS®9 exam
  • Improve specific areas of your SAS Data Management knowledge

Outline

During the morning session attendees choose what topics they'd like to cover from the list of examinable topics:

Navigating the DataFlux Data Management Studio Interface

  • Navigate within the Data
  • Management Studio Interface

Exploring and Profiling data

  • Create, design and be able to explore data explorations and interpret results
  • Define and create data collections from exploration results
  • Create and explore a data profile
  • Design data standardization schemes

Data Jobs

  • Create Data Jobs
  • Apply a Standardization definition and scheme
  • Apply Parsing definitions
  • Apply Casing definitions
  • Compare and contrast the differences between identification analysis and right fielding nodes
  • Apply the Gender Analysis node to determine gender
  • Create an Entity Resolution Job
  • Use data job references within a data job
  • Understand how to use an Extraction definition
  • Explain the process of the definition of pattern analysis

Business Rules Monitoring

  • Define and create business rules
  • Create new tasks

Data Management Server

  • Interact with the Data Management Server

Expression Engine Language (EEL)

  • Explain the basic structure of EEL (components and syntax)

Process Jobs

  • Work with and create process jobs

Macro Variables and Advanced Properties and Settings

  • Work with and use macro variables in data profiles, data jobs and data monitoring
  • Determine uses for advanced properties

Quality Knowledge Base (QKB)

  • Describe the organization, structure and basic navigation of the QKB
  • Be able to articulate when to use the various components of the QKB. Components include:
  • Define the processing steps and components used in the different definition types.

1 Day

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.