Hi, we are individual trainers working in CMMI level 5 companies and having alot of experience in OBIA Training. We provide training and Project Support in OBIEE,Informatica,DAC and OBIA.

Topics Covered

1. 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 2. 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 3. Human Resource Analytics • Human Resource Analytics specific Configuration • Physical Data Model Overview • Logical Data Model Overview • Configuration points 4. Supply Chain Management • Supply Chain Management Analytics specific Configuration • Physical Data Model Overview • Logical Data Model Overview • Configuration points 5. Financials • Financials Specific configuration • Physical Data Model Overview • Logical Data Model Overview • Configuration points 6. Naming Standards • ETL Naming Standards • OBIEE Naming Standards 7. Load Strategies • Full Load • Incremental Loads 8. Delete process 9. Slowly Chaining Dimensions 10. Customization Best Practices • Customization Best Practices with real time examples • Upgrade Strategies • Customization Example • Trouble Shooting 11. 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

Who should attend

NA

Pre-requisites

NA

What you need to bring

NA

Key Takeaways

NA