OBIEE Apps for eBus (O1045) Training Course

Training Course Objectives

Learn and practice step by step procedures for installing, designing, customizing, and configuring Oracle Business Intelligence Applications and Oracle Business Intelligence Warehouse. The course begins with an exploration of Oracle BI Applications components, Informatica mappings and architecture along with the steps to install and configure Oracle BI Applications, OBAW, and Informatica. Gain an understanding of the ETL process and the relationships between the architecture components by exploring and practice designing the Informatica and DAC components. The practice labs involve running a execution plan to load Oracle E Business Suite data into the OBAW. After the data is loaded, you learn how to customize the OBAW by adding columns to an existing dimension table, and adding a new dimension.

Whether you are planning to implement OBIEE and want to evaluate the product or you've implemented OBIEE and want to get the most from out of your investment, iTrain OBIEE courses are built to give you the knowledge and skills you need.

Who Should Attend

• Application Developers
• Data Warehouse Administrators
• Data Modelers
• OBIEE Administrators
• Data Warehouse Developers

Training Course Prerequisites

• Knowledge of Informatica
• Introduction to SQL
• Experience with BI
• Knowledge of DB Modelling and Design
• eBusiness Schemas and APIs

Training Course Duration

4 Days

Training Course Contents

Objectives

• Explore Oracle Business Intelligence Applications and Architecture
• Learn the Oracle Business Analytics Warehouse foundational concepts and architecture
• Install and configure Oracle BI Applications
• Explore the prebuilt extract, transform, and load ETL metadata for Oracle BI Applications
• Use the Data Warehouse Administration Console to run ETL routines to populate the OBAW
• Customize DAC metadata
• Customize and extend the OBAW

Topics

• Oracle Business Intelligence Applications Architecture Overview
• Installing and Configuring Oracle BI Applications and Related Components
• Working with Informatica Designer
• Working with Informatica Workflow Manager
• Exploring SDE and SIL Mappings
• Working with the Data Warehouse Administration Console
• Customizing DAC Metadata and Running and Execution Plan
• Customizing the Oracle Business Analytics Warehouse
• Adding Columns to an Existing Dimension Table
• Adding a New Dimension in OBAW
• Managing OBAW Performance

Next Available Dates

• 13th Sep 2010  Edinburgh
• 20th Sep 2010  London
• 12th Oct 2010  London
• 19th Oct 2010  Leeds