OBIEE Online Training

OBIEE Online Training

PART I:  Overview

Data Warehouse Basics and Introduction to OBIEE

  • General Data warehousing concepts
  • Dimensional modeling basics
  • Oracle Business Intelligence Application Overview
  • Describing the Oracle Business Intelligence Applications Architecture and components
  • Installing OBIEE latest Version on Your Machines


Repository Basics

  • Oracle BI architecture components
  • Repository structure, features, and functions
  • Using the Oracle BI Administration Tool
  • Creating a repository
  • Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

  • Importing data sources
  • Setting up connection pool properties
  • Defining keys and joins
  • Examining physical layer object properties
  • Creating alias and select tables

Building the Business Model and Mapping Layer of a Repository

  • Building a business model
  • Building logical tables, columns, and sources
  • Defining logical joins
  • Building measures
  • Examining business model object properties

Building the Presentation Layer of a Repository

  • Exploring Presentation layer objects
  • Creating Presentation layer objects
  • Modifying Presentation layer objects
  • Examining Presentation layer object properties

Testing and Validating a Repository

  • Checking repository consistency
  • Turning on logging
  • Defining a repository in the initialization file
  • Testing a repository using Oracle BI Answers
  • Inspecting the query log

Adding Multiple Logical Table Sources

  • Adding multiple logical table sources to a logical table
  • Specifying logical content

Adding Calculations to a Fact Table

  • Creating new calculation measures based on existing logical columns
  • Creating new calculation measures based on physical columns
  • Creating new calculation measures using the Calculation Wizard

Creating Dimension Hierarchies and Level-Based Measures

  • Creating dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating rank measures

Using Aggregates

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation
  • Using the Aggregate Persistence Wizard

Using Partitions and Fragments

  • Purpose for segmenting data into partitions and fragments
  • Partition types
  • Modeling partitions in an Oracle BI repository

Using Repository Variables

  • Session variables
  • Repository variables
  • Initialization blocks
  • Using the Variable Manager
  • Using dynamic repository variables as filters

Modeling Time Series Data

  • Using time comparisons in business analysis
  • Using Oracle BI time series functions to model time series data
  • TO DATE Function
  • AGO Function
  • Periodic Rolling Function


Working with Oracle Business Intelligence Answers

  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers

Filtering Requests in Oracle Business Intelligence Answers

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

Views and Charts in Requests

  • Introduction to Answers views and charts
  • Creating a column selector views

Showing Results with Pivot table

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

Creating Interactive Dashboards

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

Configuring Interactive Dashboards

Types of Dashboard content

Embedding content in Dashboards

Configuring Guided Navigation Links

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

Administering Oracle Business Intelligence Presentation Catalog

  • Maintaining the Oracle BI Presentation Catalog
  • Maintaining security

Understanding security inheritance

PART IV: SECURITY FEATURES and Delivers Security

  • Creating users and groups
  • Setting permissions for users and groups
  • Setting query limits and timing restrictions
  • Setting filters to personalize information

Cache Management

  • Restricting tables as non-cacheable
  • Using Cache Manager
  • Inspecting cache reports
  • Purging cache entries
  • Modifying cache parameters and options
  • Seeding the cache

Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories

  • Employing techniques to optimize Oracle BI query performance

Using Oracle Business Intelligence Delivers

  • Building alerts
  • Building iBots
  • Introduction to Oracle BI Scheduler
  • Configuring Job Manager
  • Monitoring Scheduled requests

Important real Time scenarios covered during the course:

  • Configurations and Servers.
  • Upgrading RPD and Catalog from 10g to 11g.
  • Real time business knowledge.
  • Real time Project parallel with the course.
  • Setting Up and Administering Usage Tracking.
  • Migrating OBIEE objects between the environments.
  • Overview of BI Publisher.
  • Overview of various ETL tools in the market.
  • SDLC steps followed in the OBIEE project will be exclusively experienced by Students.
  • Important Scenarios and real time Issues will be discussed.
  • Mock Interviews