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.
-
By the end of this training you will Learn To :
- Install Oracle BI Applications including the Informatica PowerCenter ETL Infrastructure on Windows
- Create a custom ETL to load the Data Warehouse. Finally participants will customize OBI EE to create new Dashboard content using the data loaded by the custom ETL
- Load a Warehouse that will be verified by using the OOTB Dashboards and Reports built for Oracle BI Enterprise Edition (OBI EE)
Course Contents
Day 1
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
Day 2
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
Day 3
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
Day 4
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
Day 5
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
Comments
wxzjdzcvcxbnrox whk
RSS feed for comments to this post