Project Partners Blog


Using Oracle Project Analytics Within Engineering and Construction Firms – Part 2

By Robert D. Anderson, CPA

This blog article is a continuation of the June 7 article.

Financial Focus

It is important to note the development of the analytic package was done by the Oracle OBIEE team and did not include the assistance of the Oracle Project Development group.  As a result of this development approach, some items viewed as important by heavy project users, such as Engineering and Construction firms, are not included in the initial release of Project Analytics. 

As you review the items included in the last graphic from last week’s blog, note the focus areas all have a financial slant.  All the delivered functionality is taken from the core Project Accounting applications of Project Cost and Project Billing.  No data elements from Resource Management or Project Management are included.  The purpose of this webinar is to provide assurance this can be handled and all the needed information can reside within the OBIEE warehouse.  Project Partners can help you with this.

Oracle Project Analytics provide robust analysis of project-based forecasts, budgets, cost, revenue, billing and profitability data elements.  It is integrated with the other OBIEE analytics to deliver cross-functional analysis of project related data in areas such as accounts receivable, accounts payable, invoice aging or status of procurement transactions by project.  The pre-built ETL, DW, Dashboards, Reports, Metrics, KPI’s and Business User Tools support the use of data across the active PBIEE installed components.

Data provided by Oracle Project Analytics

Data provided by Oracle Project Analytics

What’s Included

Oracle delivers a very robust set of dashboards, reports and metrics across three primary groupings, as shown in the following graphic.

Oracle Project Analytics Metrics

Oracle Project Analytics Includes Over 500 Metrics

Business Roles of Users

Oracle further defines the business roles that would use each of the pre-defined roles, as shown in the following graphic.

Roles of Oracle Project Analytics Users

Roles of Oracle Project Analytics Users

 

Interaction with Microsoft(R) Office Suite

Oracle Project Analytics offers integration with Microsoft Office Suite.  One of the more powerful features, from the perspective of the Projects area,  is the ability to automate the period updating of the project review decks used across hundreds of firms every cycle (weekly, monthly, quarterly) and by various levels within the organization.  To use this functionality, there are several steps you you must first complete, and I’ll discuss those in the webinar.  For now, take a look at the exciting screenshot below.

Integrate Microsoft Office and Oracle Project Analytics

Integration of Microsoft Office Suite and Oracle Project Analytics

 

Learn Much More

Learn more by attending the free webinar. Register to attend here.

Leave a Reply

You must be logged in to post a comment.