Oracle Business Intelligence Applications (OBIA) Training

• How to install and configure Oracle BI apps?
• How to implement the OBIA applications with the industry’s best practices?
• How to deal with the pre-built star schemas in Oracle Business Analytics Warehouse?
• How to know the key benefits of understanding OBIA?
• How to cover Oracle OBIA architecture in detail?

• Recorded Videos After Training
• Digital Learning Material
• Course Completion Certificate
• 24x7 After Training Support

• Administrators
• Analysts
• Architects
• Developers
• Implementers
• Oracle End Users

• Oracle Business Intelligence Applications (OBIA) Course does not demand any specific set of prerequisites. A professional who is looking for a career in Oracle Business Intelligence can take up this course.

• PR Tech Skills will provide you with a training completion certificate after completing this Oracle Business Intelligence Applications (OBIA) Training.

Module 1: Oracle Business Intelligence Applications Overview

• Oracle BI Applications components
• Business areas supported in Oracle BI Applications

Module 2: Oracle BI Applications Architecture

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

Module 3: 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

Module 4: 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 

Module 5: 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 

Module 6: 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 

Module 7: 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

Module 8: Managing Load Plans

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

Module 9: 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 

Module 10: 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 

Module 11: 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 

Module 12: 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

Module 13: Managing Performance

• Optimizing performance overview
• Performance tuning recommendations