Transcript BI Publisher - UK Oracle User Group

Using Analytics to drive
transformation in HR
Caroline Gladwin
Master Principal Sales Consultant
1
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
The following is intended to outline our general product direction. It
is intended for information purposes only, and may not be
incorporated into any contract. It is not a commitment to deliver any
material, code, or functionality, and should not be relied upon in
making purchasing decisions. The development, release, and
timing of any features or functionality described for Oracle’s
products remains at the sole discretion of Oracle.
2
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Agenda
 Getting the most from BI Publisher with eBusiness Suite
 What are existing customers doing with HR analytics?
 HCM Cloud reporting
 Latest BI mobile developments with BI
3
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Publishing Engine – BI Publisher
Flexible Layouts
XML
Multiple Report Outputs
Multiple Data Sources
4
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Oracle BI Publisher In Oracle Products
Oracle
Business
Intelligence
BI Publisher
Enterprise
BI Publisher
Oracle
Applications
5
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Oracle
Products
BI Publisher deployed in eBusiness Suite
- Called XML Publisher
- Setup in EBS environment
- Create reports in eBS environment
- Use Concurrent Request process to run
- Supported Templates are eText, PDF, RTF, Excel
Oracle
eBusiness Suite
XML Publisher
6
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
BI Publisher alongside eBusiness Suite
- Called BI Publisher
- BI Publisher instance is outside eBusiness Suite
- Prebuilt security integration
- Opens up full functionality
-Templates, web services, GUI data models,
scheduling ..etc
- Licensing implications if data sources go beyond
eBS standard tables
Oracle
eBusiness Suite
BI Publisher
7
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Enhanced E-Business Suite Support
 Multi-Org Support
 Select Responsibility at
Login
 Switch Responsibility after
Login as needed
 Respects E-Business Suite
data level security
 Join E-Business Suite data
with other sources (subject
to license)
8
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
See It In Action – HR Business Partner
9
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Agenda
 Getting the most from BI Publisher with eBusiness Suite
 What are existing customers doing with HR analytics?
 HCM Cloud reporting
 Latest BI mobile developments with BI
10
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Operational  Strategic
Focus on Extensions that will Deliver Value
Predictive:
What will
happen?
Classic analytic platforms
Descriptive:
What is
happening?
Diagnostic:
Why did it
happen?
Modern analytic platforms
Level of business impact
11
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Hyperion for Headcount Planning
A platform to build analytic applications which
allows users to model, analyze, and interpret
complex business scenarios
Enables ‘speed of thought’ modeling of alternative
scenarios
Centralized functions, calculations, aggregations
12
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Integrated Scorecards for Strategic Focus
Enterprise KPI watch list
Business views
Centralized semantic layer
13
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Complete drill down
to transaction detail
Data Mining for Agile & Scalable Predictions
Data mining and in-database analytics
Massively scalable, secure, fast predictive
analytics; integrate into BI Dashboards
Accelerate modeling of key scenarios – for example
top performers vs likely attrition*, what are the
attributes of an “ideal” employee
* We have provided a model like this in Fusion with Workforce Predictions
14
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Endeca for Broader Data Discovery
Agility
Innovation
Business Self-Service
See New Patterns
Ask New Questions
Confidence
+
Add New Data
TEXT
Ad-hoc, Reactive, Iterative
+
IT Stewardship
Structured Data
Sources
Unstructured Content
Planned, Provisioned, Trusted, Secure
Put the data first and create a dynamic relationship
between business and IT enabling iterative prototyping
and collaborative decision making
15
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Combine data from existing enterprise investments with
non-traditional sources containing unstructured and text
heavy content for broader perspectives and deeper
insights
Empower the business with self-service
discovery whilst maintaining IT
stewardship to ensure responsible
decisions the enterprise can trust.
Links to look at after today
 Voice of the Workforce
– http://www.youtube.com/watch?v=PG6t7kTBZ3Y
 Workforce Predictions
– http://www.youtube.com/watch?v=lKhX5MOQCOw
 BI Applications Overview
– http://www.youtube.com/watch?v=YiP8_N8-xmU
 Cross Pillar Day in the Life of ...
– http://www.youtube.com/watch?v=Pg6JECpfvKc
16
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Agenda
 Getting the most from BI Publisher with eBusiness Suite
 What are existing customers doing with HR analytics?
 HCM Cloud reporting
 Latest BI mobile developments with BI
17
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Cloud Expectations are Different
CONSUMER STYLE
EXPERIENCE
SELF-SERVICE
EVERYTHING
ENTERPRISE-CLASS
INFRASTRUCTURE
18
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
The Oracle Cloud gives you Options
HCM
Cloud
CRM
Embedded BI
ERP
Sales
Context Sensitive,
Real-Time Analytics
in Application
19
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
OnPremise
Integrated
Analytics
Self-Service
Analytics
Reporting in Fusion HCM SaaS
Fusion
Embedded
Content
Publishing
Engine
(BI Publisher)
20
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Ad Hoc
Reporting
(OTBI)
HR Analytics
(On Premise/
On Demand)
We also now have an
Oracle BI layer for Taleo
Recruitment
1. Fusion Embedded Content
Manager Resources Dashboard
Embedded Intelligence
 Real-time analytics
Employee Profiles
 Information is in context
 Visual cues guide actions
Performance Management
21
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
2. Fusion End User Ad Hoc Reporting - OTBI
• Data
•
•
•
•
Real-time
Access what is defined + flexfields
Not designed for full analytics
Fusion data only
• Users
• Self-service for everyone
• Wizard driven or fully functional
• Security
• Fusion Security
• Prebuilt Content
• Starter pack of pre-built reports
• 100s of metrics and attributes
22
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Fusion OTBI Content Summary (Current)
Benefits
• Action Items
• Enrollment
Opportunities
• Enrollments
• Potential Life Events
• Setup
Workforce Goals
•
•
•
•
23
Goal Alignments
Goal Status Overview
Goal Tasks
Target Outcomes
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
• Salary Details
• Stock Details
• Workforce
Compensation
Workforce
Performance
• Performance Document
Status
• Performance Rating
Distribution
• Performance Rating
• Performance Task
Status
Workforce Talent
Review
Payroll
Compensation
•
•
•
•
•
Payments Costing
Payments Distribution
Payroll Run Costing
Payroll Run Results
Retroactive Pay
• Talent Review Meeting
Workforce
Profiles
• Library Objects
• Model Profile
• Person Profile
Workforce
Management
•
•
•
•
•
•
•
Absence
Employment Contract
Grade Rate
Person
Position
Work Relationship
Worker Assignment
Event
• Worker Assignment
3. Fusion Publishing Engine – BI Publisher
• Data
• Real-time
• Broader access (OTBI + HCM
Extract + Base Tables)
• Not designed for full analytics
Flexible Layouts
XML
Multiple Report Outputs
Multiple Data Sources
24
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
• Users
• IT builds data model (normally)
• End users update layouts
• Security
• Outside Fusion Security unless
OTBI or secured view is source
• Prebuilt Content
• Used for lots of specific output
styles and reconciliation reports
Hybrid On Premise and Cloud - HR Analytics
• Data
•
•
•
•
•
Taleo
LMS
BI Applications
• Users
• Interaction same as OTBI
Peoplesoft
Data Warehouse
Fusion
Other Sources
25
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
As at the last load
Data from any source
Full analytical platform
Cross functional
Extend to what if, predictions, unstructured
data etc
• Security
• Flexible
• Prebuilt Content
• Broad library of content, 1000s of metrics
Release 8 – BI Highlights
 Human Resources OTBI
Fusion Apps Cloud Adapter
–
Payroll Element Entries Subject Area
–
Succession Management Subject Area
–
Document of Record Subject Area
–
Global Absence subject area
–
Enhancements to Performance, Payroll and Core
HR existing subject areas
–
Expose long fields /Endeca apps
–
Sample Endeca application extensions
Uptake of new technology features
–
Certifications
–
 Human Resources OBIA
26

–
Talent Management Analytics (Fusion)
–
Absence Management (Fusion)
–
Enhanced Snapshots (Restatement)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Support for data integration from Fusion
Cloud to On-Premise OBIA (not Taleo yet)
 Common Projects OBIA
•
EBS 12.2
•
PSFT 9.2
* Note – this is an ODI release, Informatica
releases to follow
Cloud Adaptor: Cloud-Only Data Sources
Example - support Fusion Cloud & On-Premise OBIA
Cloud Services
Fusion
CRM
OTBI
Fusion
HCM
OTBI
Cloud
Adapter
On Premise
OBIA
27
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Cloud Adaptor: Hybrid Data Sources
Example - support Fusion Cloud & On-Premise PeopleSoft, OBIA
Cloud Services
Fusion
HCM
OTBI
Cloud
Adapter
On Premise
PeopleSoft
Financials
OBIA
PeopleSoft
Core HR
28
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Next goal is to offer offer another option …
Example - support Fusion Cloud, On-Premise EBS, & Managed Cloud OBIA
Cloud Services
OTBI
On Premise
E-Business
Suite ERP
29
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Adapter
Fusion
HCM
Managed Cloud Services
Cloud
Fusion SaaS
OBIA
Oracle Planning & Budgeting Cloud
PREVIEW
CUSTOMER
“The addition of Oracle Planning and Budgeting Cloud Service to
Oracle’s Cloud portfolio offers us more choice in deployment. We
found Oracle Planning and Budgeting Cloud Service particularly
easy to use with good response times and all the functionality that
we expect from a sophisticated planning application.”
Steve Tevault
Database Administrator,
Friendly's Ice Cream
30
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Links to look at after today
 Oracle HCM Cloud is Insightful
– http://medianetwork.oracle.com/video/player/3227593696001
 Planning & Budgeting Cloud (currently all the videos have a financial
planning focus)
– http://www.youtube.com/playlist?list=PLdhsk2_nr_0Xj7f0OYj-
0e1nO6j4VtVdB
31
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Agenda
 Getting the most from BI Publisher with eBusiness Suite
 What are existing customers doing with HR analytics?
 HCM Cloud reporting
 Latest BI mobile developments with BI
32
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
What is reporting like now?
extract
complex
inflexible
inconsistent
repetitive
excel
slow
incomplete
clunky frustrating
too late
inadequate
risky
hard-coded
IT-centric
confusing
time-consuming
33
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
What do you need for the future?
Self-Service
Flexible
Forward Looking
Timely
Consistent
Easy to Use
Tailored to users’ needs
Joined-Up
34
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Relevant
Multi-source
Simple
Drill-down
Fun
Mobile
Mash Up
Mobile Access to Increase Adoption
2×
Adoption Rate
Source: Aberdeen Group
35
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Oracle BI Mobile
Mobile uptake
 Seeing steady increase in
Mobile Adoption
– Large customers embracing security
toolkit
– Allows users to leverage their BI
investment
– Public demo server seeing significant
activity
36
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Two approaches to mobile access
Both are licensed together – customers get both capabilities
BI Mobile HD application
37
BI Mobile App Designer
Need to discover and access existing BI
dashboards on mobile devices
Need to create and deploy custom mobile
reports/apps on mobile devices
Apple tablets and phones only (Android
coming soon)
iOS , Android, Windows8 Mobile tested but
all HTML5 devices should work. Also view
through BI Mobile HD app
Regular updates on App Store
Versions released as part of BI Foundation
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
See It In Action – HR Executive
38
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
THE COMPLETE
BUSINESS ANALYTICS
SOLUTION
39
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.