BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

[email protected]

Oracle Business Intelligence Applications


Oracle Business Intelligence Applications Course Contents

 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
o OBIEE
o Informatica
o DAC
• Global Configurations of BI Apps

 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

Human Resource Analytics
• Human Resource Analytics 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
o Physical Folder
o Logical Folder
o Source System Folders
o Task
o Task Phases
o Subject Areas
o Execution Plan
o Task Groups
o Configuration 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

  • Request Demo