Transcript Roadmap to Success in Enterprise Analytics: an

Roadmap to success in
Enterprise Analytics: An eBay Story
Shyam Sunder Pariavakkam – BI Finance Manager, eBay Marketplaces
Karan Rawal - BOBJ Architect, eBay Corporate Business Intelligence
Heena Sood – Vice-President, Analytics and Mobility, ZEDventures
John Doss – Sr. Director, Practice Lead, HANA and BI, ZEDventures
Vasu Pabbaraju - Practice Lead, Integrations and Mobility, ZEDventures
Agenda
1.
Introductions
2.
eBay Journey: Enterprise Analytics
3.
Dashboard Design Best Practices and Tool Selection
4.
eBay Marketplaces user adoption story
5.
Mobility at eBay
2
Session Objectives
At the end of this session, you should be able to
understand:
• How eBay evolved in the Enterprise Analytics space?
• How eBay selected and implemented the right Dashboard Development
tool based on the requirements of its user base?
• How eBay Marketplaces improved User Adoption in the SAP BI
Enterprise Analytics platform?
• How eBay evaluated mobility options and capabilities available within
the SAP BI suite?
• Key Learnings
3
Enterprise Analytics: The eBay Journey
SAP
BW
SAP BOBJ for
Marketplaces
SAP
BO40SP2
Upgrade
to SAP
BO40SP4
CIO
Dashboard
on Ent.HANA
SRM &
Bank
Balance
Reporting
HR Reporting
Tech Go-Live
& Legal
BW on
HANA
HANA
Ent
2011
Q2
2012
Q3
2012
Q4
2012
Q1
2013
Q2-Q3
2013
Q4
2013
2014
Finance
Transformation
Self-Service
Reporting
Platform /
Env. Stability
User
Adoption
Dashboard
Performance
Fit/Gap of BI Tools to
User Requirements
Key Business Drivers
BOBJ 4.0 SP2
BOBJ 4.0 SP4
4
4.1 SPx
Dashboard Design Best Practices
Factors influencing Dashboard Design
Data Security
Data Latency
Data Sources
Data Volume
Performance
Mobility
Scalability
User Experience
Dashboard Consumption
Dimensions for Dashboard Optimization
Optimize Data Model/BEx Query
Optimize Dashboard Design
Choose right connection type
(BICS vs BIWS etc)
Choose right visualizations
Provide user centric navigation
and interaction
PERFORMANCE
DATA VOLUME
USER
EXPERIENCE
USER
CONSUMPTION
5
Provide ‘drill to’ detail DB’s/reports
Add filters to limit the data
Trigger queries as needed
Mobile usage
Print and Export requirements
Offline consumption
Dashboard Selection Tool
SELECTION CRITERIA /
DASHBOARD TOOLS
DASHBOARDS DASHBOARDS
4.0 SP5
4.1
Flash
Development / Customization
Mobile Support (HTML5)
Preferred tool for BW/HANA
DESIGN STUDIO
1.1
DESIGN STUDIO
(1.2 AND BEYOND*)
Yes
No
Excel/Abode Flex
Java Scripts/CSS
Yes (not all components are
supported/available yet)
No
Preferred tool for Non-SAP Data Sources
and multi-source scenarios
Yes
Yes
Yes
No
Yes (Single-source
&.UNX is supported)
Yes
HANA/BEx only
Yes
Additional connections
planned
Data Connectivity - HANA/BEx/UNX
Data Connectivity – QaaWS/BIWS/XML
etc.
Offline Support
Yes
Yes
No
No
Yes
No
Navigation Panel, Export to Excel/Power
Point, Bookmarking
No
No
No
Yes (DS 1.4)
Yes (Excel/CSV export)
Power Point (1.3)
Bookmarking (1.4)
Interoperability with Advanced Analysis &
Lumira
No
Yes (supports only
AAE)
Supports Lumira(1.3)
BW Integrated Planning
No
No
Yes (DS 1.3)
Migration to Design Studio
Available
Limited Migration Support planned
beyond DS 1.3 version.
Yes
N/A
Yes
DS 1.2 (GA in Nov ‘13)
DS 1.3 (GA in Jun ‘14)
6
6
Enterprise Analytics: The eBay Journey
SA
P
BW
SAP BOBJ for
Marketplaces
SAP
BO40SP2
Upgrade
to SAP
BO40SP4
CIO
Dashboard
on Ent.HANA
SRM &
Bank
Balance
Reporting
HR Reporting
Tech Go-Live
& Legal
BW on
HANA
HANA
Ent
2011
Q2
2012
Q3
2012
Q4
2012
Q1
2013
Q2-Q3
2013
Q4
2013
Q1-Q2
2014
Finance
Transformation
Self-Service
Reporting
Platform /
Env. Stability
User
Adoption
Dashboard
Performance
Fit/Gap of BI Tools to
User Requirements
Key Business Drivers
BOBJ 4.0 SP2
BOBJ 4.0 SP4
7
4.1 SPx
Improving User Adoption within eBay
Thought Leadership
• Delivered Dashboards with Innovative Design
Approaches and enhanced UI/UX.
• Initiated & Adopted Best Practice
Development Guidelines for BW & BOBJ
Integration
• Partnered with IT to improve BOBJ application
and infrastructure stability
• Value-added input on SAP BI roadmap,
tools and strategy
• POC for Mobile enablement of MP data
• Alignment with IT for Technical Design
• Improved Development quality by
leveraging test system data during
development
• Streamlined the BW and BOBJ
Transport Process
SOLUTION
DELIVERY
PROCESS
PEOPLE
Executive
Sponsorship
8
• Improved Delivery pace by:
• Effective Prioritization of Pipeline
• Optimized Resource Allocation
• Following Informal Agile Processes
• Effective delivery of planned pipeline,
production support & coordination with
HANA project team
• Delivered additional ad-hoc reporting
requests
• Provided Overlap Backfill Resources to
ensure delivery continuity
• Cross-Technology (BOBJ BEx) Rampup of team resources for scalability of
resources
• Realignment of resources to meet expected
delivery pace
• Leveraged Shadow Resources to provide
team balance
Tracking eBay User Adoption of Analytics Tools
The new North America Master P&L is a great
solution for the NA FP&A, especially for NA CFO who
uses the summarized version of the report
regularly. This team has taken an innovative
approach to data access, the report automatically
refreshes every two hours so that I have immediate
access to current data in this very complex, intensive
report.
This report set eliminates the need to run multiple BW
reports to get the holistic view saving me one or two
days per quarter, and most importantly, I trust that the
numbers are accurate.
I'd like to give a huge shout out to Shyam and the
development team -- they were flexible in terms of
implementing changes and updates. Thanks for your
effort.
Thank you to the entire team. These dashboards
are awesome!
- Sr. Manager, Finance
- SVP, CFO Marketplaces
My team was very impressed with the BOBJ variance dashboard. I appreciate your effort and
focus to get this dashboard available by the target date. Great work!
- Director, Finance
9
Enterprise Analytics: eBay Mobility Strategy
SAP BI Mobile App
Leverage One SAP BI app for all Enterprise
Analytics
MOBILE BI APP
Design
Studio
Dashboard
Designer
• Web Intelligence – Reporting tool enabling
Dashboard functionality for certain use cases
• Dashboard Designer / Xcelsius – Legacy Dashboard
Tool with HTML5 publishing
• Design Studio – SAP recommended application for
HANA and BW based Dashboards
• Explorer/Lumira – Self-Service Dashboarding and
Analysis tool
HTML5 APP
WEBI
oData
Services
Explorer
HTML5 App
Leverage HTML5 frameworks to mobilize data
using oData services in certain use cases based
on
ECC
BW
HANA
• UI/UX requirements
• Customization/Integration/Other Technology
considerations
DATA SOURCES
10
SAP Mobile BI Tools Assessment Summary (BO 4.0 SP6)
Dashboard Designer/Xcelsius – HTML5
• HTML5 Dashboard performance is comparable to Flash Dashboard performance
• Minimal change in the dashboard development process
• Mobile components are limited and dynamic layout is not supported
Design Studio
• Intuitive WYSIWYG design environment for designers. Functionality extendable via scripting
language
• Dashboard design is heavily dependent on backend data models.
• Front-end data manipulation is implemented via java scripts
WebI based Dashboards
• Utilizes native iOS/Andriod visualizations and capabilities for mobile rendering & user interaction
• Key Webi Features are retained in Mobile App
• Best option for scheduled reports and report bursting scenarios
Explorer
• Utilizes native iOS/Andriod visualizations and capabilities for mobile rendering & user interaction
• Self-Service and guided data exploration/navigation. Provides Google-like search experience
• Minimal development effort enabling rapid deployment
Additional Details
Design Studio recommended by SAP as the key dashboarding application starting DS 1.3 version (GA Q2
2014)
Limited Dashboard Designer/Xcelsius to Design Studio Migration support maybe available beyond DS 1.3
version
11
SAP BI Mobile Tool Selection
CRITERIA /
TOOLS
DESIGN
STUDIO
DASHBOARD
DESIGNER
(XCELSIUS)
WEB
INTELLIGENCE /
CRYSTAL REPORTS
EXPLORER
RECOMMENDED
APP FOR
MOBILE BI
Enterprise HANA
Support
Highly
recommended
Not Recommended
Recommended
Recommended
for self-service BI
Design Studio
Flexibility
Very flexible with the
provided scripting
language
Not recommended by
SAP. Provides
flexibility in connection
types
Native functionalities can be
leveraged
Very flexible for
self-service BI
Varies based on
requirement
Reusability
Reusable Variables
and style sheets
Limited reusability
Limited reusability
No
Design Studio
Development
time
Steep learning curve
for developers
Tried and tested
Tried and tested
Extremely fast
development time
Explorer
Data Latency
Live data
Live data/Staged
Best for scheduled data
Live data /
Scheduled
Varies based on
requirement
Data Volume
Supports huge data
volume
Limited data set
Limited Data set
Supports huge
data volume
Design Studio/Explorer
Data Push/Pull
Pull
Pull
Push/Pull
Pull
Varies based on
requirement
Mobile
Rendering
/ Interaction
HTML5
HTML5
Native iOS/Android
Native
iOS/Android
WebI/Explorer
12
Key Learnings
•
Governance Structure & EA Strategy to focus on Agile execution but also allow for
delivery, technology and solution innovation based on developing trends
•
Strong Business & IT Partnership along with Executive Sponsorship leads to EA
Adoption and Proliferation.
•
Nominate Business Champion that understands and propagates the EA Strategy
•
Super User Engagement & Ownership is critical to the success of EA Delivery
•
Right Tool for the Right Purpose based on client defined criteria for success and
ROI
•
Adhere to Best Practices & Development Standards for Design & Development of
Reports and Dashboards
•
Project Management, Risk Management, and Change Management are just as
important, if not more important than a focus on technology
•
Select your Implementation Partner based on Thought leadership, Broad
Experience, Skill sets, Delivery Excellence and Focus within the Enterprise
Analytics space
13
About ZED
Business-aligned
Analytics Strategy and
Implementation
Enterprise Mobility
Solutions and Mobile
Dashboards
Cloud Strategy
and Roll-out
Systems Integration
using HANA between
On-premise, Cloud, and
Inter-cloud
Full-fledged ERP
Implementations /
Rollouts and Project
Management
VALUE-DRIVEN SERVICES FOR
14
Our Key Differentiators
Flexible Client
Delivery Model
Innovation & Competency
Center: ZED Labs
Service Lines and
Practice Areas
REPORTIN
G CATALOG
SOLUTION
OFFSITE
MOBILE
ANALYTICS
SOLUTION
ONSITE
OFFSHOR
E
CLOUD
PORTAL
SOLUTION FOR
SYSTEMS
INTEGRATION
• Hybrid delivery model with a
blend of Onsite, Offsite and
Offshore resources
• Overlap Backfill Resources to
ensure continuity and
consistency in delivery
• Shadow Resources to meet
expected delivery pace &
provide team balance
• Proof of Concepts / Demos
• Co-innovation with SAP
• Develop & Support ZED Solutions
• Training and RDS
VALUE-DRIVEN SERVICES FOR
15
• Value-added Service Offerings
and Solutions designed to
address industry-specific
challenges
• Tools, Methodologies, and IP to
support delivery and reduce risk
• Focus on UI / UX across
delivery in all industry verticals
and practice areas
ZED’s Reporting Catalog Solution
16
•
Single Point of Entry Portal to
consolidate all Reports across the
Enterprise
•
Single Sign-On & Integration with
Enterprise Identity Management
Systems
•
Customer-defined categorization of
Reports
•
Security Model for Reports inherited
from Source Systems
•
Customer defined, flexible user interface
•
Google-like Search Capability for
Reports
•
Access to Report Meta data like Title,
Description, Owner etc.
•
Create & Manage “Favorite Reports List”
by User
•
Reports-related Collaboration via
Comments, Instant Messages, and
Emails
•
Access Controls Integration
ZED’s Cloud Service Offering
On-Premise Solution
Cloud Solution
On-Premise Solution
Cloud Solution
SAP ERP SD
SAP CRM / Salesforce.com
SAP MM
SAP Ariba
SAP ERP HCM
SuccessFactors / Workday
Material Master
Items
SAP ERP PP, PM, CATS
Payroll / ADP
Service Master
Service Items
Vendor
Supplier
Outline Agreements
Catalog
Info Records
Catalog
SAP ERP FI/CO
T&E / E-Invoicing
17
Source Lists
Catalog
Purchasing Requisitions
Shopping Cart
Purchase Orders
Purchase Orders
PO Acknowledgement
Order Acknowledgment
Advance Shipment Notification
Advance Shipment Notification
Goods Receipt
Goods Receipt
Invoice Receipt
Invoice Receipt
Various Data Elements
Spend Analytics
On-Premise Solution
Cloud Solution
SAP ERP HCM
SuccessFactors BizX
Employee Master
Employee
Compensation Data
Compensation Data
Evaluation Data
Workforce Analytics
ZED’s Mobile Analytics Solution
• Data Source agnostic, Agile Mobile Dashboard
creation, and publishing framework to realize the
value of mobilizing enterprise data
• Integration with multiple SAP and non-SAP
sources
• iOS, Android, and Microsoft platforms are
supported
• Strong collaboration capabilities for enabling
publishing, sharing, and discussion boards
• Enables integration of BEx query to deliver BW
reports via a custom HTML5 frontend
18
Thank You
for Participating