OBIEE 10g

Datawarehousing Fundamentals:

  • Introduction to Datawarehouse
  • OLTP/OLAP
  • Dimensions/facts
  • Scd dimensions
  • Star/Snowflake schema
  • Primary/Foreign key
  • Staging Area
  • Datamart

OBIEE

OBIEE Architecture Overview

  • Oracle Business intelligence server
  • Oracle Business intelligence Dashboards
  • Oracle Business intelligence Answers
  • Oracle Business intelligence Delivers
  • Oracle Business intelligence Publisher

OBIEE Administration

  • Repository Basics
  • Building the Physical Layer of a Repository
  • Buliding the Business Model and Mapping Layer of a Repository
  • Bulding the Presentation layer of a repository
  • Testing and validating of a Repository
  • Adding Multiple Logical Table Sources
  • Adding calculations to a fact table
  • Creating Dimension hierarchies and level based measures
  • Using aggregations
  • Modelling Time Series data
  • Setting an implicit fact column
  • Using variables
  • Security
  • Using partitions and fragments
  • Cache management
  • Multi user development

OBIEE Presentation services Topics

  • Working with Oracle business intelligence Answers
  • Filtering Requests in OBI Answers
  • Views and Charts in requests
  • Showing Results with Pivot tables
  • Creating Interactive dashboards
  • Configuring guided navigation links
  • Using OBI Delivers