OBIEE 11g and OBIA CONTENT

Oracle Business Intelligence Enterprise Edition (OBIEE 11g / 10g)
1)     DW CONCEPTS 2)     OBIEE 11g 3)     OBIEE 10g 4)     BI PUBLISHER 11g 5)     BI PUBLISHER 10G 6)     INFORMATICA 7)     DAC v  Course Duration              :  80 Hrs (45 Days) v  Training Mode                  : Class Room /On Line v  Training Methodology      : Real-time Project Oriented.	8)      OBIA 9)      LIVE PROJECTS 10)   ODI 11)   SQL 12)   CHAPTER WISE PPTs 13)   CHAPTER WISE HANDSONS 14)   CHAPTER WISE RECORDINGS

Data Warehouse concepts

1. What is Data
2. Types of Data
3. Types of Databases
4. What is Data Warehouse?
5. Data Warehouse Architecture
6. Difference between OLTP Vs OLAP
7. Types of Columns
8. Types of Tables
9. What is schema and types of Schemas
10. Difference between Star and Snow Flake Schemas

OBIEE 11g

OBIEE Introduction :

1. Why Oracle BI ?
2. What is Oracle BI?
3. History of Oracle BI
4. Oracle BI architecture 11g Vs 10g
5. Oracle BI components 11g Vs 10g

OBIEE 11G Practitioner Level

Administration

1.     Repository Basics

2.     Building the Physical Layer of a Repository

3.     Building the BMM Layer of a Repository

4.     Building the Presentation Layer of a Repository

5.     Testing Repository

6.     Working with  Multiple Logical Table Sources

7.     Adding Calculations to Fact Table

8.     Creating Dimensional Hierarchies& Level based measures

OBIEE 11G Lerner Level

Presentation Services or Analytics

1. Introduction to Presentation Services
2. What is Web Catalog & Instanceconfig.xml
3. Difference between Shared Folders & My Folders

Answers

1. Working with OBI Answers
2. OBI Column Properties
3. Style ,Column Format ,Data Format , Conditional Format ,Intraction and Write Back
4. Hide Column
5. Edit Formulas / Report level Calculations
6. Filters
7. Column ,image and Variable Prompts
8. Sorting of Columns
9. OBI 17 Views
10. Combining  With Similar Request
11. Direct Database Requests

Dashboards

1. Creating Oracle Business Intelligence Interactive Dashboards
2. Working With Dashboard Objects
3. Column , Section ,Link or Image ,Embedded Content ,Text, Folder, Action Link ,Action Link Menu ,Alert Section
4. Hiding or showing Section Dynamically based on condition
5. Working With Dashboard Prompts
6. Column ,Image and Variable Dashboard Prompts
7. Presentation Variables
8. Request Variable

Delivers

1. Introduction to Oracle BI Delivers
2. Oracle BI Deliveries Tables
3. Configuring delivery devices
4. Adding delivery profiles
5. Developing Agents
6. Building Alerts
7. Creating Agents Based on Time
8. Creating Agents Based on Time and Condition
9. Creating Chain of Agents

Job Manager

1. Monitoring Agents

Oracle BI for Microsoft Office

1. Introduction to Oracle BI for Microsoft Office
2. Installation of Oracle BI for MS Office
3. Accessing OBI reports in MS Excel
4. Accessing OBI Reports in MS Power Point

Catalog Manager

1. Deploying Dev to test or test to prod
2. Deploying in Offline or Online Mode
3. Catalog Back Up and Restore
4. Providing Permissions
5. Documentation of Web Catalog

OBIEE 11G Specialist Level

1. Using Aggregate Tables
2. Using Partitions and Fragments
1. Value Based
2. Fact Based
3. Level Based
3. Variables
1. Static Repository
2. Dynamic Repository
3. Repository Initialization Blocks
4. System Session
5. Non System Session
6. Session Initialization Blocks
7. Row Wise Initialization Blocks
8. Presentation Variables
9. Request Variables
4. Time Series Functions
1. AGO
2. TODATE
3. PERIODROLLING
5. Configuring Many To Many Relationships
1. Bridge Table
2. Helper Table

6. Deploying Oracle Bi application to multiple countries
1. Localizing Oracle BI Metadata
2. Localizing Oracle BI Data
7. Setting Implicit Fact Column
8. Third Party Reporting Tool Integration
9. Creating Repositories From Multi dimensional Data Sources
10. Security
1. Authentication
1. LDAP
2. External Table
2. Authorization
1. Object Level
1. RPD
2. Web Catalog
2. Data / Row  Level
11. Administering Usage Tracking
12. Multi-User Development Environment (MUDE)
13. Utilities
14. Cache Management
15. Optimizing Query Performance
16. Cluster Servers
17. Alias ,Circular Joins & Opaque Views or Select Tables

OBIEE 11 G Advanced New Features

1. Introduction about EM, CONSOLE, ANALYTICS, XMLPSERVER..etc
2. Parent Child Hierarchies
3. Unbalanced Hierarchies
1. Ragged Hierarchies
2. Skipped Hierarchies
4. Hierarchical Columns and Selection Steps
5. Action Links
6. Creating Simple Action Links
7. Creating Advanced Action Links
8. Master Detail Reports
9. Creating  KPI
10. Creating KPI Watch List
11. Creating Scorecards
12. Assign ID columns to descriptive columns
13. Using Lookup Table
14. Horizontal Federation
15. Vertical Federation
16. Combined Horizontal & Vertical Federation

Deployment

1. Moving RPD and Web Catalog from Development server to Testing Server
2. Moving RPD and Web Catalog from Testing Server to Production Server

Migration

1. Under Standing Pre Migration Process
2. Understanding Upgrade Assistant Wizard
3. Migrating from OBIEE 10G to OBIEE 11G
4. Under Standing Post Migration Process

BI Publisher11G & 10G

1. Introduction to BI Publisher or XML publisher
2. Integrating database
3. Integrating Oracle BI Presentation server
4. Integrating Oracle BI Discoverer
5. Configuring BIP Scheduler
6. Installing Oracle BI Publisher Desktop
7. Develop BI Publisher Templates Directly From Data Base
8. Working with Parameters and List Of  Values (LOVs)
9. Develop BI Publisher Templates  using OBI Answer Request
10. Develop BI Publisher Templates using OBI Subject Areas
11. Develop BI Publisher Templates using XML file
12. Scheduling BI Publisher templates
13. Deployment of BIP reports
14. Integrating BIP reports in OBIEE dashboard

Informatica 9.5

1. INFORMATICA 9 Introduction
2. INFORMATICA 9 Installation
3. Server Installation
4. Client Installation
5. Informatica Administration Console
6. Repository Manager
7. Configuring RRITEC Database
1. Configuring source database
2. Configuring Target database

8. Hands on 01_Source_Target_Import
1. Exercise 1: Import a Source Schema
2. Exercise 2: Import a Target Schema
9. Hands on 02_Creating_mapping
1. Exercise 1: Create a Mapping
10. Hands on 03: Creating Workflow           
1. Exercise 1: Create a Workflow
2. Exercise 2: Create source and target database connections
3. Exercise 3: Create a Task and Run the Workflow
4. Exercise 4: Monitor the Workflow
11. Hands on 04: Flat file Filter
1. Exercise 1: Import Source and Target
2. Exercise 2: Create the Mapping
3. Exercise 3: Create and Run the Workflow

DAC

1. AC Installation
2. Configuring DAC
3. Configuring Source & Target Data Base
4. Configuring Informatica repository Service
5. Configuring Informatica Integration Service
6. Creating Container
7. Configuring Informatica Physical Folder
8. Creating Informatica Logical Folder
9. Mapping Informatica Physical and Logical Folders
10. Creating Task Phases
11. Creating primary source
12. Creating Target source
13. Creating Tasks
14. Creating Task Group
15. Creating Subject Areas
16. Creating Execution Plans
17. Understanding Execution Plan Parameters
18. Scheduling  Execution Plans
19. Deployment
1. Export
2. Import
20. Creating OBAW Data Model

OBIA

1.     Oracle Business Intelligence Application Overview

2.     Oracle Business Intelligence Application Overview and Architecture

3.     Oracle Business Analytics Warehouse Content

4.     Installing the OBIA

5.     Deploying Informatica Repository

               1.      Understanding the ETL Process

               2.      Exploring SDE , SIL and PLP Mappings

               3.      Assigning Integration server

               4.      Changing source and target database connections

6.     Deploying DAC

               1.      Importing DAC repository

               2.      Copying container

               3.      configuring database and Informatica connections

7.     Deploying OBAW

               1.      Creating OBAW data Model

               2.      Understanding types of OBAW tables

8.     Loading OBAW database

9.     Customizing the Oracle Business Analytics Warehouse

10.   Deploying RPD of OBIA

11.   Deploying Web Catalog of OBIA

12.   Understanding pre defined reports and Dashboards

13.   Types of Analytics

               1.      CRM Analytics

               2.      ERP Analytics

               3.      Industrial Analytics

14.   Human Resource Analytics

15.   Sales Analytics

16.   Faineance Analytics

Live Projects: (Three Projects on BANKING ,HEALTH CARE & IME)

1. Gathering Requirement
2. Understanding& Analyzing  Requirement
3. Developing Business Specification Document
4. Developing High Level Design Document
5. Developing Low level Design Document
6. Following Unique Coding Standards

Oracle Data Integration(ODI)

1.  Data Warehouse Concepts

2.  Introduction to Oracle Data Integrator

3.  ODI Installation

4.  ODI Component Architecture

5.  Creating Master and Work Repository

       5.1 Create the Master Repository

       5.2 Create the Work Repository

6.  Configuring RRITEC database

          6.1 Configuring source database

          6.2 Configuring Target database

7.  Creating and Managing Topology

       7.1 Creating Physical Architecture

       7.2 Creating Logical Architecture:

       7.3 Creating Contexts 45

 8.  Creating Model

 9.  Creating Project

10. Components

    10.1 Projector Components

    10.2 Selector Components

11. Create a Mapping using expression

      Create a Mapping using Flat File and Filter

12. . Create a Mapping using Split
13. . Create a Mapping using Joiner
14. . Create a Mapping using Lookup
15. . Create a Mapping using Sort
16. . Create a Mapping using Aggregate
17. . Create a Mapping using Distinct
18. Create a Mapping using Set Component

BY RAMREDDY (12+ Years of EXP & 190+ Batches EXP)