OBIEE/ODI Developer

Oracle Business Intelligence 12c 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.

  • Training Type Online
  • Course Duration 4 Weeks, 10 Hrs/Week
$ 700

Want to know more?


  • Data Warehouse concepts
  • Installation
  • OBIEE Introduction
  • OBIEE Administration
  • Presentation Services or Analytics
  • Analytics Reporting
  • OBIEE Dashboards
  • OBIEE Delivers
  • Job Manager
  • Oracle BI for Microsoft Office
  • Catalog Manager
  • BI Publisher
  • OBIEE Security

Data Warehouse concepts

  1. Need of Data Warehouse
  2. Data Warehousing
  3. Data Warehouse Architecture
  4. Data Acquisition
  5. Types of Tables
  6. schema and types of Schemas
  7. Data Mart?
  8. Data Warehousing Approaches


  1. Installing OBIEE 12c on Windows
  2. Installing OBIEE 12c on Linux
  3. Migrating RPD and Webcat from lower versions to 12c

OBIEE Introduction

  1. Why Oracle BI ?
  2. What is Oracle BI?
  3. History of Oracle BI
  4. Oracle BI architecture Lower Versions Vs 12c
  5. Oracle BI components Lower Versions Vs 12c

OBIEE 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
  9. Using Aggregate Tables
  10. Parent Child Hierarchies
  11. Ragged and Skipped hierarchies
  12. Using Lookup Table
  13. Using Partitions and Fragments
  14. Variables (Repository, session, presentation &Request)
  15. Modeling Time Series Data & Time based  Measures
  16. Configuring Many To  Many Relationships(Bridge  &Helper Table)
  17. Deploying Oracle Bi application  to multiple countries
    o Localizing Oracle BI Metadata
    o Localizing Oracle BI Data
  18. Setting Implicit Fact Column
  19. Third Party Reporting Tool Integration
  20. Creating Repositories  From Multi-dimensional  Data Sources
  21. Administering Usage Tracking
  22. Multi-User Development  Environment (MUDE)
  23. Utilities
  24. Cache Management
  25. Repository Design Principles
  26. Disconnected Analytics
  27. Alias ,Circular Joins & Opaque Views or Select  Tables

Presentation Services or Analytics

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

Analytics Reporting

  1. Working with OBI Answers
  2. OBI Column Properties
  3. Drill
  4. Navigation
  5. Conditional formatting
  6. OBI Formulas
  7. OBI Filters
  8. OBI Sorting
  9. OBI Views
  10. OBI Request Level Prompts
  11. Cascading Prompts
  12. Combining With Similar Request13.Direct Database Requests

OBIEE Dashboards

  1. Oracle Business intelligence interactive Dashboards
  2. Dashboard Objects
  3. Section
  4. Link or Image
  5. Column
  6. Embedded Content
  7. Text
  8. Folder
  9. Guided Navigation Link(Static  , Conditional  and section )
  10. Briefing Book Navigation Link
  11. Advanced Reporting,  Master Detail Linking
  12. Simple Action Links
  13. Advanced Action Links
  14. Dashboard Prompts
  15. Types of Dashboard Prompts
  16. Page level prompts
  17. Dashboard level prompts
  18. Presentation Variables
  19. Request Variable
  20. Scorecards
  21. KPI

OBIEE Delivers

  1. Introduction to Oracle BI Delivers
  2. Developing IBOTS
  3. Configuring delivery devices
  4. Adding delivery profiles
  5. Building Alerts

Job Manager

  1. Configuring Job Manager
  2. Monitoring Scheduled requests

Oracle BI for Microsoft Office

  1. Introduction to Oracle BI for Microsoft Office
  2. Working with Oracle BI content in Microsoft  Office  applications

Catalog Manager

  1. Documentation of Web Catalog
  2. Deploying Development to test or test to prod

BI Publisher

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

OBIEE Security

  1. Authentication and Authorization
  2. Creating Users and Groups
  3. Object Level Security
  4. Data Level Security
  5. Presentation Catalog  Permissions(Full Control, NoAccess, Change/Delete, Read, Traverse Folder)
  6. Presentation Catalog  Privileges(Granted, Denied)