Oracle Business Intelligence Applications – OBIA Training V1.0

Current Status
Not Enrolled
Price
Closed
Get Started
Course
Materials

Oracle Business Intelligence Applications (OBIA) is a pre-built business intelligence solution that delivers intelligence across an organization, empowering users at all levels from front line operational users to senior management with key information that maximizes effectiveness. These solutions allow organizations to rapidly deploy business intelligence throughout their organization without the traditional cost and time associated with defining, designing and developing a custom data warehouse, ETL, metadata, reports and dashboards.

In This Module We Will Learn :

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

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

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

Tools used to manage Oracle BI Applications security

  • Oracle BI Applications security levels
  • Exploring default security settings for Oracle BI Applications
  • Exploring ODI security

Optimizing performance overview

  • Managing Performance
  • Performance tuning recommendations

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