Course : TRN 301 : Oracle BI Applications 7.9.5/6 “Bootcamp”

Overview : This course is designed for customers and Oracle partners who wish to quickly bring a development team up to speed with the Oracle BI Applications 7.9.5/6. Over four days, the basics of Oracle BI Applications development and administration is covered, teaching delegates how to install, configure and then load data into the Oracle BI Applications data warehouse.

Like other Rittman Mead “Bootcamp” courses, the final day consists of a workshop where delegates will build on the knowledge they have gained to built a complete system based on an outline specification provided by the instructor. This unique approach gives delegates the chance to practice their skills away from step-by-step instructions and ensures that they are capable of delivering their own basic Oracle BI Applications “proof of concept” system.

The basics of Oracle BI Applications customization are also taught in this bootcamp course, so that delegates are aware of the customization process and can use this knowledge to properly estimate customizations for their project.

Duration : 5 Days

Course Delivery : Developers, consultants, project managers, technical leads, DBAs

Who Should Attend :End-users, developers, project managers

Prerequisites : none

Detailed Course Agenda :

Day 1

1. Introduction to BI Applications 7.9.5 and 7.9.6

2. Installation and Configuration

  • Understanding the BI Apps Architecture
  • Review configuration tasks
  • Setting up the DAC
  • Setting up RPD and Web Catalog

3. Performing the Initial Data Load

  • Creating an Execution Plan
  • Configuring an Execution Plan
  • Running the Execution Plan

Day 2

4. Inside the Oracle BI Applications Warehouse

  • Understanding the data warehouse data model model
  • Table categories and types
  • Use of constraints, indexes, summaries
  • Running basic reports
  • Lineage and Metadata

5. Customizing Existing ETL Routines, Facts and Dimensions

  • Understanding customization scenarios
  • Applying Category 1 customizations
  • Reflecting changes in the DAC Repository
  • Reflecting changes in the RPD

Day 3

6. Adding New ETL Routines, Facts and Dimensions

  • Applying Category 2 customizations
  • Reflecting changes in the DAC
  • Creating new Informatica SDE mappings
  • Creating new Informatica SIL mappings
  • Adding new facts and dimensions to the RPD

Day 4

7. Performance Optimization

  • Opportunities for Optimization
  • Profiling execution plans
  • Optimizing execution plans
  • Analyzing Execution Plans using Oracle BI EE

8. Running an Oracle BI Applications Project

  • Project Elements
  • Estimating timelines
  • Roles and Responsibilities
  • Project Methodologies
  • Issues and Risks

Day 5

9. Oracle BI Applications Workshop

  • Identify Data Sources
  • Create Execution Plan
  • Perform Initial Import
  • Debug and Resolve Issues
  • Run Audit Reports

To book this course for your organization, to customize this course or for more information, contact training@rittmanmead.com for more details.

Website Design & Build: tymedia.co.uk