OBIA 11G Course Content

Oracle Business Intelligence Applications (OBIA 11.1.1.8.1)
Ø  OBIA Installation Ø  OBIA Configuration Ø  OBIA ELT Work Ø  OBIA Reporting Work Ø  HR Analytics Ø  Financial Analytics v Course Duration :  30 Hrs (30 Days) v Training Mode    : Class Room/On Line v Training Method :Project Oriented.	Ø  Sales Analytics Ø  Supply chain Ø  OBIA Data Model Ø  Customizations Ø  CHAPTER WISE PPTs Ø  CHAPTER WISE HANDSONS Ø  CHAPTER WISE RECORDINGS

v Oracle Business Intelligence Applications Overview

Ø  Oracle BI Applications components

Ø  Business areas supported in Oracle BI Applications

v Oracle BI Applications Architecture

Ø  Oracle BI Applications components overview

Ø  Oracle BI Applications architecture overview

Ø  Oracle BI Applications product lifecycle overview

v 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

v Installing Oracle Business Intelligence Applications

Ø  Pre installation and deployment requirements

Ø  Installing Oracle BI Applications prerequisites

Ø  Installing Oracle BI Applications

Ø  Performing post-installation system set up tasks

v 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

v 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

v 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

v Managing Load Plans

Ø  Defining, generating, executing, and monitoring load plans

Ø  Troubleshooting and restarting load plans

Ø  Managing load plan parameters

v 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

v 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

v 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

v 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

v Managing Performance

Ø  Optimizing performance overview

Ø  Performance tuning recommendations