<Insert Picture Here>
IT Project Performance Management with Oracle BI
Mark KromerOracle Principal Product Manager
Agenda
• Introduction to Oracle Primavera & Project Analytics• Business benefits of Project Analytics• Enterprise Reporting for IT Projects• Oracle BI (OBIEE)• Sample Dashboards & Demo
• [email protected]• http://blogs.oracle.com/eppm• http://www.beyeblogs.com/bippm
A Few Questions First …
1. Do you use business intelligence tools in your job?2. Are you familiar with OBI?3. Do you use EBS Oracle Projects?4. Are you familiar with Primavera?5. Do you use PeopleSoft Projects or Programs?6. Microsoft Project or Excel for managing projects?
Management Excellence:The Next Competitive EdgeMade Possible with BI & Analytics
Time
Competitive
Advantage
OPERATIONALEXCELLENCE
MANAGEMENTEXCELLENCE
Cost
Quality
Speed
Smart
Agile
Aligned
4
Analytics from ProjectsProject Portfolio Performance Executive Reporting PortalTurn Insights into Action
P6 Reporting Database is basis for P6 Analytics, turning mass amounts of data into insights
Link back to P6 from the OBI Reporting Portal to view and update projects and portfolios
P6 Analytics and Reporting DatabaseBusiness Benefits
• Manage by exception with project and portfolio performance dashboards
• Uncover root-cause of poorly performing projects with interactive drill-down
• Actionable BI enabled with drill-through directly into P6• Look at resource utilization across all projects• Perform portfolio analysis based on any custom or prebuilt
objectives• View trends from past project history to uncover best practices for
improving current projects
IT Project Analytics ContentEnterprise Project Reporting Benefits
Data Visibility• Data Warehouse• Data models for earned
value, capacity planning, staffing
• Look at values across the entire
database• Activity codes can be
used to group, sort or filter over all the activities in the
database
• Removes reporting burden off production
system
Business Intelligence
• Pre-calculated, summarized and
aggregated data for fast querying
• Access reports using standard SQL and
reporting tools• Utilizes existing security controls and
hierarchies
Flexibility• Customize and create
your own dashboards with OBIEE
• Enhance Project Analytics with other
enterprise data• Add ERP, CRM, work
orders, financials, etc.
• Include data sources from disparate
systems• Essbase
• SQL Server• MySQL
Critical Factors to IT Project Success
Portfolio AnalysisChange Management (Projects & Systems)
Performance Tracking (Costs,
Schedule, Resources, EV)
Oracle provides many ways to turn your project & program failures into successes
Disconnected systems
Are we working on the right projects?
Can you answer your business questions?
ORACLE’S EPM ECOSYSTEMOracle Business Intelligence
Oracle’s EPM System
EPM Workspace
OLTP & ODSSystems
Data WarehouseData Mart
SAP, Oracle, Siebel,PeopleSoft, Custom
ExcelXML
BusinessProcess
OLAP
Fusion Middleware
Business Intelligence Foundation
BI ApplicationsPerformance ManagementApplications
Oracle BI ApplicationsComplete, Pre-built, Best Practice Analytics
Travel& TransTravel
& TransAutoAuto Comms& MediaComms& Media
ComplexMfg
ComplexMfg
ConsumerSector
ConsumerSector EnergyEnergy Financial
ServicesFinancialServices
HighTechHighTech
Insurance& Health
Insurance& Health
LifeSciences
LifeSciences
Public SectorPublic Sector
and Other Operational & Analytic SourcesSource adapters:
Sales MarketingProcurement
& Spend
Supply Chain & Order
ManagementFinancials
HumanResources
PipelineAnalysis
ForecastAccuracy
Sales Team Effectiveness
Up-sell/ Cross-sell
Cycle Times
Lead Conversion
Employee Productivity
Compensation
Compliance Reporting
WorkforceProfile
RetentionAnalysis
Return on Human Capital
General Ledger
AccountsReceivable
AccountsPayable
Cash Flow
Profitability
ExpenseManagement
Revenue andBacklog
Inventory
FulfillmentStatus
CustomerStatus
Order Cycle Time
BOM Analysis
Direct / Indirect Spend
Buyer Productivity
Off Contract Purchases
Supplier Performance
Purchase Cycle Time
Employee Expenses
Campaign Effectiveness
CustomerInsight
Product Propensity
Loyalty &Attrition
Market Basket Analysis
Campaign ROI
Service &Contact Center
ServiceEffectiveness
Customer Satisfaction
ResolutionRates
Service RepEfficiency
Service Cost
Churn & Service Trends
Oracle BI ApplicationsSingle- and multi-source Analytic Apps Built on BI Suite EE
Oracle BI Suite EE Plus
Ad-hoc Analysis
ProactiveDetectionand Alerts
MS OfficePlug-in
Reporting & Publishing
Interactive Dashboards
DisconnectedAnalytics
WebServices
Oracle BI Applications
Sales
Service &
Contact Center
Marketing
Supply Chain &Order
Management
Procurement
and Spend
FinancialsHuman
Resources
PackagedETL Maps
UniversalAdapters
Legacy Project Management, Budget Management,
and AccountingSystems
DW Schema
Projects
13
Oracle BI ServerNext-generation BI and Analytics Server
• Simplified business model view
• Advanced calculation & integration engine
• Intelligent request generation and optimized, distributed data access
• Mission critical scalability and performance
14
Common Enterprise Information Model“Model once, deploy everywhere”
End user adoption is about information consistency and availability where and when its needed. The Common Enterprise Information Model breaks down data
silos and makes information available on-demand.
<Insert Picture Here>
Oracle Project Analytics Sample Dashboards/Reports
<Insert Picture Here>
Oracle Project Analytics Integration with Financial Analytics and Procurement & Spend Analytics
Integration with Procurement and Spend Analytics
Integration with Procurement and Spend Analytics
SAMPLE DASHBOARDSScreenshots from P6 Analytics R1
Pre-built and pre-mapped metadata makes building ad-hoc queries and customizing out-of-the-box reports quick & easy for business
users. No need to call IT to change a report on a dashboard.
Landing page for P6 Analytics
Customize dashboards and
save them as your own personal dashboards
Project Health: Critical Activities Behind Schedule
Export or print to many different
multiple formats including PDF,
PowerPoint, Excel and more.
Earned Value: Cumulative + Period values
Use filters to select project or portfolio earned value
by projects, portfolios, time period, project codes or
pick your own fields
Resource Utilization with interactive drill-down
Dashboard reports can be changed on the fly by selecting
slicers
DEMOOracle’s Primavera P6 Analytics with OBIEE
AQ&