Instructor-led training
Oracle Bi Applications 11g: Implementation Using ODI Training in Cologne, Germany
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.
What you'll learn
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.
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
Training locations
Oracle Bi Applications 11g: Implementation Using ODI training across the U.S. and beyond.
We provide Oracle Bi Applications 11g: Implementation Using ODI training onsite and live online for organizations throughout the United States and internationally.
View all Oracle Bi Applications 11g: Implementation Using ODI training locations
- Wuppertal
- Cologne
- Mannheim
- Munster
- Freiburg
- Bielefeld
- Rostock
- Heidelberg
- Duisburg
- Erfurt
- Saarbrucken
- Hannover
- Bremen
- Magdeburg
- Kiel
- Hamburg
- Koblenz
- Bonn
- Essen
- Leipzig
- Dresden
- Kassel
- Stuttgart
- Potsdam
- Frankfurt
- Dusseldorf
- Furth
- Nurnberg
- Karlsruhe
- Lubeck
- Dortmund
- Chemnitz
- Osnabruck
- Munich
- Augsburg
- Berlin
- Wiesbaden
- Braunschweig
Train your team with HSG
Private, instructor-led training customized for your organization.
- Onsite or live online delivery
- Customized curriculum
- Training for groups of 3 or more
- Flexible scheduling
- Experienced instructors
Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com
Related training
Browse all Oracle, MySQL, Cassandra, Hadoop Database courses →
Ready to train your team?
Let's customize this training for your organization.
Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.