Launch into the Oracle
Business Intelligence
Cloud Service (BICS)
Agenda
•
About Me
•
About BizTech
•
Introducing the Oracle Business Intelligence Cloud Service (BICS)
•
Guidance Through Exploratory Analysis
•
Deep Discovery Through Rich Feature Set
•
IntegraNng any Data Source
•
Going Mobile
•
BizTech’s Prebuilt SoluNons for EBS
•
QuesNons
Prior Experience: Project Experience:
Stephen Goldsmith
BI PracNce Partner
• Professional Summary
– Senior strategy, project management and
implementaNon consultant
– 20 + years combined industry and consulNng
experience
– Roles in over two dozen custom and packaged BI
implementaNon projects as well as mulNple Oracle ERP and EPM implementaNons.
• Qualifica>on Summary
– Expert in Business Intelligence methodologies and
strategy, business transformaNon, change management project management.
– Specific areas of Oracle knowledge include Oracle
Business Intelligence Cloud Services (BICS), Oracle TransacNonal Business Intelligence (OTBI), Oracle Business Intelligence (OBI) and Oracle Business Intelligence ApplicaNons (OBIA)
Mobile: (215) 680-‐3507
Email: sgoldsmith@BizTech.com Website: www.BizTech.com
100+
Employees
4
BizTech’s 18 year heritage…
400
+
Implementa>ons
9
Specializa>ons
Oracle PlaNnum
Partner & Reseller
Proprietary RapidApp
Methodology
Data Centers
throughout the U.S.
Avid OAUG Supporter
Oracle ApplicaNon &
Technology User
Onshore & offshore
capabiliNes
Philadelphia | New York | District of Columbia | Boston | Atlanta | Aus>n | Hyderabad | Shanghai | San Francisco
• Casual Users Require Guidance to Discover the Right QuesNons
• Analysts Require Richness of FuncNonality to Solve the Hard QuesNons
What Does It Take To Unlock Business Agility?
Any QuesNon
Any Data
Any Time
• Repeated Analysis Benefits from Access to Managed Data
• Agile Analysis Demands Data Mashup against User Data
• True Flexibility through Cloud Architecture and Economics
• Unchained Access through InnovaNve Mobile Authoring and ConsumpNon
Introducing Oracle Business Intelligence Cloud Service
• Exploratory AnalyNcs Interface on
Desktop or Mobile
• Data Mashup across Managed and
User Data
• Proven ReporNng SoluNon
• Integrated with Oracle DB
• Best-‐in-‐class Cloud Infrastructure
• Room to grow to full enterprise
plaeorm for all BI needs
• VisualizaNons automaNcally created and updated by
applying visual grammar to data selecNons made by user
• All visualizaNon types share foundaNon in visual grammar
Guidance Through Exploratory Analysis
Visual Grammar
Keyword Search
Pahern Brushing
• All relevant arNfacts are automaNcally indexed for search
• Unfamiliar data models can be intuiNvely accessed using
keywords
• SophisNcated technique to highlight correlaNons between visualizaNons
• Paherns highlighted across any components on the canvas
Visual Grammar Guides Users To Best Chart Type
• VisualizaNon type is
determined by analyzing ahributes chosen by user
• Adding new ahributes updates visualizaNon to expose deeper pahens
• TransiNoning between visualizaNons intelligently preserves configuraNon
• All guidance is based on a visual grammar that serves as foundaNon of user
experience
Keyword Search Guides Users Through Data Model
• Unfamiliar data models can be invesNgated using keyword search
• SelecNng search result automaNcally updates visualizaNon according to best pracNces
• Consumer-‐style
experience powered by deep integraNon between search engine technology and semanNc model
Brushing Guides Users To Discover New Paherns
• SelecNng data in one visualizaNon highlights correlated elements in everything else on the screen
• Seemingly simple user experience powered by incredibly sophisNcated analyNc queries
• 18 different components for analysis and discovery
• InnovaNve applicaNon of visual grammar
• Modern HTML5 architecture
Deep Discovery Through Rich Feature Set
VisualizaNon Library
Advanced Trellising
Streamlined Dashboards
• Ability to replicate any
visualizaNon across mulNple data elements
• Unlimited ahributes supported across both rows and columns
• Canvas model naNvely
supports mulNple synchronized visualizaNons
• No need to move between one UI for creaNng visualizaNon and another for composing dashboards
Rich Library of Visual Components
• 18 ways to visualize data
• CreaNve use of color, size, shape and various
coordinate systems
• Implemented via modern JavaScript library and
rendered through HTML5
Rich Trellising Exposes Deep Paherns in Data
• Any visualizaNon can be trellised by both columns and rows
• No limitaNon on the
number of ahributes used in trellis
• Brushing funcNonality also works within cells of trellis
Rich Canvas Model Blends ReporNng & Dashboarding
• Single interface for
creaNng visualizaNons and composing them together
• OpNmal use of screen real estate automaNcally
chosen for user
• Fine grain posiNoning and sizing accomplishing with simple dragging
BICS Can Integrate
Any Data
Source Quickly
Managed Data
User Data
• Breadth of Sources – from Databases, to Big Data
• Powerful tooling – to load and model data
• SemanNc Layer – Single source of truth
• Data Variety – just in Nme, external and personal data
• Smart Blending – full ability to blend data – beher than Tableau
• Fully Sharable – Personal analysis or share with team or everyone
Wide Range of Enterprise Data Sources
•
Oracle Cloud Data Sources
– Database managed service (schema)
– Metered database as a service (DBaaS)
– Exadata as a service*
– Big Data (Hadoop) service*
– Data IntegraNon Cloud Services*
•
On-‐premise Data Sources
– Databases, direct connect*
– ApplicaNon Extracts
– Files
* Expected Summer 2015
Powerful Tools for Data IntegraNon to Cloud
File Loader
• Quick to start
• Simple transforms
DataSync Client
• Synchronize on-‐premise data
• Databases and Files
• Built in scheduler
• Simple transformaNons
ETL Tool Support
• Direct Load to Cloud Database
• Databases and Files
• SophisNcated Transforms
• REST APIs for automaNon
• Data IntegraNon Cloud Services*
BICS Makes
Any Time
The Right Time For New Insights
Mobile
• Mobile-‐friendly consumpNon of all BI arNfacts from single naNve app
• InnovaNve ways to conduct exploratory analyNcs on-‐to-‐go
Cloud
• Timeliness, Economy and Flexibility
• Rapid Product InnovaNon
• Enterprise Grade Reliability
Access Any BI ArNfact Through NaNve Mobile Apps
•
TODO
• Mobile-‐friendly rendering of exisNng Catalog arNfacts
• One-‐stop shop to access BI
reports and dashboards, as well as Visual Analyzer projects
Exploratory AnalyNcs on a Tablet
•
TODO
• AdapNve design of Visual Analyzer for tablet form factor
• Touch-‐friendly funcNonality for authoring new analyNcs on-‐the-‐go
• Based on HTML5 – works on any tablet device
BICS Services Offerings
22
Express
(3 weeks) (5 weeks) Standard (9+ Weeks) Extended
Dashboards 1 3 3+
Reports 5 10 10+
Data Source Customer-‐
provided Flat Files
Automated Extract and
Upload
Custom Warehouse
Source Files 3 5 5+
Data Sources 1 1 Many
Data Warehouse ü
Self-‐Enablement Training
ü ü ü
Pricing $22K $33K Varies
EBS Insight Accelerators for BICS
SoluNon Includes:
–
EBS Views
–
Metadata
–
Sample Reports
BICS Dashboards,
Reports and Adhoc Repor>ng
Insight Accelerator Views
Database Cloud Service
Rapid Solu+ons:
Insight Accelerators for BICS
Sales Order General Ledger Accounts Payable Accounts Receivable Projects
Dashboard
Pages 4 8 8 8 4
Reports 4 25+ 25+ 25+ 10+
Data Elements AddiNonal Reports
75+ 100+ 100+ 100+ 100+