Welcome to ApplStar Technologies - ORACLE REALTIME TRAINING


Data Warehouse Concepts

  1. Why we need Data Warehouse?
  2. What is Data Warehouse?
  3. Data Warehouse Architecture
  4. What is Data Acquisition?
  5. Types of Tables
  6. What is Schema and types of Schemas
  7. What is Datamart?
  8. Data Warehousing Approces?

Common Concepts of OBIEE 10g and OBIEE 11g
OBIEE 11g 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 & 10g Practitioner Level

  1. Repository Basics
  2. Building the Physical Layer of a Repository
  3. Building BMM layer of a Repository
  4. Testing Repository
  5. Working with Multiple Logical Table Sources
  6. Adding Calculations of Fact table
  7. Creating Dimensional Hierarchies & Level based Measures

OBIEE 10g & 11g Specialist Level

  1. Using Aggregate Tables
  2. Using Partitions and Fragments
  3. Variables(Repository, Session, Presentation & Request)
  4. Modeling TimeSeries Data & Time based Measures
  5. Configuring Many to Many Relationships (Bridge & Helper Table)
  6. Deploying Oracle BI Application to Multiple Countries
    • Localizing Oracle BI Metadata
    • Localizing Oracle BI Data
  7. Setting Implicit Fact Column
  8. Third Party Reporting Toll Integration
  9. Creating Repositories From Multi Dimensional Data Sources
  10. Security
    • Authentication and Authorization
    • Creating Users and Groups
    • Object Level Security
    • Data Level Security
  11. Administration of Usage Tracking
  12. Multi-User Development Environment (MUDE)
  13. Utilities
  14. Cache Management
  15. Optimizing Query Performance
  16. Repository Design Principles
  17. Model First
  18. Cluster Servers
  19. Disconnected Analytics
  20. Alias, Circular Joins & Opaque Views or Select Tables

OBIEE 11g & 10g Learner Level Presentation Services or Analytics

  1. Introduction to Presentation Services
  2. What is Web Catalog & Instance of Config file
  3. Shared Folders, Myfolders, Shared Filters, My Filters, My Briefing Books


  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 Requests
  13. Direct Database Request
  14. Presentation Catalog Permissions (Full Control, No Access, Change/Delete, Read, Traverse Folder)
  15. Presentation Catalog Privileges (Granted, Denied)


  1. Creating Oracle Business Intelligence Interactive Dashboards
  2. Working with Dashboard Objects
  3. Section
  4. Link or Image
  5. Embedded Content
  6. Text
  7. Folder
  8. Guided Navigation Link (Static, Conditional and Section)
  9. Briefing Book Navigation Link
  10. BI Publisher Report
  11. Working with Dashboard Prompts
  12. What is Dashboard Prompts
  13. Types of Dashboard Prompts
  14. Page Level Prompts
  15. Dashboard Level Prompts
  16. Presentation Variables
  17. Request Variable

Delivers (iBots in 10g)

  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 Production

OBIEE 11g New Features

  1. Introduction about EM, CONSOLE, ANALYTICS, XMLP SERVER etc
  2. OBIEE 11g Advanced Workshop Setup
  3. Parent Child Hierarchies
  4. Ragged and Skipped Hierarchies
  5. Assign ID columns to descriptive columns
  6. Using Lookup Tables
  7. Horizontal Federation
  8. Vertical Federation
  9. Combined Horizontal & Vertical Federation
  10. Hierarchical Columns and Selection Steps
  11. Advanced Reporting, Master Detail Linking
  12. New Graphing Options
  13. BI Publisher 11g Online Template Builder and Interactive Viewer
  14. New Dashboard Features
  15. Creating Simple Action Links
  16. Creating Advanced Action Links
  17. Creating Time Series Measures using Period Rolling
  18. Creating Scorecards
  19. Creating KPI
  20. Working with XML API

BI Publisher 11g & 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 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 Database
  10. Develop BI Publisher Templates using XML File
  11. Working with Parameters and LOV's
  12. Scheduling BI Publisher Template