Oracle BI Applications 11g: Implementation using ODI

Course Fees: $4788.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 3 days
Course Manual

Sorry, no course dates found

  • 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.

  • 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.
  • 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.
  • 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.
    • Application Developers
    • Business Analysts
    • Business Intelligence Developer
    • Data Modelers
    • Data Warehouse Administrator
    • Data Warehouse Analyst
    • Data Warehouse Developer
    • Technical Consultant
    • 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
    • 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