SAP - Course Details

DQXI30/31:CC(BOQ300) Data Quality XI 3.0/ 3.1: Core Concepts (BOQ300)

SAP Course Description:
In this four-day course, you will learn about creating, executing and troubleshooting batch jobs, using functions, scripts and transforms to change the structure and formatting of data, handling errors, cleansing address and firm data, and match and consolidate records. As a business benefit, by being able to create efficient data quality projects, you can use the transformed data to help improve operational and supply chain efficiencies, enhance customer relationships, create new revenue opportunities, and optimize return on investment from enterprise applications.
SAP Course Duration:
SAP Course Target Audience:
This course is designed for individuals responsible for implementing, administering, and managing data quality projects.
SAP Course Prerequisite:
Not applicable for this offering,Windows conventions,Basic database concepts
Course Content:
  • Describing Data Services 
       -Describe the purpose of Data Services 
       -Describe Data Services architecture 
       -Define Data Services objects 
       -Use the Data Services Designer interface

  • Defining Source and Target Metadata 
       -Use datastores 
       -Use datastore and system configurations 
       -Define file formats for flat files 
       -Define file formats for Excel files 
       -Define file formats for XML files

  • Creating Batch Jobs 
       -Work with objects 
       -Create a data flow 
       -Use the Query transform 
       -Use target tables 
       -Execute the job

  • Troubleshooting Batch Jobs 
       -Use descriptions and annotations 
       -Validate and tracing jobs 
       -Use View Data and the Interactive Debugger 
       -Use auditing in data flows

  • Using Functions, Scripts, and Variables 
       -Define built-in functions 
       -Use functions in expressions 
       -Use lookup functions 
       -Use variables and parameters 
       -Use Data Services scripting language 
       -Script a custom function

  • Using Platform Transforms 
       -Describe platform transforms 
       -Use the Map Operation transform 
       -Use the Validation transform 
       -Use the Merge transform 
       -Use the Case transform 
       -Use the SQL transform

  • Setting up Error Handling 
       -Set up recoverable work flows

  • Using Data Quality Transforms 
       -Describe the data quality framework and processes 
       -Describe Data Quality transforms

  • Using Address Cleanse 
       -Understand the purpose of address cleansing 
       -Prepare your input data for the Address Cleanse transforms 
       -Define the Address Cleanse transforms 
       -Work with global address data 
       -Complete an Address Cleanse transform

  • Using Data Cleanse 
       -Understand the purpose of data cleansing 
       -Describe strategies for Data Cleanse transforms 
       -Complete a Data Cleanse transform 
       -Understand parsing dictionaries 
       -Refine data cleansing results 
       -Set up Universal Data Cleanse

  • Matching and Consolidating Data 
       -Understand the purpose of matching and consolidating records 
       -Use the Match Wizard to set up matching 
       -Configure the Match transform manually using the Match Editor 
       -Perform post-match processing 
       -Define advanced match strategies