OBIEEE 11g COURSE COURSE – LEARN @ YOUR CONVENIENCE

This course is designed for those professionals who are looking for Great career as Consultant in BI Technology. This course provides a solid foundation on OBIEE 11g. Participants will learn to design the Repository, Creating Answers/Analysis Requests, and Interactive Dashboard, Delivers, OBIEE 11g/Fusion Middleware Security and OBIEE-BI Publisher integration.

 PART I: Overview

1. General Datawarehousing concepts
2. Dimensional modeling basics
3. Dimension Types ( Conformed and SCD)
4. Fact Types( Additive , Non additive, Snapshot, Accumulator etc)

PART II: Installation

1. Installation Prerequisites
2. Points of Caution while installing
3. Understanding the need for RCU
4. Installation best practices
5. Difference between Simple and Enterprise Install

 PART III: Admin Tool And RPD Modeling

1. Understanding Online and Offline modes of RPD
2. Creating Repository Using Administration Tool
3. Repository Basics
4. Building Physical Layer of Repository
5. Building Physical Model and BMM Layer of a Repository
6. Building the Presentation Layer of a Repository
7. Aggregate Persistence
8. Dimension Lookups
9. Hierarchical Tables and Parenct Child Hierarchy
10. Modeling a Ragged Hierarchy Dimension
11. Creating Time Series Measures
12. Testing , Validation of a Repository
13. Creating Calculated Measures
14. Creating Dimension Hierarchies
15. Organizing Presentation Layer
16. Working with Initialization Blocks and Variables ( Session and Repository Variables)
17. Adding Multiple Sources
18. Executing Direct Database Requests
19. Working with Aggregates

 PART IV: Dashboard And Analysis

1. Creating and Editing Analysis
2. Creating Interactive Dashboards using Analysis
3. Creating query and chart
4. Working with Filters
5. Working with Pivot Table
6. Building Views and Charts in Requests
7. Creating and Configuring Interactive Dashboards
8. Creating and Configuring Dashboard Prompts
9. Configuring Action Links
10. Creating and understanding KPI,KPI Watchlists and Scorecards
11. Oracle BI for MS-Office
12. Sending Alerts Using Delivers
13. Using Job Manager

PART V: Architecture And Security Features

1. Understanding OBIEE 11g Architecture
2. Role of Weblogic Server and Enterprise Manager
3. Admin and managed Server
4. Authentication & Authorization
5. Creating Application Roles
6. Creating Users , Groups, Web Catalog groups
7. LDAP Integration
8. Object & Data Level Security Implementation
9. Web catalog Level Security Implementation