project & portfolio intelligence for hp ppm reporting & dasboards
DESCRIPTION
We help world-wide HP PPM customers succed in their project by enabling them analyse, visualise and understand their projects better. PPI is a plug & play business intelligence platform for HP PPM dashboards & reports. compello.com.trTRANSCRIPT
How much hidden effort are we spending for
proposals which do not turn into project?
What is the current capacity of all resource
pools?
When did my project health
turned to RED?
Can I create my own reports?
Why do I have to enter my
username and password
twice?
All modules are linked each
other
All data is grouped in a
comprehensive business view I can access to
historical information.
I can create ad-hoc reports and dashboards.
After logging on to PPM portal and
no need to log on to reporting portal
again.
All modules are integrated in
metadata layer.
Summary to detail data access is
enabled.
Historical data mart provides
timely information.
Reporting metadata layer.
Integtrated security layer.
Missing linkages among modules.
Lack of global look at all data Data logging time.
Ad Hoc Reporting capability
Duplicate security
modules.
Traditional PPM reporting is constrained by technical view
PPI creates a cross functional view of the Project related information
What users see
Creates Advocates
Integrated PPI solution
Detailed views of information highlight common fundamental information issues
• Multiple versions of the truth– Problems managing request, proposal, project, timesheet and resource
data and interactions– Regulatory compliance inhibited by poor transparency
• Lack of trusted information– Incomplete, out-of-date, inaccurate, misinterpreted data– Difficult to understand or control how information is used
• Too much information and not knowing what’s important– Not using signals to drive Project Management– Not leveraging valuable unstructured information
• Lack of agility– Inability to take advantage of opportunities for innovation– Escalating costs due to inflexible systems and changing needs
Project & Portfolio Intelligence Approach
Product Platform Strategy
Product Line Strategy
Sustained Differentiation
Time-to-Market Strategy
Strategy• ANSI SQL is used to
create DB Schema for enabling db independency.
• ETL is based on Oracle PL SQL Scripts
• Selected BI platforms are BO and Cognos
• Security adapter is coded in .Net
• PPI is an operational reporting solution for PPM
• It is a complementary solution which creates KPI’s for Executive reporting
• Hundreds of metrics are accessed from a single point of view
• Complete coverage of all PPM modules
• Security integration• Predictive analysis• Generally accepted DW
strategy is used• ETL platform adoption.• 64 best practice reports.• OLAP is enabled• Integrated row level
security
• Quick implementation• 3rd party adoption• Ease of use• High speed deployment
Breadth and Depth of Reporting
Ad-Hoc
Dashboard
Manage
d
Mobile
Business oriented information
Transforms data from PPM into actionable information, enabling executives, managers, business analysts, and project managers to measure, monitor, and report on PPM.
Each user can access to appropriate metadata information depending on his profile.
Modules are designed for users to enable them focus on their business easily.
How are we doing?Dashboards
Why?Reporting & Analysis
Integrated Security
PPM
Easy! Define data access once in HP PPM: Single
Sign-On is active
Leverages existing infrastructure:Can be easily integrated with LDAP/ADSecurity adapter uses the same
encryption algorithm with HP PPM
Authorization Integration
Col1 Col2 Col3 Col4 Col5Col1 Col2 Col3 Col4 Col5Col1 Col2 Col3 Col4 Col5• Column level security and• Row level security are enabled at db layer. PPI automatically understands the user restrictions in PPM and applies it directly to the metadata layer.
Ad-Hoc Reporting
Enables users to add new content to their existing reports to meet changing project management requirements quickly and cost-effectively.
Enables users to create new variations of calculations and apply dynamic filters
Pre-defined aggregation rules help users quickly group and summarize the data without technical help.
Automated report distribution Flexible distribution methods: scheduled, event-driven, centralized Web-based
access, email, Microsoft Office support
PDF, XML, HTML and CSV output types
Send the reports to print, fax, disk, sms or email
Multi-language support
Internet
Model
Multiple language
Built-in reports, and templates
60+ Operational reports, dashboards and templates
Dynamic – Rich graphics capabilities
Create a single report that users can access on multiple devices
PredictionsINPUTS
- Green Health Duration Ratio- Yellow Health Duration Ratio- Red Health Duration Ratio- # of Schedule Updates- # of Budget Updated - Planned Budget- Labor Budget Ratio- Non-Labor Budget Ratio- Budget Realization- Is Long Term Project?- # of Tasks- Delayed Tasks Ratio- # of Project Managers- # of Resources- Avg Resources per Task- Avg Duration per Task- Resoucre Grade A Ratio- Resoucre Grade B Ratio- Resoucre Grade C Ratio- ...
OUTPUTS
Status
Cost Variance
Where clients see value
• Targeted analysis for Project & Portfolio Management Application
• Faster Time to Value– Project & Portfolio Intelligence methodology is proven accelerator– Mining capabilities are embedded via proven SPSS technology
• Lower TCO – Look at all costs and over a 3 – 5 year time horizon– Open standards & Industry Standards– Expanding ecosystem of application tool providers
• Solution Performance– Software has been optimized for data warehousing