OBIEE

OBIEE Stands for Oracle Business Intelligence Enterprise Edition. Oracle Business Intelligence Suite, Enterprise Edition (OBIEE) is an innovative and comprehensive BI platform that delivers the full range of BI capabilities.

Infrastructure & Facilities:

OBIEE 11g is a resource intensive application and is very heavy for desktops. Hence we use our high End Servers for running OBIEE setup which includes Oracle & WebLogic Servers.

Pre-requisite/s:

Basic computer skills

Familiarity to data processing

Course Topics:

SQL Basics (optional)

DDLs, DMLs, TCLs

Joins

Views

Sub queries

Set Operators

Aggregate Functions

Datawarehousing Concepts

  • OLTP Vs OLAP
  • Data warehouse Architecture
  • Data warehouse Vs Data Mart
  • ETL
  • Masures, Fact, Dimensions
  • Schema
  • Star Schema and
  • Snowflake Schema
  • Dimension Hierarchy
  • Aggregates
  • Aggregation Strategy, Compression Ratio
  • Indexing Strategy
  • Slowly Changing Dimension
  • Type 1
  • Type 2
  • Type 3
  • Performance Tuning

OBIEE Topics

Admin Tool And RPD Modeling

Understanding Online and Offline modes of RPD in OBIEE

Creating Repository Using Administration Tool in OBIEE

Repository Basics in OBIEE

Building Physical Layer of Repository

Building Physical Model and BMM Layer of a Repository

Building the Presentation Layer of a Repository

Aggregate Persistence

Dimension Lookups in OBIEE

Hierarchical Tables and Parenct Child Hierarchy

Modeling a Ragged Hierarchy Dimension

Creating Time Series Measures

Testing , Validation of a Repository

Creating Calculated Measures in OBIEE

Creating Dimension Hierarchies in OBIEE

Organizing Presentation Layer

Working with Initialization Blocks and Variables

Adding Multiple Sources

Executing Direct Database Requests

Working with Aggregates in OBIEE

Dashboard And Analysis

Creating and Editing Analysis in OBIEE

Creating Interactive Dashboards using Analysis

Creating query and chart

Working with Filters in OBIEE

Working with Pivot Table in OBIEE

Building Views and Charts in Requests

Creating and Configuring Interactive Dashboards in OBIEE

Creating and Configuring Dashboard Prompts in OBIEE

Configuring Action Links

Creating and understanding KPI,KPI Watchlists and Scorecards

Oracle BI for MS-Office

Sending Alerts Using Delivers

Using Job Manager

Architecture And Security Features

Understanding OBIEE 11g Architecture

Role of Weblogic Server and Enterprise Manager in OBIEE 11g

Admin and managed Server

Authentication & Authorization

Creating Application Roles

Creating Users , Groups, Web Catalog groups

LDAP Integration

Object & Data Level Security Implementation

Web catalog Level Security Implementation