Oracle OBIEE 11g Training

Course Duration : 8 Weekend, Course Fee : 30000

OBIEE 11g training hands-on course which teach you to effectively plan, install, configure, administer, query, troubleshoot and manage Oracle Databases. All books and materials are included. The course will prepare students for the Oracle exams, as well as deliver a foundation in the real world application of their database skills.

OBIEE 11g (Oracle Business Intelligence Enterprise Edition Plus, also termed OBI EE Plus, is Oracle Corporation’s set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings.

The industry counterpart and main competitors of OBIEE are Microsoft BI, IBM Cognos, SAP AG Business Objects and SAS Institute Inc. The products currently leverage a common BI Server providing integration among the tools. ACLM offering different courses under oracle and database technologies. OBIEE is one of the best training being offered by ACLM in Vaishali, Indirapuram, Kaushambi, Ghaziabad, Sahibabad, Vasundhara including Delhi NCR region.

OBIEE 11g : Features

• Comprehensive BI Functionality
• Usability
• Unified Business Model
• Hot- Pluggable Infrastructure

Topics Covered

Introduction to the Course and Course Contents

Installation and configuration of OBIEE 11g

Oracle Business Intelligence Enterprise Edition Overview

• Oracle Business Intelligence Enterprise Edition Architecture Brief Introduction to Warehousing Concepts Dimension Fact Star Schema Oracle BI Application Overview Oracle BI Repository Basics

Building the Physical Layer of a Repository

• Create a New Repository Import a Schema Create Physical Joins

Building the Business Layer of a Repository

• Create a Business Model Create Logical Tables Create Logical Columns Create Logical Joins

Building the Presentation Layer of a Repository

Testing and Validating a Repository

• Run a Consistency Check Enable Query Logging Start Oracle BI Services Use Oracle BI Analysis to Execute Queries Use Query Log to Verify Queries

Creating Calculation Measures

• Load a Pre built Repository Create a New Measure Create a Calculation Measure Using Administration Tool Create a Calculation Measure Using Analysis

Building Dimension Hierarchies

• Using hierarchy in OBIEE analysis Creating Level Based Measures Cache Management Creating Presentation Hierarchies

Security in OBIEE

• Data Level Security Object Level Security Creating Initialization Blocks and Variables Repository Variables Session Variables

Working with various views in Analysis

Dashboard Creation and Modification

• Creating Prompts Dashboard Column Filter Adding report to the dashboard Creating Presentation Variables Drill and Navigate Option Creating drill report Using repository, session and presentation variables Filtering Requests in Oracle Business Intelligence Analysis Interview Questions and Project write-ups for resume

Who Should Attend

• This course is designed for individuals with the Oracle 11g Certified Associate certification or equivalent knowledge.

Pre-requisites

• Basic knowledge of Oracle & Database

What You Need To Bring

• Notebook, Pen, Laptop

Key Takeaways

• Dashboard Creation & Modification, Working with various views in Analysis

About Trainer

• Over 17+ years of experience in Microsoft Access
• International Training exposure of more than 70 corporate trainings
• Member of IFCA, AIMA
• Contributed to several studies on financial and man-power management
• Certifications of PMP, Six-Sigma, MS Project specialist