OBIEE Training Course Tracks

Oracle OBIEE Training in July 2011 at 10:00 AM (PST). Attend Free Demo Classes

DAY 1

Pre-Requisites & Introduction to OBIEE

Conventional OLTP vs OLAP
Why a warehouse
Introducing to Warehouse concepts -Current trends of Warehouse
Dimensions & Facts
Start Schemas vs Snow Flake Schemas
Aggregate table
Introduction to Data Modeling
Why OBIEE- OBIEE Overview
Advantage of Using OBIEE
OBIEE Architecture

DAY 2
Introduction to Repository

Understanding Architecture
Understanding Repository Basics
Introduction to Physical layer
Importing the DB Objects and schema
Connection Pools  - Data Sources
Star Schema Modelling
Modelling the Physical Layer
Modeling Aliases and Opaque Views
Introduction to BMM Layer
Business Model Layer Objects
Building Business Model Layer
Testing and Validating a Repository
Q & A SESSION

DAY 3

BMM Layer Deep Dive

Adding Multiple sources to dimensions
Adding Logical Columns to Facts and Dimensions
Adding Calculations to Fact
Creating Dimension Hierarchies
Understanding LEVEL BASED MEASURES
Modelling Time Series Data & Functions
Modelling Slowly changing Dimensions
Modelling Extension Tables
Modelling Aggregate tables
Cache  Management
Best Practices
Q&A Session

DAY 4

BMM & Presentation Layer

Creating Aggregate Tables using Aggregate Persistence wizard
Introduction to Variables
Using Session variables (System/Non System)
Using Repository Variables
Using Static and Dynamic Variables
Adding Multiple Sources to Dimension
Adding Multiple Sources to Fact
Implicit Fact Implementation and Usages
Introductions to Filters
Expression Builders
Setting up LTS filters
DEMO, Q & A

DAY 5

Oracle Answers

Introduction to Oracle Business Intelligence Answers
Creating Sample Report Using OBIEE Answers
Understanding Subject Areas
Building Table Views
Building  Pivot Table Views
Building  Chart views
Building  View Selector
Understanding Narrative View
Understanding Compound Layout
Understanding Shared Filters and Saved Filters
Understanding Combined Requests
Working with No results Views

DAY 6

Oracle Answers & Interactive Dashboards

Working on ANSWERS and its FEATURES
Using Different Types of Prompts
Using Presentation Variables
Filters and Prompts in OBIEE Answers
Using Column Filters / Prompt Filters / Global Filters
Using Combined Filter/Group Filter/ Filter Based on other Request
Using Dynamic filter using variable
Configuring Interactive Dashboards & Prompts
Configuring Guided Navigation Links
Interactive Dashboard Design Objects & Principles
Q & A
DEMO

DAY 7

Administration & Security

Administration on Dashboards and reports
Authentication & Authorization
Object & Data Level Security
Webcatalog Level Security
Creating Users, Groups & Webgroups
Understanding Usage Tracking
Working on Creating Projects
Implementing MULTI USER DEVELOPMENT
Working on 3 WAY MERGE PROCESS
Introduction to Delivers
Delivers Configuration
Creating IBOTs and Scheduling
Configuring SA Systems
Q & A

DAY 8

BI APPS Intro & BI Publisher

Overview of BI Publisher
Overview of OBIEE pre-defined applications
Architecture or Components of BI Apps Platform
Understanding one of the BI Schemas
Steps for implementing the Vanila or Out of the Box Modules
Understanding of the RPD with respect to the Out of the Box
Possible Challenges
Q&A
Demo

DAY 9

OBIEE Apps Continues

Understanding BI Apps Sales & Finance Schema
Various Modules of OBIEE Apps
Understanding Leading OBIEE Apps Implementations
Best Practices
Common Implementation Best Practices
Interview related Q&A
Introduction to 11g

DAY 10
OBIEE 11g

Architectural Overview
Advanced/Enriched UI  in 11g
Hierarchical Columns
Scorecards
Column and Dashboard Prompts
Security Changes in 11g
Obsolete items in 11g
Challenges encountering in Real time with 11g
Understanding of weblogic Admin Console
Understanding of weblogic Enterprise Manager

DAY 11

ETL with Informatica

Overview of Informatica Architecture
Understanding of ETL Process
Understanding Informatica Client Tools
Installation of Informatica - How To?
Understanding BI Apps Folder structures
Understanding Oracle Out of Box Mappings
Working with Designer
Importing Sources
Importing Targets
Understanding Transformations
Understanding SDE Mappings
Understanding SIL Mappings

DAY 12

Informatica Transformations

Understanding Transformations:
Creating Transformations
Source Qualifier transformation
Expression transformation
Aggregator transformation
Filter transformation
Lookup transformation
Update Strategy transformation
Sequence Generator Transformation
Using Variable Ports
Mapping Parameters and Variables
Working with Workflow Manager
Creating Sessions
Creating Tasks
Creating Worklets
Creating Workflows

DAY 13
Understanding DAC

Overview of DAC (Arichitecture and Concepts)
Understanding DAC USER INTERFACE
Understanding DAC VIEWS
Configuration on DESIGN VIEW / Setup View / Execute view
Understanding DAC PROPERTIES
Understanding PHYSICAL DATA SOURCES
Understanding DAC OBJECTS

Understanding about TASK GROUPS / SUBJECT AREAS / EXECUTION PLANS

DAY 14

Working with DAC

Understanding DAC OBJECT HIRERACHY TASKS / BUILD IMAGE
Understanding how to Import TABLES and Coloums in DAC
Understanding RESETTING REFRESH DATES
Performing an out of box ETL loads
Exploring the change capture process
Siebel sources
Non siebel sources
Performing Full load
Performing Incremental load
Customizing out of box solution
· Best practices for customizing out of box informatica metadata
· Best practices for customizing out of box DAC metadata
· Walk through example.
Q & A
DEMO

Pay Now