Detailed Course Outline
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