Course Overview
This 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.
Benefits to You
Enrolling in this course gives you the opportunity to view demonstrations of the installation steps and then perform post-installation set up of Oracle Business Intelligence Applications, Oracle Business Analytics Warehouse and Oracle Data Integrator. After the installation, expert Oracle University instructors will help you explore the prebuilt ETL metadata that ships with the products. This will help you gain an understanding of the ETL process and the relationships between the architecture components.
Explore Oracle Business Intelligence Applications Configuration
After the initial exploration, you use Oracle Business Intelligence Applications Configuration Manager and Functional Setup Manager to configure Oracle Business Intelligence Applications. You then use Configuration Manager to create, generate, execute, and monitor load plans, which run the ODI ETL processes that move data from a transactional source system into the Oracle Business Intelligence Warehouse.
Customize ODI ETL Metadata Objects
After the data is loaded, you'll learn how to use ODI Studio to customize ODI ETL metadata objects and the Oracle Business Intelligence Warehouse to accommodate new data for analysis. You will also develop the knowledge and skills to manage Oracle Business Intelligence Applications security and performance.
Who should attend
- Data Modelers
- Business Intelligence Developer
- Data Warehouse Developer
- Data Warehouse Administrator
- Application Developers
- Business Analysts
- Data Warehouse Analyst
- Technical Consultant
Prerequisites
Suggested Prerequisites:
- Experience in Business Intelligence
- Knowledge of Data warehouse design
- Knowledge of Dimensional modeling
- Knowledge of ETL
Course Objectives
- 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 Architecture
- Oracle Business Analytics Warehouse Content
- Installing Oracle Business Intelligence Applications
- Understanding the ETL Process
- Functional Configuration for Oracle BI Applications
- Administering and Maintaining Functional Configuration Data
- Managing Load Plans
- Customizing the Oracle Business Analytics Warehouse
- Building a Category 1 Customization
- Building a Category 2 Customization
- Oracle BI Applications Security
- Managing Performance