Wednesday 9 March 2016

OBIEE 12C





Oracle Business Intelligence Enterprise Edition (OBIEE 12C/ 11G)
1)     DW CONCEPTS
2)     OBIEE 12C
3)     OBIEE 11G
4)     BI PUBLISHER 12C
5)     INFORMATICA
6)     DAC
v  Course Duration              :  75 Hrs (45 Days)
v  Training Mode                  : Class Room / On Line
v  Training Methodology    : Real-time Project Oriented.
7)     OBIA 7964
8)     LIVE PROJECTS
9)     CHAPTER WISE PPTs
10)  CHAPTER WISE HANDSONS
11)  CHAPTER WISE RECORDINGS
Data Warehouse concepts
Text Box: Online Training, Corporate Training, project support & outsourcing available  

  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 12C

OBIEE Introduction :

  1. Why Oracle BI ?
  2. What is Oracle BI?
  3. History of Oracle BI
  4. Oracle BI architecture 12C Vs 11G
  5. Oracle BI components 12C Vs 11G

OBIEE 12C 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



  1. Creating Dimensional Hierarchies& Level based measures
OBIEE 12C 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. Text Box: Online Training, Corporate Training, project support & outsourcing available 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 12C 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

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

OBIEE 12C Advanced Level
  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
OBIEE 12c Data Visualization
  1. Creating Your First Visual Analyzer Project
  2. Data Mashups
  3. BI Ask
  4. Visual Analyzer and the Web Catalog

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 Publisher 12C
  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.6
  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

  1. Hands on 01_Source_Target_Import
    1. Exercise 1: Import a Source Schema
    2. Exercise 2: Import a Target Schema
  2. Hands on 02_Creating_mapping
    1. Exercise 1: Create a Mapping
  3. 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
  4. 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 11G
  1. Text Box: Online Training, Corporate Training, project support &outsourcing available DAC 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 7964
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:
  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
  7. HR analytics
  8. Finance Analytics
  9. Sales Analytics

BY RAM REDDY (12+ Years of EXP & 180+ Batches EXP)

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)