Oracle Business Intelligence Applications Online Training - Hyderabad

Oracle Business Intelligence Applications Online Training

This course is designed for those individuals on an implementation team who are responsible for performing extract, transform and load (ETL) routines from Oracle E-Business Suite (EBS) applications and other data sources into the Oracle Business Intelligence Applications and the Oracle Business Analytics Warehouse and how to use the Data Warehouse Administration Console (DAC) to design, configure, and manage the ETL process.
Oracle BI Apps Overview

•What is BI and why organizations need BI
•BI Architecture
•Oracle BI Apps Functional Architecture
•Oracle BI Apps Technical Architecture
•Analytics supported By BI Apps
•Overview of Components Involved in BI Apps
•ETL Architecture
•Data Extracting and Loading Process
•OBIEE Vs OBIA
•OBIA Security Integration
Oracle BI Apps Installation and Configurations
•BI Apps Implementation Methodology
•Pre Requisites (Software and Hardware)
•Installation Overview(Methodology)
•Meta Data Configurations
oOBIEE
oInformatica
oDAC
• Global Configurations of BI Apps
Human Resource Analytics
•Human Resource Analytics specific Configuration
•Physical Data Model Overview
•Logical Data Model Overview
•Configuration points
Supply Chain Management
•Supply Chain Management Analytics specific Configuration
•Physical Data Model Overview
•Logical Data Model Overview
•Configuration points
Financials
•Financials Specific configuration
•Physical Data Model Overview
•Logical Data Model Overview
•Configuration points

Naming Standards
•ETL Naming Standards
•OBIEE Naming Standards
Load Strategies
•Full Load
•Incremental Loads
Delete process
Slowly Chaining Dimensions

Customization Best Practices
•Customization Best Practices with real time examples
•Upgrade Strategies
•Customization Example
•Trouble Shooting
BI APPS Security Implementation
DATA WAREHOUSE ADMINISTRATION CONSOLE
•Overview on DAC (Data warehouse Administration Console)
•Architecture
•Overview on DAC Client
•Integrating Informatica with DAC
•Integrating Databases(Physical Data Sources) with DAC
•Creating Oracle Business Analytics warehouse for BI Apps
•Source System Containers
•Development process in DAC
oPhysical Folder
oLogical Folder
oSource System Folders
oTask
oTask Phases
oSubject Areas
oExecution Plan
oTask Groups
oConfiguration Tags
•Source System Parameters and Task Level Parameters
•Manage the Execution Sequence
•Scheduling and Email Configurations
•Managing the Target Table
•Managing the Index on tables through DAC
•Managing the Incremental and Full load based on the Refresh Dates.
•Monitoring of execution Plans
•Import/export of DAC Metadata
•Handling ETL Failures with DAC
•Navigating the DAC Interface and looking into all options




If you require any further information please do not hesitate to contact us
please feel free to mail us for demo session or call @ 9989754807
contact: trainings@keentechnologies.com
website url: httpwww.keentechnologies.com