Leveraging the Power of QKB in SAS Technology Components Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

This Leveraging the Power of QKB in SAS Technology Components training course assists SAS users with accessing the components of the Quality Knowledge Base (QKB) from within a variety of SAS technology components.

By attending Leveraging the Power of QKB in SAS Technology Components workshop, delegates will learn to:

Configure SAS technology components to use the Quality Knowledge Base (QKB)
Access the QKB functionality from within SAS applications and SAS code
Use SAS Data Integration Studio transformations that access Quality Knowledge Base components
Use the Cleanse Data directive in SAS Data Loader for Hadoop to access Quality Knowledge Base components
Use data quality methods in SAS Federation Server queries to access the Quality Knowledge Base components
Execute data quality expressions in SAS Event Stream Processing models to access the Quality Knowledge Base components.

Experience with SAS programming techniques, including working with DATA step code
Familiar with the SQL procedure
General understanding of SAS macro language
Familiar with one or more of the following: SAS Data Integration Studio, SAS Data Quality Accelerator, SAS Data Loader for Hadoop, SAS Federation Server, or SAS Event Stream Processing.

The Leveraging the Power of QKB in SAS Technology Components class is ideal for:

Any SAS user who wants to leverage the power of the Quality Knowledge Base (QKB) from SAS applications and SAS code

Introduction to the Quality Knowledge Base (QKB)

Describe the functionality that is available in the Quality Knowledge Base (QKB)
Identify some applications that use the QKB definitions for data-cleansing purposes
Identify the installation location of the QKB
Name the types of files in a QKB installation
Understand the structure of the QKB

Configuration Options for Accessing the QKB from within SAS

Describe the SAS Data Quality Server functionality
Identify the requirements for the use of the QKB in SAS applications
List the ways that SAS applications can be configured to the QKB
Describe the options for configuring the SAS platform to the QKB
Identify the SAS autocall macros for interacting with the QKB
Explore the syntax for working with the macros
Provide code examples for using the macros

SAS Data Quality Server Procedures, Functions, and CALL Routines

Identify the code options available in SAS Data Quality Server
Identify the functions available for listing locales
Describe the use of the DQLOCLST procedure
Review the concept of standardization
Identify the CALL routine available for standardizing data values
Describe the use of the DQSCHEME procedure
Describe the use of the DQMATCH procedure
Identify the parsing and extraction functions that are available from SAS Data Quality Server
Identify the identification analysis and gender analysis functions that are available from SAS Data Quality Server
Identify the casing functions and pattern analysis functions that are available from SAS Data Quality Server

SAS Data Integration Studio Transformations That Access the QKB

Configure SAS Data Integration Studio to use the QKB
Identify the data quality transformations available in SAS Data Integration Studio
Demonstrate the use of the User Written Code transformation to set data quality options

SAS Data Quality Accelerators for In Database Access to the QKB

Identify the required SAS Data Quality Accelerator components
Identify the purpose of SAS Data Loader for Hadoop
Define the use of directives
Describe the five steps in the data preparation methodology

SAS Federation Server Functions That Access the QKB

SAS Federation Server technology components
Create fedsql views
Use data quality methods in fedsql

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

Leveraging the Power of Quality Knowledge Base (QKB) in SAS Technology Components