oracle data visualizations
DESCRIPTION
Oracle Data Visualizations. Overview and New Features in ADF 12.1.3 and Mobile Application Framework 2.0. Katarina Obradovic-Sarkic Senior Product Manager Oracle Mobility and Application Development Tools. Program Agenda. 1. Data Visualizations Overview and Usage within Oracle - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/1.jpg)
![Page 2: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/2.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential
Oracle Data VisualizationsOverview and New Features in ADF 12.1.3 and Mobile Application Framework 2.0
Katarina Obradovic-SarkicSenior Product ManagerOracle Mobility and Application Development Tools
![Page 3: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/3.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Safe Harbor StatementThe following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Oracle Confidential
![Page 4: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/4.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 4
Program Agenda
Data Visualizations Overview and Usage within Oracle
Primary Use Cases for Data Visualizations
Dinner Break
New Features in JDeveloper and ADF 12.1.3
Data Visualizations in Mobile Application Framework 2.0
Collateral and Q & A
Hands-On Session
1
2
3
4
5
6
7
![Page 5: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/5.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Data Visualizations Overview
• Deliver responsive interactivity and animation across a broad set of HTML5 components:– 30+ Chart types– Gauges: Dial, LED, Rating, and Status
Meter– Gantt Charts: Project, Resource
Utilization, and Scheduling–Maps: Geographic and Thematic– Hierarchy Viewer, Pivot Table– Treemap, Sunburst, and Timeline– New Visualizations: Diagram, NBox
![Page 6: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/6.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Mobile first design/touch support• Rich Set of Visual and Interactivity
Features• Responsive Layout and Animation• Consistency: Shared Set of
Visualizations across Oracle ADF and Mobile Application Framework• Internationalization Support• Accessibility Support
Themes
![Page 7: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/7.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Fusion Applications
![Page 8: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/8.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Fusion Applications
![Page 9: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/9.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Fusion Applications
![Page 10: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/10.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Fusion Applications
![Page 11: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/11.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Enterprise Manager
![Page 12: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/12.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Fusion Financials
![Page 13: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/13.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Retail
![Page 14: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/14.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
•Democratize Data Querying and Rule Building• Highly visual, do-it-yourself report/rule building• Role-based and context-sensitive interactions and
presentation• Actionable, Social
•Leverage the power of Oracle ADF and DVT• Diagrammer• DVT graphs and charts• AF Switcher
Visual Information Builder
![Page 15: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/15.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Visual Information Navigator• Radical Rethink of the Interaction with
Enterprise Application • Intuitive: Explore and manipulate
information naturally on any device
• Comprehensive: Combine data and relationships from multiple systems and disciplines
• Context sensitive: Tie user interaction with complex information to a specific context
• Leverage the power of ADF Diagrammer
Product Lifecycle Management: Product Traceability
Manufacturing: Work Definition Management
![Page 16: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/16.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Data Visualizations – Not Just for Data Analysis
• Presentations - Reporting data via dashboards, charts, static or interactive, data at rest or active• Exploratory Data Analysis with Big Data -
Profiling and discovering patterns• Story - Use multiple visualizations
together or present a replay of data over time to tell a story
![Page 17: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/17.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Data Visualizations – Not Just for Data Analysis
• Planning - Driving a model via Gantt or Pivot Table • Descriptive - Representing a process or
tangible item such as a seating chart diagram • Data Entry - Entering small amounts of
data like ratings
![Page 18: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/18.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential
After the Break: Data Visualizations - New Features in JDeveloper 12.1.3 and Mobile Application Framework
![Page 19: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/19.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• New Chart and Gauge components in ADF 12.1.3• Already used by ADF
Mobile• Now exposed in ADF and
new Mobile Application Framework
Benefits of the New Charting Solution
![Page 20: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/20.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Over 30+ chart types• Redesigned zoom and scroll• Marquee zoom and selection• Redesigned Time axis• Hide and show series and ability to
change layout with client side rescale• Improved data labeling• New Gauges: LED, status meter,
circular status meter, dial, and the new rating gauge
Benefits of the New Charting Solution
![Page 21: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/21.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Going forward, all the new features are introduced in DVT Charts• Old Graph and Gauge tags deprecated in cases where the new
tags are available• Funnel, Radar and Stock Graph are still supported and will be
replaced in a future release• Editing existing data-bound instances of deprecated tags is still
supported• Data-first or UI-first creation of deprecated tags is not supported
Graph and Chart: Migration Strategy
![Page 22: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/22.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Old Tag (Deprecated) New Tag
dvt:areaGraph dvt:areaChart
dvt:barGraph dvt:barChart
dvt:bubbleGraph dvt:bubbleChart
dvt:comboGraph dvt:comboChart
dvt:gauge dvt:dialGaugedvt:ledGaugedvt:statusMeterGaugedvt:ratingGauge
dvt:horizontalBarGraph dvt:horizontalBarChart
dvt:lineGraph dvt:lineChart
dvt:pieGraph dvt:pieChart
dvt:scatterGraph dvt:scatterChart
Graph and Chart: Migration Strategy
![Page 23: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/23.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Area layer styling and marker zoom behavior• Marker rotation • Ability to display isolated areas• Support for custom base maps
Thematic Map New Features
![Page 24: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/24.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Visualize different sets of data by displaying nodes and their relationships• Design time available in a future
release• Provides a pluggable framework for
the application developers to define custom layouts in javascript• Tutorial articles available in DVT Blog• Diagram Layout Tutorial video on OTN
New Component: Diagram
![Page 25: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/25.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Charts• Gauges• Geographic Map• Thematic Map• Treemap• Sunburst• Timeline• NBox
Data Visualizations in Mobile Application Framework
![Page 26: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/26.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Display hierarchy using color and size of the nodes to convey information• Only one level of hierarchy displayed in Mobile Application
Framework
Treemap in Mobile Application Framework
![Page 27: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/27.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Display metrics in a radial layout• Only one level of hierarchy displayed in Mobile Application Framework• Selection, rotation
Sunburst in Mobile Application Framework
![Page 28: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/28.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Visualizes events on an interactive timeline• Concepts shared with ADF Timeline• New feature: Duration bars• No overview window
Timeline in Mobile Application Framework
![Page 29: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/29.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Currently exposed only in Mobile Application Framework• Visualizes and compares employee performance vs. potential• Supports various options for color coding, marker shapes, and
grouping
New Visualization: NBox
![Page 30: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/30.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• DVT new features listed in the new features document• Recorded videos (ADF):– DVT New Features Overview– Diagram Layout Tutorial– Chart Formatting
• The Oracle Mobile Platform YouTube channel: http://bit.ly/oramobilesub• New DVT Blog–Overview articles– Diagram articles by Duncan Mills
• Hosted demos, available for download
Data Visualizations Collateral on OTN
![Page 31: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/31.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• How are DVT components important to your consulting business? Which ones have you used in delivered projects or demos?• How effectively are the DVT components positioned in the
development tools space? • How competitive are they, compared to what else is out there?
What are the most significant gaps, if any? What other charting components have you used recently or considered using?• How do you find the development experience using DVT?
Questions for You
![Page 32: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/32.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
• Have you seen/used the new Chart tags? Are you happy with the look of the resulting charts, the performance of the components, the interactivity?• What product changes or additions would encourage more usage
of DVT components?• What opportunities are there for additional DVT collateral (doc,
demos, tutorials)?
Questions for You
![Page 33: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/33.jpg)
![Page 34: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/34.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Pivot TableMultiple layers on row and column edges
• Drag and drop pivoting
• Horizontal and vertical virtualized scrolling
• Cell, row and column selection
• Header and cell formatting, e.g. heatmap
• Automatic totals/subtotals
• Drilling, Filtering, header/cell sorting
• Cell editing
• Stamping
• Split Panes
• Paging support
![Page 35: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/35.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Hierarchy ViewerView complex hierarchical data
• Panel cards for changing node content
• Multiple layouts
• Search
• Expand/collapse nodes
• Drag and drop
![Page 36: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/36.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Gantt ChartsTrack tasks and resources over time
• Project Gantt
• Scheduling Gantt
• Resource Utilization Gantt
• Features Include:– Interactively move/resize task bars– Split tasks/recurring tasks– Export to Excel– Customizable toolbar, menubar , context menu– Paging support
![Page 37: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/37.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Geographic MapFunctionality of Oracle Spatial within ADF
• View business data on a map, along with geographical details
• Geocoding support
• Active data support
![Page 38: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/38.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
TreemapDisplay hierarchy using color and size of the nodes to convey information
• Introduced in ADF 12.1.2 and 11.1.7, MAF 2.0• Context Menus• Drag and Drop• Drilling/Isolate (ADF)• Popups• Selection• Other node (group small values)• Small form factor
![Page 39: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/39.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
SunburstDisplay the metrics for all levels in the hierarchy at the same time
• Introduced in ADF 12.1.2 and 11.1.1.7, MAF 2.0
• Radial layout
• All Treemap features
• Rotation
• Enable drilling to allow the user to traverse the hierarchy (ADF)
![Page 40: Oracle Data Visualizations](https://reader035.vdocuments.us/reader035/viewer/2022062314/56813ae3550346895da338ed/html5/thumbnails/40.jpg)
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
TimelineVisualize events on an interactive timeline
• Introduced in 12.1.2 and 11.1.1.7
• Customized node content
• Drag and drop
• Stacking of nodes
• Animation
• Scrolling, zooming, panning