1 / 52

Turning Data into Business Value with Oracle Cloud Analytics

Learn how to leverage data analytics on Oracle Cloud to gain insights, identify trends, and make informed business decisions. Understand the value of data in offering a consolidated view, interpreting patterns, and providing actionable recommendations.

kirar
Download Presentation

Turning Data into Business Value with Oracle Cloud Analytics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Turn Data into Business Value – Starting with Data Analytics on Oracle Cloud Lucas Jellema, CTO & Architect at AMIS Oracle Code, Roma, April 2019 Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  2. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  3. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  4. Overview of Oracle OpenWorldandCodeOne conferences Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  5. Heatmapwith busy timesduringthe conferences Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  6. Timeline with conference sessions – filteredbythree types of session types Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  7. Exploringpopular first names Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  8. Overview of speakers employedby Oracle (or not) Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  9. Correlationbetweenvarioussessionattributes Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  10. Do Oracle speakers do worse at making slides available? Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  11. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  12. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  13. Value of data • Insight in state of affairs • Identifying trends • Knowledge of deviationsandexceptions • Understanding of patterns, correlations, causes Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  14. Value of data • Insight in state of affairs • Identifying trends • Knowledge of deviationsandexceptions • Visibility of patterns, correlations, causes • Consolidatedfrom multiple, heterogeneous sources • Cleansed, validated, filtered, standardized, enriched • Interpretedandaggregatedto a meaningful level • Presented in aninterpretable form • Publishedandaccessible at the right time via theoptimalchannel • Resulting in understanding, decisions, actions, predictionsandrecommendations • And a richer user experience – more efficient, effectiveandfun user interfaces Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  15. Ifyoucannotmeasurewhat is important, you make whatyoucanmeasureimportant Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  16. What is new? BI & OLAP Tools Enterprise Database (Oracle RDBMS) Data Warehouse (Oracle RDBMS) ELT ETL Reporting engine Data Mining Materialized Views Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  17. What is new! • Types of Data and Data Sources • Volume of Data – Big! • Velocity of Data (and real time nature of requirements) – Fast! • (web) Scaleand Speed of business • Open Data • Cloud • Machine Learning: has becomefeasibleandaccessible • Available • Affordable (software & hardware) • Doable (Citizen Data Scientist) • Fastenough • Expectations: Business Cases & Opportunities => Demands • End users, Consumers, Competitivepressure, Society (& Gartner) Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  18. Data Flow – fromraw data to business insight & action Machine Learning Deploy & Leverage Machine Learning Model Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake Business Intelligence Dashboard, Notification & Alert Report, Visualization, Gamification, Data Explorer 3rd party data sources Business insight: what, when, whoandwhy algorithms Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  19. Data Flow – fromraw data to business insight & action One time only Periodic, in batch Continuous, event triggered Machine Learning Deploy & Leverage Machine Learning Model Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake Business Intelligence Dashboard, Notification & Alert Report, Visualization, Gamification, Data Explorer 3rd party data sources Business insight: what, when, whoandwhy algorithms Master Data Management, Meta-Data Management, Data Governance Data Access, Authorization, Privacy Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  20. Data Flow – fromraw data to business insight & action ETL/ELT, Change Data Capture, Event Bus/Message Queue, file/ftp handlers, adapters, ESB, Web Scraping, Streaming (event) Analytics … • Relationele Database • NoSQL Database (Document Store, Key/Value Store, GraphDB, Time Series, ..) • Hadoop • Event Store • Object Store, Block Store Data Warehouse Data Pipeline Raw/ Operational Data Sources Data Lake • Standard Business Applications & SaaS (SAP, Oracle EBS, Siebel, SalesForce, AFAS, Dynamics) • Customapplications • Fast Sources: IoT, Web Clicks, Social Media, Events • Unstructured: image/video, log-files, text/CMS, email • … Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  21. Data Flow – fromraw data to business insight & action Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake 3rd party data sources algorithms Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  22. Data Wrangling Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  23. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  24. Data Flow – fromraw data to business insight & action Discover,visualize, describe Extract, parse,interpret Cleanse & Validate Filter, Deduplicate, Denormalize Unify (units, language, spelling, coding) Convert & Transform Anonymize, Obfuscate/Redact Enrich Join, Aggregate Feature engineering Relational Database NoSQL Database Hadoop Object Store Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake OCR Speech toText Sentiment Analysis Gist / Topics extraction Image recognition Translation Spelling correction Anomalydetection Classification Principal Component Analysis 3rd party data sources algorithms Open Data APIs (governments, NGOs, companies) Social Media Kaggle, data.world DaaS-vendors Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  25. Data Flow – fromraw data to business insight & action Design Visualization, Report, Dashboard, Notification, Animation, self-service data discovery & exploration Multi-channel, pull/push, distribute Implement| Test | Roll Out | Operate Enforce Data Authorization Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake Business Intelligence Dashboard, Notification & Alert Report, Visualization, Gamification, Data Explorer 3rd party data sources Business insight: what, when, whoandwhy algorithms Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  26. Data Flow – fromraw data to business insight & action Machine Learning Deploy & Leverage Machine Learning Model Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake Business Intelligence Dashboard, Notification & Alert Report, Visualization, Gamification, Data Explorer 3rd party data sources Business insight: what, when, who and why algorithms Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  27. Levels of AI/Machine Learning • Generic, Out of the box, ready touse (AI Services) • OCR, Image & Video Recognition, Sentiment Analysis, Speech toText, Text Gist/Summary, Textto Speech • Guided training usingyourown data of a predefined ML model for specificuse cases • IoTPredictive Analytics, Forecast, Recommendation, ChatBot, Cloud Talent • Do it (largely) yourself ML • Train yourown model on yourown data set usingframeworks, librariesandrawtechnologies Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  28. Data Flow – fromraw data to business insight & action Select algorithm Configure model Train model with training data Test Model … iterate …. Accept/Select Model Machine Learning Deploy & Leverage Machine Learning Model Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake Business Intelligence Dashboard, Notification & Alert Report, Visualization, Gamification, Data Explorer 3rd party data sources Business insight: what, when, who and why algorithms Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  29. Leveraging Machine Learning models Application API ML Model Machine Learning Deploy & Leverage Machine Learning Model “Data Mart” single purpose data set Data Wrangling algorithms Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  30. Whatto do itwith? • Mathematics (Statistics) • Gauss (normaldistribution) • Bayes’ Theorem • EuclideanDistance • Perceptron • Mean Square Error Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  31. Python, R, Apache Spark, SQL & PL/SQL Jupyter Notebooks, Apache Zeppelin NumPy, SciPy, SciKit-learn, Pandas, Bokeh, Plotly, Matplotlib, NLTK, Keras, TensorFlow, PyTorch, MXNet, Caffe, Theano Oracle Analytics Cloud, Oracle Data Science Platform, Oracle Autonomous Datawarehouse Cloud AutoKeras AWS SageMaker, Google AI Platform, Google AutoML, Azure Machine Learning Studio AzureCognitive Services, AWS AI [examples of] Technologie in Data Flow Oracle Autonomous Datawarehouse Cloud, AWS RedShift, Google BigData, Azure SQL Data Warehouse, Azure Data Lake Store, Oracle Database AzureCosmos DB, Elastic Stack, MongoDB,InfluxDB, Cassandra, AWS DynamoDB, Excel Hadoop, Kafka, Oracle BigData Cloud AWS S3, Oracle Storage, OneDrive, Google Storage Machine Learning Deploy & Leverage Machine Learning Model Data Warehouse Data Pipeline Data Wrangling Raw/ Operational Data Sources “Data Mart” single purpose data set Data Lake Business Intelligence Dashboard, Notification & Alert Report, Visualization, Gamification, Data Explorer 3rd party data sources Business insight: what, when, whoandwhy Jupyter Notebooks, Python, Apache Spark, Java, R, Apache Zeppelin SQL & PL/SQL, SQL Developer SPARQL Oracle Analytics Cloud, Oracle Big Data SQL Google Cloud DataPrep, AzureWrangler (TrifactaWrangler) , Google BigQuery Excel, csvkit, Pentaho algorithms d3.js, React D3, SVG Oracle Analytics Cloud, Oracle Visual Builder, Excel, SQL Developer, Oracle APEX Pentaho, OpenStreetMap AzurePowerBI, AWS QuickSight Tableau, Qlik, Looker, SAP Analytics (Business Objects), IBM Cognos, SAS, TibcoJasperSoft Kibana, Grafana SQL, Java, Python, Node JS SQL Developer, Apache Spark, Drill, Flink Oracle Data Integration Platform Cloud, Oracle Integration Cloud & Cloud Adapters Kafka, Connectors, KSQL & Streams Debezium AzureEventHubs AWS Lambda, SQS, SNS, Glue, Kinesis, Step Functions Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  32. From Data toActionable Intelligence Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  33. Scale your Analytics! • Autonomous • Data Warehouse Cloud • Oracle • Analytics Cloud • Data Integration • Platform Cloud Big Data Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  34. But wait – there is more…Autonomous Data Warehouse [Cloud] Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  35. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  36. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  37. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  38. Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  39. Reference Architecture for Data Drivenorganizations Analytics Cloud OLTP IoT Social Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  40. Data Analytics on Oracle OpenWorld 2018 Session Details Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  41. High level overview • Details per session: Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  42. SessionCatalog – REST API – returning data in JSON format Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  43. Flow for Oracle OpenWorld 2018 Session Data Analytics Data Gathering Data Wrangling Business Intelligence Report & Visualization on Speakers API for session details in JSON Report & Visualization on Sessions Machine Learning AMIS Kick Off 2019 - Proposities & Data Analytics Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  44. Flow for Oracle OpenWorld 2018 Session Data Analytics Oracle Autonomous Datawarehouse Cloud,local file system Python & Jupyter Notebook Oracle Analytics Cloud Data Gathering Data Wrangling Business Intelligence Report & Visualization on Speakers Oracle Analytics Cloud API for session details in JSON Report & Visualization on Sessions Machine Learning AMIS Kick Off 2019 - Proposities & Data Analytics Oracle Analytics Cloud Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  45. Implementation details of Flow for Oracle OpenWorld 2018 Session Data Analytics Data Visualization for Desktop toprepare Data Sets Jupyter Python Notebook – retrieveraw JSON data fromAPIs Save Sessionsand Speakers data in CSV files Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  46. Dataflowscanbeusedto train andapply machine learningmodels Implementation details of Flow for Oracle OpenWorld 2018 Session Data Analytics Data Visualization – Dataflow for enrichingandjoining data sets Sessions are joinedwithVenuesfrom a cloudbasedMongoDB database Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  47. Implementation details of Flow for Oracle OpenWorld 2018 Session Data Analytics Preparevisualizationsfromtheenriched data sets Define Data Actions toaddinteractivitytotheVisualizations Chooseone of dozens of visualization types, configuredimensions, filters, colors, titles, … Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  48. Implementation details of Flow for Oracle OpenWorld 2018 Session Data Analytics PrepareNarrativeusingselectedCanvasescombinedwithannotations Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  49. Implementation details of Flow for Oracle OpenWorld 2018 Session Data Analytics Present and Share Narrative Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

  50. Oracle Data Visualization Desktop – The Cloud has Landed • Desktop tool • Optional: integrateswith Excel • On par functionalitywith Analytics Cloud • Single User • Limited physical resources • Free!? Turn Data into Business Value - Starting with Data Analytics on Oracle Cloud

More Related