Project Analytics Deep Dive

This one day course gives students the opportunity to learn out of the box functionality of Oracle’s Project Analytics application including an overview of the project analytics data warehouse, project metrics and key performance indicators. Students will be exposed to project dashboards and reports through hands-on exercises.

Audience:

Business users (project accountants, project managers, etc.), Business Analysts, ETL Developers, OBIEE metadata and report developers.

  1. Understand Oracle BI Applications architecture
  2. Understand the capabilities of the out-of-the-box Oracle Project Analytics from either Peoplesoft Projects or Oracle eBusiness Suite Projects
  3. Out of the box Project Analytics reports and metrics
  4. Out of the box Project Analytics star schemas and ETL logic
  5. Understand deployment options, security and integration into ERP systems
  6. Understand the typical configuration tasks

Suggested Prerequisites:

Knowledge of Data Warehouse Design and Project Data

Time Description Goal
9:00 - 9:30 Introduction to Oracle BI Applications Application components & architecture
9:30 - 10:45 Project Analytics Reports and Dashboards Presentation & hands-on exercise modifying project reports
10:45 - 11:00 Break
11:00 - 12:00 Project Analytics Metrics and Metadata Presentation & hands-on Oracle Answers exercise and demonstration of pre-built Oracle BI repository
12:00 - 1:00 Lunch
1:00 - 3:00 Review of Out of the Box Star Schemas Financial data structures and key metrics
3:00 - 3:15 Break
3:15 - 4:00 Security, User Interface Options, Integration into ERP Deployment options, Action links, Flex fields, & Security Integration
4:00 - 4:45 Configuration Tasks (CSV Files, Fiscal Calendars, etc.) Chart of accounts, Fiscal Year, & Multi Currency
4:45 - 5:00 Wrap-Up and Q & A

Download Course PDF: Project Analytics Deep Dive