Oracle - Course Details

OraBIA796I Oracle Business Intelligence Applications 7.9.6 Implementation

Oracle Course Description:
Participants will gain substantial hands-on experience using the Data Warehouse Administration Console in a controlled lab environment where they load a Warehouse that will be verified by using the OOTB Dashboards and Reports built for Oracle BI Enterprise Edition (OBI EE). In addition participants will gain high-level working skills with Informatica PowerCenter tools by creating a custom ETL to load the Data Warehouse. Finally participants will customize OBI EE to create new Dashboard content using the data loaded by the custom ETL.
Oracle Course Duration:
3 DAYS
Oracle Course Target Audience:
Administrator,Business Analysts,Business Intelligence Developer,Data Warehouse Administrator,Data Warehouse Analyst,Data Warehouse Developer,Database Designers
Oracle Course Prerequisite:
NONE
Course Content:
  • Oracle BI Applications Overview

    • Describe the Oracle Business Intelligence Applications
    • Describe major application components
    • Describe integration with transactional applications

  • BI Applications Architecture

    • Describe the Oracle Business Intelligence Applications Architecture
    • Understand basic integration between Oracle EBS and BI Applications

  • DAC Overview

    • Use the tools and views of the Data Warehouse Administration Console (DAC)
    • Describe DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBAW) extract, transform, and load (ETL)

  • Order Management Analytics Overview

    • Describe the functional aspects of the Order Management Analytic Application
    • Describe at a high-level the technical aspects of the Order Management Analytic Application

  • DAC Execution (Order Management) – Warehouse Load

    • Configure the DAC for a full load of the OBAW
    • Start and monitor a full load of the OBAW from the DAC
    • Describe the overall process for using the DAC

  • DAC Execution Review

    • Describe aspects of an OBAW load using the DAC

  • Warehouse Load Confirmation – OBI EE

    • Use Oracle BI EE to confirm the load of the OBAW
    • Describe the components of the OBI EE infrastructure

  • Oracle Business Analytics Warehouse (OBAW) Overview

    • Describe the contents of the Oracle Business Analytics Warehouse
    • Describe the warehouse tables

  • OBAW Customization Overview

    • Describe the recommended customization practices for the Oracle Business Analytics Warehouse (OBAW)
    • Describe specific aspects of each customization approach

  • Informatica Overview and Custom ETL

    • Use the various Informatica tools
    • Describe Informatica components and artifacts, how they relate to each other, and their roles in the overall ETL process
    • Describe the process for creating a Custom ETL process using the Informatica Tools

  • DAC Custom Configuration and Execution

    • Describe the process for creating new artifacts in the DAC to support a Custom ETL process
    • Execute a Custom ETL using the DAC

  • OBI EE Customization

    • Describe the process modifying the OBI EE Repository to include new content in the OBAW
    • Describe the process for incorporating new content into the OBI EE Dashboards

  • BI Applications Integration with Oracle Applications

    • Describe the options for integrating Oracle Business Intelligence Applications with the various Oracle Applications

  • BI Apps Security and Flexfield Support

    • Describe the options for security and access control for Oracle Business Intelligence Applications
    • Describe the options for handling EBS Flexfields within the OBAW and BI EE frameworks