O_GoldPartner_OAEC
UKOUG-POTY-2011-Primavera_and_Oracle_Projects_and_Business_Intelligence
Institute of IT Training - Accredited Learning Facilities Provider

Projected on...

Twitter
LinkedIn
RSS Feeds
Home Products Business Intelligence Oracle Project Analytics
What is Oracle Project Analytics?

Project Analytics is the latest of the OBIEE+ based BI applications to be released and is made up of four main components:

  • Pre-built warehouse
  • Pre-built Extract Transform and Load (ETL) process
  • Pre-mapped metadata including over 350 pre-built calculations and metrics
  • Best practice library of over 120 reports.

The Analytics tools can gather data from all manner of places through adapters, one of which is for Oracle EBS, so even if you need data from outside EBS altogether it can be accessed. 

The pre-built dashboards and metadata report against the following Subject Areas:

  • Project Billing
  • Project Budgets
  • Project Costs
  • Project Forecasts
  • Project Funding
  • Project Performance
  • Project Revenue

Most of these are self explanatory as they map to areas within Oracle Projects. The Performance subject area has the main financial performance measures drawn from the other areas collected together for ease of use.

The result of Oracle’s investment in this pre-building is an immediately useful set of reports and the capacity to develop reports and dashboards in a very short space of time.  More good news is that the dashboards are role based and sit within Oracle’s “Single-Sign-On” regime so security is respected and enforced. 

Here is an example of one of the "out of the box" dashboards, the Project Executive Overview:

alt

Click here to see an Oracle presentation about Project Analytics (Flash)