Online OBIEE 12c Training

Oracle Business Intelligence 11g Training will be conducted through Web Conference where we share our screen to audience and will show all the topics starting from installation practically, which includes explanation of real-time scenarios and interview questions for each topic. Once the session is done, we will share recorded session to audience, so that they go through the topic again when they find free time.

Duration:  4 Weeks – Daily 1 Hour/Weekend 2 Hours | Mail: | Call +91-9573543334

Data Warehouse concepts

  • Need of Data Warehouse
  • Data Warehousing
  • Data Warehouse Architecture
  • Data Acquisition
  • Types of Tables
  • schema and types of Schemas
  • Data Mart?
  • Data Warehousing Approaches


  • Installing OBIEE 12c on Windows
  • Installing OBIEE 12c on Linux
  • Migrating RPD and Webcat from lower versions to 12c

 OBIEE Introduction

  • Why Oracle BI ?
  • What is Oracle BI?
  • History of Oracle BI
  • Oracle BI architecture Lower Versions Vs 12c
  • Oracle BI components Lower Versions Vs 12c

 OBIEE Administration

  • Repository Basics
  • Building the Physical  Layer of a Repository
  • Building the BMM Layer of a  Repository
  • Building the Presentation  Layer of a Repository
  • Testing Repository
  • Working with  Multiple  Logical Table Sources
  • Adding Calculations to Fact Table
  • Creating Dimensional  Hierarchies  & Level based measures
  • Using Aggregate Tables
  • Parent Child Hierarchies
  • Ragged and Skipped hierarchies
  • Using Lookup Table
  • Using Partitions and Fragments
  • Variables (Repository, session, presentation &Request)
  • Modeling Time Series Data & Time based  Measures
  • Configuring Many To  Many Relationships(Bridge  &Helper Table)
  • Deploying Oracle Bi application  to multiple countries
    • Localizing Oracle BI Metadata
    • Localizing Oracle BI Data
  • Setting Implicit Fact Column
  • Third Party Reporting Tool Integration
  • Creating Repositories  From Multi-dimensional  Data Sources
  • Administering Usage Tracking
  • Multi-User Development  Environment (MUDE)
  • Utilities
  • Cache Management
  • Repository Design Principles
  • Disconnected Analytics
  • Alias ,Circular Joins & Opaque Views or Select  Tables

 Presentation Services or Analytics

  • Introduction to presentation Services
  • Introduction about EM, CONSOLE, ANALYTICS,  XMLPSERVER…etc
  • What is Web Catalog & instance  con fig file
  • Shared Folders, My folders, Shared Filters, My Filters ,My Briefing   Books

 Analytics Reporting

  • Working with OBI Answers
  • OBI Column Properties
  • Drill
  • Navigation
  • Conditional formatting
  • OBI Formulas
  • OBI Filters
  • OBI Sorting
  • OBI Views
  • OBI Request Level Prompts
  • Cascading Prompts
  • Combining With Similar Request
  • Direct Database Requests

 OBIEE Dashboards

  • Oracle Business Intelligence  Interactive  Dashboards
  • Dashboard Objects
  • Section
  • Link or Image
  • Column
  • Embedded Content
  • Text
  • Folder
  • Guided Navigation Link(Static  , Conditional  and section )
  • Briefing Book Navigation Link
  • Advanced Reporting,  Master Detail Linking
  • Simple Action Links
  • Advanced Action Links
  • Dashboard Prompts
  • Types of Dashboard Prompts
  • Page level prompts
  • Dashboard level prompts
  • Presentation Variables
  • Request Variable
  • Scorecards
  • KPI

OBIEE Delivers

  • Introduction to Oracle BI Delivers
  • Developing IBOTS
  • Configuring delivery devices
  • Adding delivery profiles
  • Building Alerts

Job Manager

  • Configuring Job Manager
  • Monitoring Scheduled requests

Oracle BI for Microsoft Office

  • Introduction to Oracle BI for Microsoft Office
  • Working with Oracle BI content in Microsoft  Office  applications

Catalog Manager

  • Documentation of Web Catalog
  • Deploying Development to test or test to prod

 BI Publisher

  • Introduction to BI Publisher  or XML publisher
  • Integrating database
  • Integrating Oracle BI Presentation  server
  • Integrating Oracle  BI Discoverer
  • Configuring Scheduler
  • Installing Oracle BI Publisher Desktop
  • Develop BI Publisher Templates using OBI Answer Request
  • Develop BI Publisher Templates using OBI Subject  Areas
  • Develop BI Publisher Templates Directly From Data  Base
  • Develop BI Publisher Templates using XML file
  • Parameters and List Of  Values (LOVs)
  • Scheduling BI Publisher templates
  • Bursting

 OBIEE Security

  • Authentication and Authorization
  • Creating Users and Groups
  • Object Level Security
  • Data Level Security
  • Presentation Catalog  Permissions(Full Control, NoAccess, Change/Delete, Read, Traverse Folder)
  • Presentation Catalog  Privileges(Granted, Denied)

Live Tasks

  • Gathering Requirement
  • Understanding & Analyzing Requirement
  • Developing Business  Specification Document
  • Developing High Level Design  Document
  • Developing Low level Design  Document
  • Following Unique  Coding Standards

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."