OBIEE - CONTENTENT

Oracle BI Overview       

·         Describe Oracle’s overall EPM System

·         Define and describe business analytics and business intelligence

·         Describe how OBIEE addresses business intelligence challenges

·         Identify and describe the Oracle Business Inteligence Enterprise Edition (OBIEE) products and components

Oracle BI Applications Overview   

·         Describing the Oracle Business Intelligence Applications

·         Describing the Oracle Business Intelligence logical architecture

Dimensional Modeling      

·         Describe Data Warehousing

·         Describe Dimensions, Facts and Hierarchies

OBI EE Architecture

·         Identify major components of the OBIEE architecture

·         Describe the function of each component

Oracle BI Installation           

·         Explain system requirements, supported platforms and installation pre-requisites

·         Installing OBIEE on windows OS

Oracle BI Repository Overview

 Describe the three layers of the OBI Repository

·                                   Use the Administration Tool to view and modify the repository

Build Basic Repository      

·         Define a System Data Source Name (DSN) for a data source

·         Build the Physical layer of the Repository

·         Build the Logical layer of the Repository

·         Build the presentation layer of the repository

Repository Testing and Deployment

           

·         Describe techniques for testing a repository

·         Execute steps to validate and test a repository

Complex Repository Modeling

           

·         Describe derived metrics and its use

·         Configure derived metrics based on existing logical columns

·         Configure derived metrics based on physical columns

Building a Repository with Multiple Source

 Add multiple sources to an existing logical table source for a dimension in the business model

·                                  Add a second table source to a dimension in the business model

Hierarchies and Level Based Measures           

·         Create a dimensional hierarchy

·         Use level-based measures

·         Describe Aggregate tables and the purpose they serve

·         Create aggregate tables in the OBI repository

Using Variables           

·         Describe session variables

·         Describe repository variables

·         Describe initialization blocks

·         Implement a dynamic repository variable

Oracle BI Security  

·         Define authentication and authorization

·         Describe the different levels at which security is enforced

·         Configure security using Security Manager

·         Configure query governing controls

Cache Management

·         Explain the purpose of cache in OBI

·         Configure caching and manage cache files

·         Develop caching strategies

OBIEE User Interface Overview

·         Describe Oracle BI Answers, Dashboards and Delivers

·         Use Oracle Answers to construct, modify, and save BI requests

·         Use Oracle Answers to construct, modify, and save Filters

·         Use Oracle BI Presentation Catalog to create and modify catalog folders

Working with Oracle BI Answers   

·         Use BI Answers to build analytics requests

·         Add filters to analytics requests

·         Views and Charts in Requests

·         Add additional views of the data returned by the request

·         Create and edit charts

·         Execute direct database requests

Working with Oracle BI Dashboards       

·         Configuring Intelligence Dashboards

·         Create and edit a new dashboard

·         Modify dashboard properties

·         Use Intelligence Dashboard UI objects to create an Intelligence Dashboard

·         Configuring Guided Navigation Links

Working with Oracle Delivers

·         Configure delivery devices

·         Add delivery profiles

·         Build Analytics alerts

·         Create iBots

BI Publisher Overview   

·         Defining Data Set

·         Creating BI Publisher Report

·         Creating Report Template