Oracle Bi Applications 11g: Implementation Using ODI Training in Toronto, Canada

Enroll in or hire us to teach our Oracle Bi Applications 11g: Implementation Using ODI class in Toronto, Canada by calling us @303.377.6176. Like all HSG classes, Oracle Bi Applications 11g: Implementation Using ODI may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Oracle Bi Applications 11g: Implementation Using ODI may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
This 3-day Oracle BI Applications: Implementation Using ODI training provides step-by-step procedures for installing, configuring, managing, and customizing Oracle Business Intelligence Applications and Oracle Business Intelligence Warehouse. It begins by exploring Oracle BI Applications components and architecture. Learn To: - 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.
Course Length: 3 Days
Course Tuition: $1690 (US)

Prerequisites

- Experience in Business Intelligence - Knowledge of Data warehouse design - Knowledge of Dimensional modeling - Knowledge of ETL

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

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.