BusinessObjects Data Quality
Duration 4 Days
AudienceThe target audience for this course is anyone responsible for implementing, administering, and managing data qualilty projects.
PrerequisitesTo be successful, you must have working knowledge of Windows conventions & basic database concepts.
Synopsis
  • BusinessObjects TM Data Quality XI 3.0 enables you to parse, cleanse, standardize, consolidate, and enhance records.

  • 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 efficiences, enhance customer relationships, create new revenue opportunities and optimize return on investment from enterprise applications.
Objectives
Topics 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 most commonly used Data Quality transforms

    Using Address Cleanse
  • Explain the business need for Address Cleanse transforms
  • Describe strategies for Address Cleanse transforms
  • Describe global address data and USA address data that does not require USPS certification
  • Complete an Address Cleanse transform

    Using Data Cleanse
  • Explain the business need for Data Cleanse transforms
  • Describe strategies for Data Cleanse transforms
  • Complete a Data Cleanse transform
  • Understand parsing dictionaries
  • Customize dictionary entries

    Matching and Consolidating Data
  • Describe match concepts
  • Describe break group concepts
  • Describe post-match concepts
  • Tailor the match process to your data