Oracle OBIA Training in Hyderabad

1. what is a BI Application? In a generic sense, it is simply a complete pre-built BI and Data Warehouse system. It encompasses ETL, a data model, a technology platform, metadata and pre-built analyses and reports. Just download the software and the application configuration files, install, load the data and you are ready to go. In some cases it really is that simple. A full BI application, such as Oracle's, contains everything professionally done by an engineering team at the direction of not only technical experts, but also industry and functional experts. A basic BI application goes far beyond "industry standard data models", and would include all necessary ETL, data model, BI tool Metadata, and pre-built reporting content. Some may even go further to include change data capture or integrations with other consumers such as front end applications, portals, advanced data services, or even other BI tools. Within Oracle's world of applications, there is some potential for confusion given their names. Oracle presently sells three different OBI EE base applications; 2 of them are called Fusion Intelligence (there is one for Oracle EBS & DBI, and another for PeopleSoft & JD Edwards). Note that these applications are officially not part of Oracle's direction, and will not be actively pursued. Instead Oracle is focusing on it BI crown jewel, the poorly named BI Applications. It is these BI Applications, which include nearly 50 modules such Applications as Marketing Analytics, Partner Analytics, Service Analytics, and Sales Analytics that this post is discussing. Why Create a BI Application? The answer is identical to why we have ERP systems today. SAP, PeopleSoft, Oracle EBS, Baan, Siebel, Clarify, etc were all built with the same thought in mind: a customer can buy a fully functioning system instead of going through the risk, cost and delay of building it themselves. It just started with the front end systems first. Now that the vast majority of the fortune 2000 companies have standardized on one or a few ERPs, the ability to make a pre-built BI system becomes possible. Only with clearly defined data models existing throughout so many companies is cost effective to have pre- built ETL, and with pre-built ETL comes the vast majority of the benefit of the BI Apps from an effort perspective. Course content Data warehousing Concepts Introduction Data Warehousing Decision Support and OLAP Oracle Business Intelligence Application Overview Introduction to OBIEE-11G Overview of Oracle BI components Metadata Training Gather information to Start building Business Model Defining the Repository Structure Building simple Fact Measures validating, Testing and deploy the Repository variables –Session /Repository Overview of Aggregates Aggregates implementation. Best Practices

2. OBIA Oracle Business Intelligence Applications 11 g Analysis and Dashboards Introduction to Analysis Dashboards Building Create Analysis with Different views Best Practices 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 OBIEE Vs OBIA Data Warehouse Administration Console (DAC) Overview of Extract Transform and Load OBIA Informatica Architecture Install and Configure the Informatica OBIA Informatica Components Extraction, Transformation and Load process used to load the OBAW Identifying Tables, Tasks and Mapping Used to support ETL Process Source Dependent Extract (SDE) and Source Independent Extract(SIL) Exploring Out of box Mappings Install the Data Warehouse Administration Console (DAC) Install and configure the OBAW Explore DAC objects, tasks, subject areas, Execution Plans Customizing DAC Metadata Create a New Custom Container Create a Custom Execution Plan Schedule and Run the Execution Plan Troubleshooting Load process Overview of Customizations to the OBAW Best Practices OBI Apps Metadata Introduction to OBIA Applications OBIA Architecture RPD Metadata Analytics prebuilt Dashboards/Reports Security Best Practices Create Analysis Pre packaged Analysis with Different views Pre packaged Dashboards Best Practices

3. OBIA Oracle Business Intelligence Applications Data Linage Explore and understand the Data linage from different sources systems Elaborated sessions on BI App (Finance, procurement, SCM) Financials Business Process Source Data model Physical Data model Logical Data Model Financials Specific configuration Financial Analytics Dashboards /Reports Business Process Procurement Source Data model Physical Data model Logical Data Model Procurement Specific configuration Procurement Dashboards /Reports Supply Chain Management Business Process Source Data model Physical Data model Logical Data Model SCM Specific configuration SCM Analytics Dashboards /Reports Real Time Exclusive Live Scenario Populate custom tables from Oracle EBS to OBIA using Informatica and DAC (video file) Project on BI apps Mock Resumes/Interview Highly designed material /Hands on Labs