Overview:

This course will integrate a combination of instructor-led discussions and interactive workshops to illustrate the abilities of BusinesObjects Data Services toolset. This seminar will focus on data warehousing concepts, role of the Data Services, defining source and target metadata, creating batch jobs, use of built-in transformations, creation of data filters, use of built-in functions, transforming data from a flat file, working with time dimensions, data flow optimization, changed data capturing, working with XML data, perform data cleansing, populating Fact and Dimension tables, role of variables and parameters, handling errors and exceptions, migration of projects, use of the Web administrator and managing our metadata.

Audience:

This course is designed for individuals responsible for implementing, administering and managing projects that involve Data Services 4.0.

Prerequisites:

Each student should have a basic of data warehousing concepts, experience with an RDBMS and knowledge of SQL language

Objectives

Upon conclusion, each participant will have acquired these skills:

• Understand Data Warehousing Concepts
• Illustrate the role of BusinessObjects Data Services
• Defining Source and Target Metadata
• Creating and executing a Batch Job
• Working with relational, flat file and XML data
• Depict the validating, executing and debugging of jobs
• Demonstrate the use of built-in Transforms
• Illustrate the usage of built-in Functions
• Define the optimization of a Data Flow
• Illustrate how to easily manage change and metadata from disparate systems
• Depict how to audit data throughout the extraction, transformation, and load (ETL) process
• Depict the ability to cleanse our corporate data
• Demonstrate the use of variables, parameters and Scripting
• Understand the capturing of changes in data
• Improve data integrity through demonstrated data lineage
• Handling Errors and Exceptions
• Supporting a multi-user environment
• Migrating Projects between Design, Test and Production Phases
• Using the Web Administrator
• Understand how to manage metadata