OBIEE

OBIEE Training 

Introduction:

Oracle Business Intelligence Enterprise Edition 11g is a comprehensive business intelligence platform that delivers a full range of capabilities – including interactive dashboards, ad hoc queries, notifications and alerts, enterprise and financial reporting, scorecard and strategy management, business process…

Course Description:

Overview

  • General Datawarehousing concepts
  • Dimensional modeling basics
  • Dimension Types ( Conformed and SCD)
  • Fact Types( Additive , Non additive, Snapshot,
  • Accumulator etc)

Installation

  • Installation Prerequisites
  • Points of Caution while installing
  • Understanding the need for RCU
  • Installation best practices
  • Difference between Simple and Enterprise Install

Admin Tool And RPD Modeling

  • Understanding Online and Offline modes of RPD
  • Creating Repository Using Administration Tool
  • Repository Basics
  • 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
  • Hierarchical Tables and Parenct Child Hierarchy
  • Modeling a Ragged Hierarchy Dimension
  • Creating Time Series Measures
  • Testing , Validation of a Repository
  • Creating Calculated Measures
  • Creating Dimension Hierarchies
  • Organizing Presentation Layer
  • Working with Initialization Blocks and Variables ( Session and Repository Variables)
  • Adding Multiple Sources
  • Executing Direct Database Requests
  • Working with Aggregates

Dashboard And Analysis

  • Creating and Editing Analysis
  • Creating Interactive Dashboards using Analysis
  • Creating query and chart
  • Working with Filters
  • Working with Pivot Table
  • Building Views and Charts in Requests
  • Creating and Configuring Interactive Dashboards
  • Creating and Configuring Dashboard Prompts
  • 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
  • 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

 

Comments are closed