oracle bi hybrid bi : mode 1 + mode 2, cloud + on-premise business analytics
TRANSCRIPT
[email protected] www.rittmanmead.com @rittmanmead
Oracle BI “Hybrid Deployments”, or… What’s all this about the Gartner BIAMQ 2016?Mark Rittman, CTO, Rittman Mead March 2016
[email protected] www.rittmanmead.com @rittmanmead 2
•Mark Rittman, Co-Founder of Rittman Mead‣Oracle ACE Director, specialising in Oracle BI&DW‣14 Years Experience with Oracle Technology‣Regular columnist for Oracle Magazine
•Author of two Oracle Press Oracle BI books‣Oracle Business Intelligence Developers Guide‣Oracle Exalytics Revealed‣Writer for Rittman Mead Blog : http://www.rittmanmead.com/blog
•Email : [email protected]•Twitter : @markrittman
About the Speaker
Step back in time
2010
2016
[email protected] www.rittmanmead.com @rittmanmead 15
Analytic Workflow Component Traditional BI Platform Modern BI Platform
Data source Upfront dimensional modeling required (IT-built star schemas)
Upfront modeling not required (flat files/flat tables)
Data ingestion and preparation IT-produced IT-enabled
Content authoring Primarily IT staff, but also some power users Business users
Analysis Predefined, ad hoc reporting, based on predefined model Free-form exploration
Insight delivery Distribution and notifications via scheduled reports or portal
Sharing and collaboration, storytelling, open APIs
Gartner’s View of A “Modern BI Platform” in 2016
2007 - 2015
Died of ingratitude by business usersJust when we got the infrastructure right
Doesn’t anyone appreciate a single version of the truth?Don’t say we didn’t warn you
No you can’t just export it to ExcelWatch out Essbase you’re next
not quite
and what’s Oracle been up to recently..?
[email protected] www.rittmanmead.com @rittmanmead
20
Oracle Business Analytics Key Focus Areas Today
PervasiveAnalytics
Analyticsforeveryone,Completedeployment
flexibilityandportability
ConsumerizeAnalytics
Socializefindings,Collaborate,Mobile
VisualAnalytics
Richandeasytouse,Selfservice,Data
access
[email protected] www.rittmanmead.com @rittmanmead 21
OBIEE12c : The Hybrid, BIModal BI Platform
[email protected] www.rittmanmead.com @rittmanmead 22
Analytic Workflow Component Traditional BI Platform Modern BI Platform
Data source Upfront dimensional modeling required (IT-built star schemas)
Upfront modeling not required (flat files/flat tables)
Data ingestion and preparation IT-produced IT-enabled
Content authoring Primarily IT staff, but also some power users Business users
Analysis Predefined, ad hoc reporting, based on predefined model Free-form exploration
Insight delivery Distribution and notifications via scheduled reports or portal
Sharing and collaboration, storytelling, open APIs
Gartner’s View of A “Modern BI Platform” in 2016
[email protected] www.rittmanmead.com @rittmanmead 23
Analytic Workflow Component Modern BI Platform
Data source Upfront modeling not required (flat files/flat tables)
Data ingestion and preparation IT-enabled
Content authoring Business users
Analysis Free-form exploration
Insight delivery Sharing and collaboration, storytelling, open APIs
Gartner’s View of A “Modern BI Platform” in 2016
[email protected] www.rittmanmead.com @rittmanmead 24
IT as an Enabler for the Modern BI Platform
[email protected] www.rittmanmead.com @rittmanmead 24
IT as an Enabler for the Modern BI Platform
MakeitpossibletoacquireandunderstandnewdatasourceswithnoITinvolvementProvideameanstodiscoverschemasHelpwithobfuscationandsecuritySupportwiderrangeofdatatypes
[email protected] www.rittmanmead.com @rittmanmead 25
IT as an Enabler for the Modern BI Platform
[email protected] www.rittmanmead.com @rittmanmead 26
•Extend dimensions within an existing Subject Area•Add facts to an existing Subject Area•Standalone analysis outside of Subject Areas•Future plans to allow mashup metadata to be promoted into main RPD model‣In meantime, can be achieved throughprocess and accelerators
Self-Service Data Mashups for Business Agility
[email protected] www.rittmanmead.com @rittmanmead 27
•Data reservoirs and Big Data Discovery, for landing and analysing data in “Raw” form•Oracle Big Data Preparation Cloud Service, for discovering schema + preparing for analysis
Platforms for User-Driven Analysis of Raw Data
DataTransfer DataAccess
DataFactory DataReservoir
BusinessIntelligenceTools
HadoopPlatform
FileBasedIntegration
StreamBased
Integration
Datastreams
Discovery&DevelopmentLabsSafe&secureDiscoveryandDevelopment
environment
Datasetsandsamples
Models andprograms
Marketing/SalesApplications
Models
MachineLearning
Segments
OperationalData
Transactions
CustomerMasterata
UnstructuredData
Voice+ChatTranscripts
ETLBasedIntegration
RawCustomerData
Datastoredintheoriginal
format(usuallyfiles)suchasSS7,ASN.1,JSONetc.
MappedCustomerData
Datasetsproducedbymappingandtransformingrawdata
[email protected] www.rittmanmead.com @rittmanmead 27
•Data reservoirs and Big Data Discovery, for landing and analysing data in “Raw” form•Oracle Big Data Preparation Cloud Service, for discovering schema + preparing for analysis
Platforms for User-Driven Analysis of Raw Data
DataTransfer DataAccess
DataFactory DataReservoir
BusinessIntelligenceTools
HadoopPlatform
FileBasedIntegration
StreamBased
Integration
Datastreams
Discovery&DevelopmentLabsSafe&secureDiscoveryandDevelopment
environment
Datasetsandsamples
Models andprograms
Marketing/SalesApplications
Models
MachineLearning
Segments
OperationalData
Transactions
CustomerMasterata
UnstructuredData
Voice+ChatTranscripts
ETLBasedIntegration
RawCustomerData
Datastoredintheoriginal
format(usuallyfiles)suchasSS7,ASN.1,JSONetc.
MappedCustomerData
Datasetsproducedbymappingandtransformingrawdata
[email protected] www.rittmanmead.com @rittmanmead 28
•Uses Spark MLlib machine learning to profile data and recognise patterns
•Automates many of the routine data preparation and profiling work‣Spot credit card, SSN + other sensitive data, recommends masking‣Suggest appropriate names, datatypes for columns based on format and data patterns
•Allows analyst to focus on key tasks‣Example of cloud app consumerization
Machine-Learning to Automate Data Recommendations
[email protected] www.rittmanmead.com @rittmanmead 29
•Primary datasource and target is Oracle Storage Cloud Service (like Amazon S3)‣Oracle Big Data Cloud Service, Oracle DBaaS and others
•User can also upload / download files directly into Big Data Prep Service
Cloud Datasource Integration & File Upload/Download
[email protected] www.rittmanmead.com @rittmanmead 30
Future Option : Direct BDP > BICS Integration
[email protected] www.rittmanmead.com @rittmanmead 31
IT as an Enabler for the Modern BI Platform
Makeprovisioningmoreagilebyembracing“cloud”and“hybrid”environmentsEmbracecloudinnovationsaroundserviceprovision,evenforon-premisedeployments
[email protected] www.rittmanmead.com @rittmanmead 32
•Oracle Business Intelligence, re-imagined for the cloud•Runs as part of Oracle Public Cloud, part of wider Oracle Platform-as-a-Service•Pay monthly, min 10 users, rolling upgrades and new features•Entirely thin-client, simplified administration•Aimed at departmental use-cases‣Sharing data from a spreadsheet‣Team reporting‣Development sandboxes‣User-driven thin-client modeling, eventualBAR file interchange with on-premise
Oracle BI Cloud Service - Agile Analytics in the Cloud
[email protected] www.rittmanmead.com @rittmanmead 33
•Thin-client data modeller continuously enhanced and extended•Model against files, cloud and on-premise databases•Upload on-premise RPD + Catalog tocreate sandbox environments
•Support for variables, dimensions,hierarchies, facts and main RPD elements
•Minimal modeling to support deparmentaluse-cases and analysis
Thin-Client Data Modeller for Simple RPD Modelling
[email protected] www.rittmanmead.com @rittmanmead 34
•Leverages BICS’s new “Upload RPD Data Models to the Cloud” feature‣Migrate supporting DW to full Oracle DBaaS‣Update on-prem RPD to connect to DBaaS‣Upload RPD to BICS
•Create new Oracle Cloud users for BICS•ETL can connect via SQL*Net, JDBC etc•Use for wider use-cases than BICS incl.‣Host full production platform (or test, dev)‣Create development branches, etc‣Hybrid environments
Hosting Full OBIEE Platforms in Oracle Public Cloud
Oracle BICS Oracle DBaaS
RPD Upload
ETL ToolsBI Administration On-Premise Source DB
Data Uploadsvia SQL*Net
[email protected] www.rittmanmead.com @rittmanmead 35
The Oracle Hybrid Analytics Journey
BusinessLeader Workgroup Enterprise
DataVisualizationOn-Premise
OBI12c+DataVisualization
On-Premise
OBI12c+DataVisualization+DataWarehouse
On-Premise
BusinessLeader Workgroup Enterprise
DataVisualizationCloudService
BusinessIntelligence CloudService(includesDV)
BusinessIntelligence CloudService+
DatabaseCloudService
[email protected] www.rittmanmead.com @rittmanmead 36
IT as an Enabler for the Modern BI Platform
User-drivendatadiscoveryFree-formanalysisConnecttoSaaSdatasourcesStandalonedatasets,orsemanticmodel
[email protected] www.rittmanmead.com @rittmanmead 37
•Tableau-style data analysis tool aimed at data analysts and self-service users
•Point-and-click exploration and visualisation of datasets
•Uses BI Repository as data source, ensuring “single-version-of-the-truth”
•Users can also add their own data, “for data mashups”
•Coming in next 12 mths with OBIEE12c, but available now in BICS
Oracle Visual Analyzer
[email protected] www.rittmanmead.com @rittmanmead 38
•Just the DV part of BICS•Upload files, connect to SaaS sources
•Simple, mobile-enabled data visualisation
•Most probably aimed at ISVs and SaaS apps
•On-premise DV releases coming soon
Oracle Data Visualization Cloud Service
[email protected] www.rittmanmead.com @rittmanmead 39
•Just the DV part of BICS•Upload files, connect to SaaS sources
•Simple, mobile-enabled data visualisation
•Most probably aimed at ISVs and SaaS apps
•On-premise DV releases coming soon
Oracle Data Visualization Cloud Service
The Future is BiModal
The Future is Hybrid
http://www.rittmanmead.com
[email protected] www.rittmanmead.com @rittmanmead
Oracle BI “Hybrid Deployments”, or… What’s all this about the Gartner BIAMQ 2016?Mark Rittman, CTO, Rittman Mead March 2016