Oracle BI Applications 11g: Implementation using ODI Training

Oracle BI Applications 11g: Implementation using ODI Training (D82531GC10)

Introduction:

Oracle BI Applications 11g: Implementation using ODI Training Hands-on

This Oracle BI Applications 11g: 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.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

● Application Developers
● Business Analysts
● Business Intelligence Developer
● Data Modelers
● Data Warehouse Administrator
● Data Warehouse Analyst
● Data Warehouse Developer
● Technical Consultant

Oracle BI Applications 11g: Implementation using ODI Training (D82531GC10)Related Courses:

Duration: 5 days

Class Prerequisites:

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

Skills Gained:

● Identify and describe the extract, transform, and load (ETL) concepts, products, components, and processes related to Oracle Business Intelligence Applications
● Identify and describe the products, architecture, and key components of Oracle Business Intelligence Applications
● Identify and describe the content of Oracle Business Analytics Warehouse
● Install and set up Oracle Business Intelligence Applications and supporting technology
● Identify and describe the prebuilt Oracle Data Integrator ETL metadata for Oracle Business Intelligence Applications
● Use Configuration Manager and Functional Setup Manager to configure Oracle BI Applications
● Use Configuration Manager to create, generate, execute, and monitor load plans
● Describe the concepts and techniques for customizing ETL functionality in Oracle Business Intelligence Applications
● Use Oracle Data Integrator Studio to customize ETL metadata objects and the Oracle Business Intelligence Warehouse
● 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 Content:

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

Request More Information

Time Frame: 0-3 Months4-12 Months

No Comments Yet.

Leave a comment