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