www.bigclasses.com Hyderabad : OBIEE Online Training

[bigclasses]

OBIEE
Datawarehousing 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 )

OBI Overview

New Features of OBI

OBI Architecture

Clients
OBI Presentation Services
OBI Server
OBI Repository (.rpd)
Data Sources

OBI Components

OBI Administration Tool
OBI Answers
Intelligence dashboards

Repository Basics

Oracle Business Analysis Warehouse
DAC and Informatica Server
Informatica Server ETL
Sample Request Processing
Using the OracleBI Administration Tool
Repository Directory
Repository Files ( Initialization files and log files)
Informatica Server ETLLoading a repository into Oracle BI Server memory
Creating a repository
Connection Pool
Repository Modes ( ONLINE and OFFLINE )
Physical Layer
Business Model & Mapping Layer
Presentation Layer
Presentation Catalogs, Folders and Columns
Error Messages

Building the Physical Layer of a Repository

Defining an ODBC System DSN
Setting up connection pool properties
Importing data sources ( Physical Schema )
Verifying the import
Defining physical keys and joins
Creating alias and select tables

Building the Business Model and Mapping Layer of a Repository

Creating the logical business model
Creating the logical tables, columns, and sources
Defining logical joins
Adding Calculation to a Fact Table
Building measures

Building the Presentation Layer of a Repository

Creating a new Presentation Catalog
Modifying Presentation layer objects
Rename tables
Reorder Table

Testing and Validating a Repository

Checking repository consistency
Defining a repository in the initialization file
Testing a repository using Oracle BI Answers
Message Severity
Viewing Server Logs

Building the Physical Layer of a Repository

Defining an ODBC System DSN
Setting up connection pool properties
Importing data sources ( Physical Schema )
Verifying the import
Defining physical keys and joins
Creating alias and select tables


Building the Business Model and Mapping Layer of a Repository

Creating the logical business model
Creating the logical tables, columns, and sources
Defining logical joins
Adding Calculation to a Fact Table
Building measures

Building the Presentation Layer of a Repository

Creating a new Presentation Catalog
Modifying Presentation layer objects
Rename tables
Reorder Table

Testing and Validating a Repository

Checking repository consistency
Defining a repository in the initialization file
Adding Multiple Logical Table Sources
Adding multiple logical table sources to a logical table
Specifying logical content

Adding Multiple Logical Table Sources

Adding multiple logical table sources to a logical table
Specifying logical content

Adding Calculations to a Fact Table

Creating new calculation measures based on existing logical columns
Creating new calculation measures based on physical columns
Creating new calculation measures using the Calculation Wizard

Creating Dimension Hierarchies and Level-Based Measures

Creating dimension hierarchies
Creating level-based measures

Creating & Using Aggregates

Purpose of aggregate tables in dimensional modeling
Modeling aggregate tables to improve query performance
Testing aggregate navigation

Using Initialization Blocks Repository Variables

Creating Dynamic Repository Variables

Execute Direct Database Requests

Accessing database directly

Creating Time series Measures

Using time comparisons in business analysis
Using Oracle BI time series functions to model time series data


Creating Dimension Hierarchies and Level-Based Measures

Creating dimension hierarchies
Creating level-based measures


Providing Security for Groups & Users

Answers (REPORTS)

Working with Oracle Business Intelligence Answers

Introduction to Oracle BI Answers
Working with requests in Oracle BI Answers
Using advanced formatting
Creating report Level Hierarchy


Filtering Requests in Oracle Business Intelligence Answers

Introduction to filters in Answers
Adding filter prompts to requests
Using saved requests as filters


Building Views and Charts in Requests

Introduction to Answers views and charts
Creating and editing charts
Performing common view tasks
Creating a Narrative View
Creating a column Selector
Creating View Selector


Showing Results with Pivot Tables

Introduction to pivot tables
Formatting pivot tables
Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

Introduction to Interactive Dashboards and pages
Adding Objects to Dashboard
Creating Dashboard prompts
Embedding content in an Interactive Dashboard
Visit: www.bigclasses.com
CONTACTUS:contact@bigclasses.com USA: 1-302 525 2655
INDIA: 91-800 811 4040 for Career Advice
Skype ID: Gtalk ID: Yahoo ID: Hotmail ID: bigclasses
150211kiran

#516,Annapurna Block,
AdityaEnclave, Ameerpet,
Hyderabad-500026.

[Guest-IJT]

Name : arvind pandey
Email : arvindpandey025 AT gmail.com
Designation / Skillset : (B.E)electrical engineering/engineer/

Resume :

Objective
To achieve and sustain excellence in the field of Electrical technology and work in a competitive era which enhances my skills & Willing to work as a key player in challenging & creative environment.
Software Skills
Internet Technology HTML, MS-FrontPage 2000
Software Packages Auto CAD, Electrical CAD, MS-Office.
Operating System MS-DOS, Windows 98/2000/XP
Professional Qualification
Degree B.E. in Electrical Engineering.
Name of Institution Rajasthan Institute Of Engineering & Technology, Jaipur
University Rajasthan University
Year Of Passing 2009
Aggergate % 58% (Agg.)
Educational Qualification
Standard XIIth
Name of Institution Govt.Queens Intermediate College.Varanasi Utar Pradesh
Board UP Board
Year Of Passing 2002
Aggergate % 43.8%
Standard Xth
Name of Institution Smt.N.K High Sshool Mohaniyan Rohtas Bihar
Board Bihar Board
Year Of Passing 2000
Aggergate % 69%
Project
Major Project : Hydro Power Plant
Details : Project developed for generation of electric energy purpose.
Requirements : Dam,Spillway,Energy dissipation arrengement,Fish pass,Residual flow arrengement,Intake,Canals,Tunnel,Penstocks,Power house
Minor Project : Digital Code Display System
Details : Project developed for Power Display Purpose.
Requirements : General Purpose PCB, IC, capacitors, resistors,transistors, diodes.
Practical Training & Seminar
Company : RVPNL, 132 KV G.S.S, dungarpur,rajasthan
Duration : 30 Days
Company : CAD DESK Vaishali Nagar,Jaipur
Duration : 45 Days
Seminar : Magnetic RAM
Work Experience
- Fresher
Extra Curricular Activities
- Writting Dairy
Strength
- Result Oriented Approach
- Team Player with “CAN DO” attitude.
- Hard working.
- Self dependent

Declaration
I consider myself familiar with Electrical Technology Aspects.
I hereby declare that the information furnished above is true to the best of my knowledge.
Date _____________
Place _____________ _____________
(Arvind Pandey)
-------------------------------------------------------
More Information about this submission and submitter :-
___________________________________________________
Submission ID : 4352152
Date & Time : 9th Jul 2011 8:47 PM (UTC)
IP Address : 123.236.245.93
Browser Info : Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.112 Safari/534.30
Predicted Country []: India