Business and IT training from QA

Oracle BI Applications 11g Implementation using ODI

This Oracle BI Applications: Implementation Using ODI training provides step-by-step procedures for installing,
configuring, managing, and customizing Oracle Business Intelligence Applications and Oracle Business Intelligence
Warehouse. It begins by exploring Oracle BI Applications components and architecture.

About this course

Course type Essentials
Course code OC11GBIODI
Duration 3 Days

What you will learn

This Oracle BI Applications: Implementation Using ODI training provides step-by-step procedures for installing,
configuring, managing, and customizing Oracle Business Intelligence Applications and Oracle Business Intelligence
Warehouse. It begins by exploring Oracle BI Applications components and architecture.

Learn To:
Identify and describe the products, architecture and key components of Oracle Business Intelligence Applications.
Use Configuration Manager and Functional Setup Manager to configure Oracle BI Applications.
Identify and describe the security features of Oracle Business Intelligence Applications.
Manage the performance of Oracle Business Intelligence Applications and Oracle Business Analytics Warehouse.

Benefits to You
Enrolling in this course gives you the opportunity to view demonstrations of the installation steps and then perform
post-installation set up of Oracle Business Intelligence Applications, Oracle Business Analytics Warehouse and Oracle
Data Integrator. After the installation, expert Oracle University instructors will help you explore the prebuilt ETL metadata
that ships with the products. This will help you gain an understanding of the ETL process and the relationships between
the architecture components.

Explore Oracle Business Intelligence Applications Configuration
After the initial exploration, you use Oracle Business Intelligence Applications Configuration Manager and Functional
Setup Manager to configure Oracle Business Intelligence Applications. You then use Configuration Manager to create,
generate, execute, and monitor load plans, which run the ODI ETL processes that move data from a transactional
source system into the Oracle Business Intelligence Warehouse.

Customize ODI ETL Metadata Objects
After the data is loaded, you'll learn how to use ODI Studio to customize ODI ETL metadata objects and the Oracle
Business Intelligence Warehouse to accommodate new data for analysis. You will also develop the knowledge and skills
to manage Oracle Business Intelligence Applications security and performance.

Audience
Application Developers
Business Analysts
Business Intelligence Developer
Data Modelers
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Technical Consultant

Prerequisites

  • Experience in Business Intelligence
  • Knowledge of Data warehouse design
  • Knowledge of Dimensional modeling
  • Knowledge of ETL

Delegates will learn how to

  • Identify and describe the extract, transform, and load (ETL) concepts, products, components, and processes related to
  • Oracle Business Intelligence Applications
  • Identify and describe the products, architecture, and key components of Oracle Business Intelligence Applications
  • Identify and describe the content of Oracle Business Analytics Warehouse
  • Install and set up Oracle Business Intelligence Applications and supporting technology
  • Identify and describe the prebuilt Oracle Data Integrator ETL metadata for Oracle Business Intelligence Applications
  • Use Configuration Manager and Functional Setup Manager to configure Oracle BI Applications
  • Use Configuration Manager to create, generate, execute, and monitor load plans
  • Describe the concepts and techniques for customizing ETL functionality in Oracle Business Intelligence Applications
  • Use Oracle Data Integrator Studio to customize ETL metadata objects and the Oracle Business Intelligence Warehouse
  • Identify and describe the security features of Oracle Business Intelligence Applications
  • Manage the performance of Oracle Business Intelligence Applications and Oracle Business Analytics Warehouse

Outline

Oracle Business Intelligence Applications Overview
Oracle BI Applications components
Business areas supported in Oracle BI Applications

Oracle BI Applications Architecture
Oracle BI Applications components overview
Oracle BI Applications architecture overview
Oracle BI Applications product lifecycle overview

Oracle Business Analytics Warehouse Content
Pre-built star schemas in Oracle Business Analytics Warehouse
Oracle Business Analytics Warehouse naming conventions
Overview of Oracle Business Analytics Warehouse tables
System columns in Oracle Business Analytics Warehouse tables

Installing Oracle Business Intelligence Applications
Preinstallation and deployment requirements
Installing Oracle BI Applications prerequisites
Installing Oracle BI Applications
Performing post-installation system set up tasks

Understanding the ETL Process
ETL phases and processing overview
Using ODI Studio to explore prebuilt ETL metadata
Full ETL and incremental ETL
Change capture
ETL versus ELT

Functional Configuration for Oracle BI Applications
Functional configuration overview
Terminology related to Oracle BI Applications configuration
Configuration Manager overview
Functional Setup Manager overview
Creating an implementation project
Assigning configuration tasks to developers

Administering and Maintaining Functional Configuration Data
Functional configuration data overview
Administering and maintaining domains and domain mappings
Editing domain members
Administering and maintaining data load parameters
Administering and maintaining reporting parameters

Managing Load Plans
Defining, generating, executing, and monitoring load plans
Troubleshooting and restarting load plans
Managing load plan parameters

Customizing the Oracle Business Analytics Warehouse
Customization types and scenarios overview
Overview of category1 and category 2 customizations
Impact of patches on customizations
Applying an update strategy

Building a Category 1 Customization
Adding columns to existing tables in the OBAW
Creating custom ETL mappings for a category 1 customization
Enabling versioning for a category 1 customization
Generating DDL scripts for a category 1 customization
Creating and executing a load plan for a category 1 customization

Building a Category 2 Customization
Adding a new dimension table to the OBAW
Creating custom ETL mappings for a category 2 customization
Enabling versioning for a category 2 customization
Generating DDL scripts for a category 2 customization
Creating and executing a load plan for a category 2 customization

Oracle BI Applications Security
Tools used to manage Oracle BI Applications security
Oracle BI Applications security levels
Exploring default security settings for Oracle BI Applications
Exploring ODI security

Managing Performance
Optimizing performance overview
Performance tuning recommendations

Essentials

3 Days

Duration
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.