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
Online Courses Videos