Oracle BI Applications 11g: Implementation using ODI

Overview

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.

Objectives

  • 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

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

    Syllabus

    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

  • Training provider

    Teaching mode: Classroom - Instructor Led
    Duration: 3 days
    Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

    Our pricing

    We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

    New courses are happening all the time

    Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

    Top skills covered in this course

    Oracle Database
    Worldwide
    This skill has an average salary of
    US$96,355
    and is mentioned in
    2.77%
    of job ads.
    Analytics
    Worldwide
    This skill has an average salary of
    US$98,432
    and is mentioned in
    6.05%
    of job ads.
    Business intelligence
    Worldwide
    This skill has an average salary of
    US$95,777
    and is mentioned in
    1.27%
    of job ads.