Oracle Analytics Cloud TechDay 2017 - ITOUG PDF Free Download

2y ago

49 Views

1 Downloads

6.64 MB

64 Pages

Report/dmca

Download PDF

Transcription

Oracle Analytics CloudTechDay 2017BI & Analytics StreamThe most comprehensive analytics in the CloudRoberto FalcinelliSenior Manager - Big Data & Analytics Domain LeaderOracle Technology Sales ConsultingMilano 8 Giugno 2017

Smart Analytics for EveryoneANALYSTSBUSINESS LEADERSDEVELOPERS Faster time to insights Easy, timely, proactivebusiness insights Develop and deploy analyticapplications for people tocustomize and personalize Share, collaborate andmaximize community‘swisdom Empower to go beyondconsuming others’ findings Embed analytics in anyapplication contextCopyrightCopyright .affiliates.AllAllrightsrightsreserved.reserved. 2

Oracle Analytics CloudBusiness AnalyticsData VisualizationEssbaseA proven platform for creating powerfulbusiness intelligence applications, enablingusers from the workgroup to the enterpriseGet instant clarity with stunningly visualanalysis and self-service discovery. Fast,fluid insights for the entire organizationFlexible platform for the creation ofdepartmental or enterprise-wide customanalytic applications and managementreportingCopyrightCopyright .affiliates.AllAllrightsrightsreserved.reserved. Oracle OpenWorld5

Oracle Analytics Cloud (OAC) “All-in-One” SubscriptionComplete FunctionalityCustomer ManagedEasily ScalableCustomizableFully AccessibleStandard EditionEnterprise EditionData Visualization Essbase (Standard Edition)Data Visualization Modeling & Enterprise Reporting Essbase (Enterprise Edition)Includes Mobile, Client tools & DesktopCopyright 2017, Oracle and/or its affiliates. All rights reserved.

The Oracle Analytics Cloudpowers your story with data.COMPLETE All capabilities All roles Any scaleYour StoryCONNECTED Right Data Right TimeCOLLABORATIVE Modern wayto work acrossteamsCopyright 2017, Oracle and/or its affiliates. All rights reserved.(data)CHOICE Flexibility ofdeployment Balancebetweengovernanceand freedom7

Any Scale, From Personal to EnterpriseCOMPLETE Self-service data discovery togetherwith enterprise-class reporting andanalytics Users don’t need help to go fromspreadsheets to what-if scenariosand modeling Create operational analytics fromcentrally managed metricsCopyright 2017, Oracle and/or its affiliates. All rights reserved.8

Enhance All Data with Powerful Data PreparationCOMPLETEAccessible to non-technical Business Users Traceable business transformation Group values, join data sets, sub-select rows/columns,aggregate, calculated fields etc. Back-end SQL processing - function shipping via smartcode generation, compensate with in-memoryexecutionFunction extensibility via R and Python Full R and Python grammar for statistical, MachineLearning, textual models Reach-in to data sources’ specific routines (e.g. MachineLearning in Spark, custom functions) while operating on asingle data abstractionCopyright 2017, Oracle and/or its affiliates. All rights reserved.9

Extensible, Grammar-Driven Visualization PaletteCOMPLETEExtensive Data Visualization Capabilities Rich palette of chart types with 35 built-in chart types, 20 downloadable add one, 100’s of 3rd party options with D3and Google Charts Trellising for every visualization Customizable global color palette Brushing – highlight correlations within data acrossvisualizations, all auto-wired to work/update in unison,leveraging in-memory cache/execution layer One click access to common statistical functions – outliers,trend lines, forecasts for N periods, others Define every chart as a filter for interactive explorationCopyright 2017, Oracle and/or its affiliates. All rights reserved.10

Ask Your Data QuestionsCOMPLETEPowerful, intuitive keyword search with BI Ask Voice-enabled Interprets semantic layer, user private data, expressionlibrary and catalog artifacts Fuzzy match, stemming, natural language processing Generates on-the-fly queries - visualizations areauto-created while user typesNLP Across the platform Enhance current keyword/token based enterprise voiceenabled search with the following natural languageprocessing tasks Sentence segmentation Deep analytics Named entity extraction Co-reference resolutionCopyright 2017, Oracle and/or its affiliates. All rights reserved.11

The Right Data From Any SourceCONNECTEDEasy access to a variety of data sources 40 different data sourcesSAAS / PAAS Few clicks to setup and use Will expand coverage to enable access toevery industry-specific source via nativeconnectors or developer communityDATABASESNew Data Sources 80 data source by the end of the year Essbase, PBCS, Big Data CS, Oracle Service,Dropbox, Google Analytics, Google DriveBIG DATANO SQL Oracle Talent Management Cloud (Taleo),Oracle Doc Service, Oracle Marketing Cloud(Eloqua), Odata, SharepointOTHERSCopyright 2017, Oracle and/or its affiliates. All rights reserved.13

Role-Based Visualization Content PacksPre-built data visualization content Included with Oracle Data Visualization Platform Extends OTBI insights with pre-built data visualization samplecontent Targets specific line-of-business personas Identifies difficult-to-spot business opportunities,innovations and patterns Blends data across business functions, lines of business andapplications Quick ad-hoc exploration of OTBI and other data withintuitive business user interface Near real-time access to data from OTBI and other Oracleapplication sourcesFinance Manager RevenueOverview Revenue andHeadcountAnalysis Cost ManagementCONNECTEDPayablesManager AP Balances AP Holds AP OverduesProject ManagerGrants Manager Campaignperformance Campaigncost Budget vs. Actual Award CostDetails AwardEncumbranceDetailsSales VPSales Manager Teamperformance Quota attainment Pipeline review DemandgenerationTop deals in PlaySales reviewPipeline trendRevenue trendMarketingAnalyst Campaignperformance CampaigncostCopyright 2017, Oracle and/or its affiliates. All rights reserved.Service Manager Open incidents Closed incidents Teamperformance

Smart Connectors to Role-Based Business ContentCONNECTEDNo re-work required for Oracle SaaS Applications Access to business entities, not just tables and columns Respects security, business rules, and governance onsource systems Browse and select thousands of packaged views as datasources Leverage calculations and business logic in reportsCopyright 2017, Oracle and/or its affiliates. All rights reserved.15

Easily Extensible and EmbeddableVisualization SDK (JAVA) Develop custom visualizations 100% functional, LCM parity with native visualizationsCOLLABORATIVEOracle Analytics is embedded in millions of users’day-day experiences Oracle HR SaaS: Oracle Talent Cloud, Oracle CX SaaS:Oracle ERP SaaS and Oracle SCM CloudFunction extensibility (R, Python) Extend the expression library with custom functions(e.g., stats, machine learning or textual functions)Data source extensibility (JAVA) Add data connectors to non-native sourcesSeamless UI embedding (Java Script) Context propagation, skinning flexibility, seamless bidirectional navigation, well-defined REST endpointsREST APIs Use the Oracle Analytics Cloud as an Analytics platformCopyright 2017, Oracle and/or its affiliates. All rights reserved.16

Analytics That Are Modern, Mobile, SocialCOLLABORATIVE Proactive analytics deliver selflearning insights andrecommendations to you and yourcrew Interactive stories illustrate insights,increasing collective understandingand expertise Search and voice-driven analysispower a modern mobile experienceCopyright 2017, Oracle and/or its affiliates. All rights reserved.17

Build Collective Intelligence, Consumer StyleCOLLABORATIVEDay-By Day: Anticipates needs through self-learning Infuse data-based insights into daily activities Use your device’s voice capabilities to obtain answers Anticipate what users need and deliver appropriateinformation to help them make better informed decisionsthroughout the daySynopsis: Process any Excel/CSV file on mobile devices Data on the device is automatically turned into visualrepresentations that the user can modify 100% on device analytics – no connection required Native device interactions with the ability to handle largedata sets in visualizationsCopyright 2017, Oracle and/or its affiliates. All rights reserved.18

Business Freedom and Data Governance Balance user autonomyand governance Combine all relevantinformationfrom any data source,managedand self-service Stay productive withintelligently optimized OMBINATIONENTERPRISEPERSONALMODELEDNOT MODELEDProductTimeRevenueSalesInventoryMY SUBJECT AREAOracleAnalyticsCloudTerritoryCopyright 2017, Oracle and/or its affiliates. All rights reserved.TerritoryQuarterProductTarget 21

Elastic Resources for Busy PeriodsCHOICECustomer managed resources Take control of resources requirements without theneed of Oracle interference Increase analytics resources to handle busy periodsbusy period Reduce analytics resources during quiet times for costsavings Never again have slow analytics response times duringyour business critical periodsquiet periodCopyright 2017, Oracle and/or its affiliates. All rights reserved.22

Oracle Cloud MachineComplete deployment choiceOracleDatacentersCHOICE Oracle Cloud operatedand delivered as aservice behind yourfirewallSame StandardsSame ServicesUnified Management Same PaaS and IaaSsoftware, same updatesas Oracle CloudCustomer’sDatacenterPaaSJava EEMobileBig DataDatabaseAnalyticsData Integr.IoTIaaSNetworkStorageComputeCopyright 2017, Oracle and/or its affiliates. All rights reserved. Same cost-effectivesubscription pricingmodel as Oracle Cloud Conforms to regulatory,privacy, legal, andbusiness requirements23

Essbase in the CloudIterative Scenario Analysis Modernized architecture for cloud Personal to enterprise business modeling Sandbox for scenario analysis/what-if Next generation Excel integration includes cube design,dimension modeling and KPI’s Wide-range of business modeling and managementreporting applications Integration with Data Visualization Cloud ServiceEnterprise vs StandardEnterprise Capabilities IncludeSandboxingPartitions to sources outside of the computeDrill Thru Capabilities (not in v1)Additional differentiators will be introduced in upcomingreleasesCopyright 2017, Oracle and/or its affiliates. All rights reserved.25

Analytics Cloud: Built on Oracle ComputeKey FeaturesREST APIResource ManagementLifecycle ManagementSecure AccessVirtual Networking Resource Management: Run any application at scale withconsistency Lifecycle Management: Provision and manage serviceenvironments through a UI or Script via REST API Secure Access: Security Groups and Access Control tosecure network access, SSH access to the VM Virtual Network: Range of networking options to enableprivate and faster connectionsBenefits Predictable Performance Speed Innovation & Agility Co-Existence & Seamless MigrationCopyright 2017, Oracle and/or its affiliates. All rights reserved.26

How is Analytics Cloud different from existing servicesBICS & DVCS todayAnalytics CloudAutomatic backupOracleCustomerService monitoringOracleCustomerPatching/upgradeOracle schedules and performspatchingCustomer patches at will using a single click or acommandCPU & MemoryOracle decides resources toallocate based on usageCustomer can decide CPUs and Memory and pay forwhat they allocateServer access andconfig.Customer cannot access server orchange config not exposed in UICustomer can SSH into the server to change config (maycomplicate patching/upgrade)Network and securityconfig.Limited config supportedFull control on network access including VPNconfigurationDatabase dependence BICS requires purchase of Schemaservice BIS50Customer needs to provide at least 1 OCPU DBaaSStandard instance ( 300/month)IaaS dependenceRequires customers to purchase some IaaS for networkand storage - 30/TB/month, 0.02/GB/monthNo IaaS requiredCopyright 2017, Oracle and/or its affiliates. All rights reserved.

OAC Supported Compute ShapesOAC Supported Compute Shapes:ShapeOCPU / MemoryOC31 / 7.5OC42 / 15OC54 / 30OC68 / 60OC716 /120OC1M1 / 15OC2M2 / 30OC3M4 / 60OC4M8 /120OC5M16 /240An OCPU provides CPU capacity equivalent of one physical core ofan Intel Xeon processor with hyper threading enabled. Each OCPUcorresponds to two hardware execution threads, known as vCPUs.OAC Service DependenciesOracle DB Cloud Service System Schema (RCU)Oracle Compute Block Storage Binaries, Logs, etcOracle Storage Cloud (Object Storage) Backups, DV DatasetsCopyright 2017, Oracle and/or its affiliates. All rights reserved.28

Data ModelingOBIEE Admin ToolLift and Shift from On-PremAccess non-DBaaS SourcesAdvanced Model DevelopmentOn-line Access SupportedCloud Data ModelerLightweight Modeling onDBaaS Sources for Power-UsersCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Data Integration and AccessETLSQL*NETData SyncOn-premise data sourcesWeb servicesDirect QueryDV ConnectionsVia RDC orVirtual NetworkingCloud to CloudVirtual Network for On-PremCopyright Oracle2016 Oracleand/orits affiliates.All rightsreserved. Copyright 2017,and/orits affiliates.All rightsreserved.

OAC Data Integration – Hybrid DeploymentRDCDirect query accessVPNOracle SaaSServiceCloudOtherSaaSDirect importData setDirect ImportOACDirectQueryData setData setDirect ImportData setREST APIOracle FusionApps (OTBI)RDC: Oracle, DB2,SQL le CloudFilesDirect UploadOn-Premises NetworkCopyright 2017, Oracle and/or its affiliates. All rights reserved.Data Sync: JDBC,Greenplum,MongoDB,Redshift, Hive,Postgre SQL,SFDC, OracleService Cloud,OTBI. .

Oracle Analytics Cloud – Customer Managed Provisioning– Customers are responsible for provisioning services– Allocates OCPUs in a subscription to individual services Service Management– Setup and manage backups– Apply patches and upgrades– Setup access rules to the service– SSH access to the file system Provisioning and service management available through My Services GUIand REST APICopyright 2017, Oracle and/or its affiliates. All rights reserved.32

Oracle Analytics Cloud vs OBIEE (as of today) No BI Publisher– Expected in Q1 FY 18 Delivers Lite only– Full Delivers in Q1 FY 18 Action Framework– JavaScript Actions, Web ServiceActions, EJB Actions will not besupported No Scorecards– Not expected Security– WLS LDAP in v1, IDCS in v1.5– Non-standard providers not supported– Act-as not supported Answers Custom Map Layers notsupported Marketing Segmentation notsupported VM customizations may not bepreserved or prevent lifecyclemanagementCopyright 2017, Oracle and/or its affiliates. All rights reserved.36