request trainig
request quote
Courses & Event

Oracle business Intelligence Enterprise Edition 

OBIEE (Siebel Analytics) is a powerful enterprise capable BI/Reporting/Analysis tool that is rapidly gaining solid market share and recognition. This is despite Siebel's (and to a lesser extent) Oracle's lack of marketing it is a pure play platform. The will sell it to you, but it's not really their focus.

If so, then what is? The answer is BI Applications.

BI Applications, whether you believe it or not, are the future of Data Warehousing and Business Intelligence. Just as the mid sized and large companies throughout the world have adopted large ERP, CRM, Billing, and HR applications, so to will the world adopt BI Applications. Siebel was one of the first to preach this message, and now Oracle is preaching it as well, although on a much larger scale, with significant development and marketing resources behind it.

This two part post will overview BI Applications in general, but focus on Oracle's BI Apps. It will cover the whys and whats, pros and cons of a pre-built data warehouse & BI system.

What is a BI Application?

In a generic sense, it is simply a complete pre-built BI and Data Warehouse system. It encompasses ETL, a data model, a technology platform, metadata and pre-built analyses and reports. Just download the software and the application configuration files, install, load the data and you are ready to go. In some cases it really is that simple.

A full BI application, such as Oracle's, contain everything professionally done by an engineering team at the direction of not only technical experts, but also industry and functional experts. A basic BI application goes far beyond "industry standard data models", and would include all necessary ETL, data model, BI tool MetaData, and pre-built reporting content. Some may even go further to include change data capture or integrations with other consumers such as front end applications, portals, advanced data services, or even other BI tools.

Within Oracle's world of applications, there is some potential for confusion given their names. Oracle presently sells three different OBI EE base applications; 2 of them are called Fusion Intelligence (there is one for Oracle EBS & DBI, and another for PeopleSoft & JD Edwards). Note that these applications are officially not part of Oracle's direction, and will not be actively pursued. Instead Oracle is focusing on it BI crown jewel, the poorly named BI Applications. It is these BI Applications, which include nearly 50 modules such Applications as Marketing Analytics, Partner Analytics, Service Analytics, and Sales Analytics that this post is discussing.

Why Create a BI Application?
The answer is identical to why we have ERP systems today. SAP, PeopleSoft, Oracle EBS, Baan, Siebel, Clarify, etc were all built with the same thought in mind: a customer can buy a fully functioning system instead of going through the risk, cost and delay of building it themselves. It just started with the front end systems first. Now that the vast majority of the fortune 2000 companies have standardized on one or a few ERPs, the ability to make a pre-built BI system becomes possible. Only with clearly defined data models existing through out so many companies is cost effective to have pre-built ETL, and with pre-built ETL comes the vast majority of the benefit of the BI Apps from an effort perspective.

OBIEE Training Modules

erver Architect

Data Warehouse Basics
Facts and Dimensions
OLTP and OLAP Differences

  • Star
  • Snow Flake
  • Galaxy

Over View of Business Analysis
Introduction to OBIEE
Importance and Features of the Tool
Architecture of OBIEE
Installation of OBIEE
Overview of Oracle BI components
Gather information to Start building Business Model
Create ODBC Connections
Importing a data Source
Defining  Keys and Joins
Defining the Repository logical Structure
Building simple Fact Measures
Customizing the presentation Catlog
Setting Query Limits
Cache Management
Introduction to Cache
Cache Features
Modifying Cache parameters
Purge the Cache
Seed the Cache
Slowly Changing Dimensions
Importance and implementing SCD
Configuring the Event Poll Tables

Report Developer
Introduction To

Different Views
Creating and Modifying Reports
Creating Dashboards
Dash Boards Pages
Working with DashBoard objects
Working with filters and Promts
Guided Navigation Links
Cofiguring Bi Scheduler tables
Configuring Scheduler
Creating and delivering an ibot
Introduction and working with BI Catlog Manager

Checking Consistency
Importing Additional Product Tables
Creating Multiple Sources for a logical Table source
Specifying the Most Economical Source
Testing the Repository
Creating Calculation Measures using Logical Columns
Creating Calculation Measures using Physical Columns
Creating Calculation Measures using Calculation Wizard
Creating Dimensional Hierarchies
Creating Level Based Measures
Define Share Measure and Rank Measures
  Types of Partitions
Modelling a value Based Partition
Using Dynamic Repository Variables
Time Series Functions
Creating Users and Groups
Assigning permissions to users
Object Level Security
Data Level Security
Introduction and working with ODBC Client

Audio Visual Training
BI- Publisher

Installing and configuring Bi Publisher
Creating RTF Templates
Creating PDF Templates
Creating Reports in XL Templates

Introduction to Bi –Apps
Working with Prebuilt Applications Repository 

Request a Training

Home | About Us | Consulting | Development | Training | Clients | Careers | Contact Us

Copyright 2010.