Oracle Data Visualizations

2. 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 Oracle Confidential

3. Oracle Confidential

4. Program Agenda 1 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 2 3 4 5 6 7 Oracle Confidential – Internal/Restricted/Highly Restricted

5. 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

6. Themes • 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

7. Oracle Fusion Applications

8. Oracle Fusion Applications

9. Oracle Fusion Applications

10. Oracle Fusion Applications

11. Oracle Enterprise Manager

12. Oracle Fusion Financials

13. Oracle Retail

14. Visual Information Builder 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

15. Product Lifecycle Management: Product Traceability 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 Manufacturing: Work Definition Management

16. 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

17. 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

18. After the Break: Data Visualizations - New Features in JDeveloper 12.1.3 and Mobile Application Framework Oracle Confidential

19. Benefits of the New Charting Solution • New Chart and Gauge components in ADF 12.1.3 • Already used by ADF Mobile • Now exposed in ADF and new Mobile Application Framework

20. Benefits of the New Charting Solution • 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

21. Graph and Chart: Migration Strategy • 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

22. Graph and Chart: Migration Strategy

23. Thematic Map New Features • Area layer styling and marker zoom behavior • Marker rotation • Ability to display isolated areas • Support for custom base maps

24. New Component: Diagram • 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

25. Data Visualizations in Mobile Application Framework • Charts • Gauges • Geographic Map • Thematic Map • Treemap • Sunburst • Timeline • NBox

26. Treemap in Mobile Application Framework • Display hierarchy using color and size of the nodes to convey information • Only one level of hierarchy displayed in Mobile Application Framework

27. Sunburst in Mobile Application Framework • Display metrics in a radial layout • Only one level of hierarchy displayed in Mobile Application Framework • Selection, rotation

28. Timeline in Mobile Application Framework • Visualizes events on an interactive timeline • Concepts shared with ADF Timeline • New feature: Duration bars • No overview window

29. New Visualization: NBox • Currently exposed only in Mobile Application Framework • Visualizes and compares employee performance vs. potential • Supports various options for color coding, marker shapes, and grouping

30. Data Visualizations Collateral on OTN • 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

31. Questions for You • 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?

32. Questions for You • 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)?

34. Pivot Table Multiple 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

35. Hierarchy Viewer View complex hierarchical data Panel cards for changing node content Multiple layouts Search Expand/collapse nodes Drag and drop

36. Gantt Charts Track 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

37. Geographic Map Functionality of Oracle Spatial within ADF View business data on a map, along with geographical details Geocoding support Active data support

38. Treemap Display 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

39. Sunburst Display 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)

40. Timeline Visualize 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