Jump to content

Oracle BI & Informatica Training


mchava

Recommended Posts

Greetings!!!

We are glad to announce our new online OBIEE  Training on Jun-18-2011.
Course Duration: 50hrs Daily class est:7:30pm to 9:00pm.

Why OBIEE  Training is necessary:

The purpose of this course is to build a fundamental understanding of Business Intelligence Reporting using
the Oracle Business Intelligence Reporting. The training would include the technical procedures required
to facilitate data modelling and other data related activities in OBIEE.
It would also cover advance topics like end to end security module, multi user development environment.
We give special care to every trainee to complete the hands-on lab exercises on each topic.


The below topics are covered during the course:


Data warehousing Concepts
==============================
Introduction and Definition
Sources, Transformations and Targets( Architecture )
Data Extraction, Data Transformations and Data Loading( Data Acquisition Process )
Data Warehousing Approaches
Staging Area, Metadata, Repository and Data Mart
Differences between OLTP and OLAP( DSS ) Systems
Operational Data Store( ODS )
Business Intelligence
Star Schema Design & Confirmed Dimension, Fact less Fact Table, Types of Facts
Slowly Changing Dimensions( SCD )

ORACLE BI
===============================================
OBIEE Architecture
OBIEE Components
OBIEE Administration Tool
OBIEE Answers
Intelligence dashboards
Repository Basics
Building the Physical Layer of a Repository
Building the Business Model and Mapping Layer of a Repository
Building the Presentation Layer of a Repository
Testing and Validating a Repository
Adding Multiple Logical Table Sources
Adding Calculations to a Fact Table
Creating Dimension Hierarchies and Level-Based Measures
Creating & Using Aggregates
SettingImplicitFactColumn
Using Initialization Blocks Repository Variables
Creating Dynamic Repository Variables
Execute Direct Database Requests
Creating Time series Measures
Providing Security for Groups & Users
MUDE : Multi user development environment

Answers  & Dashboards(REPORTS)
===============================

Working with Oracle Business Intelligence Answers
Filtering Requests in Oracle Business Intelligence Answers
Building Views and Charts in Requests
Showing Results with Pivot Tables
ConfiguringGuidedNavigationLinks
Creating Oracle Business Intelligence Interactive Dashboards
ConfiguringInteractiveDashboards.
CustomizingUserInterface.
UsingDelivers

ORACLE BI APPS
==============================
Introduction to BI Applications
Introduction to DAC

Bi Publisher
===============================
BI Publisher Overview
BI Publisher Architecture
BIP REPORTING
Report With Parameters And  LOV

Informatica Overview
===================================
PowerCenter Components and User Interface
Mapping Designer
Source - Relational and Flat File
Source Qualifier - Join, Filter, Joiner, Multiple Target Load
Multiple Target Load ,Router, Joiner - Join Type’s, Union
Aggregator, Sorter, Rank, Update Strategy
Sequence Generator, Stored Procedure
Lookup, Debugger, Normalizer
Dimension Load - SCD Type 1
Dimension Load  SCD Type 2

Resume Preparation
=================================
Interview Preparation
===================================

Questions please ?

Mode of training:
Our trainings are conducted online using an interactive web-conferencing software which also has integrated VoIP.
Participants will be able to view trainer's desktop remotely & communicate with him at the same time.
Trainer can also take control of your PC/Laptop in case you get stuck while performing exercises.
For Audio, you need to have a headset (earphone & microphone).

Please forward this email to your friends.

Thanks
[email protected]
804-615-8694

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...