[wpcol_1third id=”” class=”” style=””]



>>   Cognos

>>   Informatica

>>   Datastage

>>   Microstrategy

>>   AB-Initio

>>   Teradata

>>   OBIEE

>>   Hyperion

[/wpcol_1third] [wpcol_2third_end id=”” class=”” style=””]


Oracle BI Suite EE 10g R3

40 Hrs

Lesson 1

  • Repository basics
  • Major Components of Oracle BI Architecture
  • Identify and Describe the layers of OBI repository
  • Use OBI Admin tool to explore repository objects

Lesson 2

  • Identify and Describe the objects in the Physical layer of a repository
  • Create the physical layer of repository

Lesson 3

  • Identify the objects in the BMM Layer of a Repository
  • Build a Business model
  • Create Measures in Business Model

Lesson 4

  • Identify the objects of the presentation layer of a repository
  • Modify the properties of the presentation layer objects
  • Build the presentation layer of a repository

Lesson 5

  • Test and validate a repository

Lesson 6

  • Describe normalized and de-normalized table structures in a database design
  • Add multiple sources to a LTS for a dimension in a Business model

Lesson 7

  • Describe a calculation measure and its views in a business model
  • Create new calculation measure based on logical columns
  • Create new calculation measures based on physical columns
  • Create new calculation measure by using a calculation wizard

Lesson 8

  • Create dimension hierarchies
  • Create level based measures
  • Create rank and share measures

Lesson 9

  • Aggregate tables in dimension modeling

Lesson 10

  • Create session variables
  • Create repository variables
  • Create initialization blocks
  • Implement a dynamic repository variables

Lesson 11

  • Use of Time comparison for business analysis
  • Implement time comparison measures in business model

Lesson 12

  • Describe the purpose and process of Setting an implicit fact column
  • Set an implicit fact column for a presentation catalog

Lesson 13

  • define users and groups
  • set permissions for users and groups to control access to repository objects
  • explain group inheritance
  • identify and describe authentication methods used by Oracle BI server

Working with Oracle Business Intelligence Answers

  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers
  • Using advanced formatting

Filtering Requests in Oracle Business Intelligence Answers

  • Introduction to filters in Answers
  • Adding filter prompts to requests
  • Using saved requests as filters

Oracle Business Intelligence Answers: Advanced Features

  • Combining request criteria using set operations
  • Executing direct database requests
  • Editing logical SQL generated by a request

Building Views and Charts in Requests

  • Introduction to Answers views and charts
  • Creating and editing charts
  • Performing common view tasks

Showing Results with Gauge Views

  • Introduction to Gauge views
  • Working with Gauge views

Showing Results with Pivot Tables

  • Introduction to pivot tables
  • Formatting pivot tables
  • Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

  • Introduction to Interactive Dashboards and pages
  • Dashboard Editor UI elements
  • Composing dashboard elements

Configuring Oracle Business Intelligence Interactive Dashboards

  • Types of dashboard content
  • Embedding content in Interactive Dashboards
  • Using bookmark links to distribute and save Interactive Dashboards

Customizing the Oracle Business Intelligence User Interface

  • Modifying cascading style sheets
  • Modifying XML message files
  • Making configuration changes using the instance config file

Configuring Guided Navigation Links

  • Building guided navigation with static links
  • Building guided navigation with conditional links and sections

Administering the Oracle Business Intelligence Presentation Catalog

  • Maintaining the Oracle BI Presentation Catalog
  • Managing security
  • Understanding security inheritance
  • Describing the Presentation Catalog structure
  • Permission types
  • Setting permissions using the Manage Catalog screen


Leave a comment

Your email address will not be published.