Oracle Analytics Data Visualization Cheat Sheet: 50+ Ways To View Your Data

January 13, 2022 | 5 minute read
Benjamin Arnulf
Senior Director, Product Strategy, Oracle Analytics
Text Size 100%:

Oracle Analytics offers comprehensive data visualization capabilities, including more than 50 visualization types that help you view and analyze your data. It also includes a Software Developer Kit (SDK) that allows you to add your own visualization types, which behave as if they're part of the product. Use this Data Visualization Types Cheat Sheet to see a high-level view of the visualization options available in Oracle Analytics and to demystify some of them along the way.

The majority of the visualization types fall within these categories:

  • Bar Graphs
  • Line Graphs
  • Network Graphs
  • Grid Graphs
  • Geospatial Graphs
  • Pie and Treemap Graphs
  • Scatter Graphs

Some types for visualizing and filtering data don't fall easily under these categories. You're perhaps familiar with some of these types (such as bar graphs and line graphs), while others might be new to you. Explore them all; because when it comes to business intelligence, everyone benefits from a fresh perspective. You can easily change from one type of visualization to another, often with a single mouse click. 

Bar Graphs [Add visuals of graphs]
The Bar Graph category offers various options such as the stacked bar graph. The recently enhanced waterfall graph provides a great way to show the X, Y, Z axes and is useful in executive presentations.  

  • Stacked
  • 100% Stacked
  • Horizontal
  • Butterfly
  • Waterfall
  • Horizontal Boxplot
  • 3D Chart Viz Plugin

 

Line Graphs
Line graphs help you track changes over time, and are especially useful for comparing changes over the same period of time for more than one group.

  • Line
  • Area
  • Stacked Area
  • 100% Area
  • Radar Line
  • Radar Area
  • Radar Bar
  • Pareto Plugin
  • Gantt Plugin

 

Network Graphs
Oracle Analytics integrates with Oracle Spatial for even more compelling visualizations. Try these types, including the Circular Network Graph, to add excitement to your next presentation.

  • Network
  • Circular Network
  • Sankey
  • Tree Diagram
  • Chord Diagram
  • Parallel Coordinates

Grid Graphs
The grid graphs in Oracle Analytics Cloud enable you to move easily between detailed analysis and summary views, to see correlations and quickly find a-ha moments in your data.

  • Pivot
  • Table
  • Correlation Matrix
  • Picto
  • Grid Heatmap
  • Calendar Heatmap Plugin

Geospatial Graphs
These graph types allow you to overlay your data onto a map with support for many common map APIs such as Google Maps, Mapbox, and EZ Map. By using the
WebGL and the Mapbox library, Oracle Analytics offers a robust mapping capability. Geospatial graph types include: 

  • Map
  • Multi Layers
  • Image Background
  • REST Background

Learn more about GeoSpatial visualizations here.

Pies and Treemap
Showing how parts add up to the whole is an essential element in analysis and data storytelling.  OAC offers numerous options, as well as the ability to create your own plugin and use it just like a native chart, so you can quickly present key relationships.

  • Pie
  • Donut
  • Sunburst
  • Treemap
  • Row Expand Plugin
  • Dial Plugin

Scatter Graphs
These types help you identify data group categories, clusters, and outliers:

  • Scatter
  • Category
  • Stacked Category

Oracle Analytics provides even more visualizations and filters, which include items that aren't necessarily used to visualize data. For example, you can add a text box; create a timeline for displaying custom date information; drag and drop images; or use a language narrative visualization that allows you to use natural language generation to translate your data into sentences and explain it for you:

  • Tile
  • Language Narrative
  • Tag Cloud
  • Spacer
  • Image
  • Timeline
  • Text Box
  • List Box
  • List

The tools under the heading of "Other Visualization Analytics" include:

  • Machine Learning - For the automated creation and application of various scenarios.
  • Highlight - For identifying clusters and outliers.
  • Overlay & Projection - For providing a reference line, trend lines, and forecast overlays.
  • Conditional Formatting - For customizing the rules and scope of your data.
  • Explain - For outlining basic facts and key drivers.
  • Filtering - For commonly requested views including Bin, Top n (for filtering the top 10, 20, 30, and so on), and "Group by" for customized organization.
  • Automation & SDK - Auto-time levels and aggregation, and the Plugin SDK for customer software development.


Making Sense of All That You See

All these features and more are available today in Oracle Analytics. But visualizing your data is only part of the process. Oracle Analytics allows you to perform advanced calculations and numerous other operations from directly inside the platform. You can create and apply machine learning scenarios that highlight data clusters and outliers; create overlays and projections; incorporate multiple forecasting algorithms using Auto-Regressive Integrated Moving Average (ARIMA), and Seasonal ARIMA and Exponential Triple Smoothing (ETS) models; all with a simple right-click of your mouse.

Oracle Analytics offers a new rules engine that allows you to create custom rules and scopes while applying conditional formatting. Suppose that you want to apply formatting for only three visualizations out of four, or you want to create a rule that displays your profit in different colors depending on a specific threshold. These custom rules can be applied not only to pivot tables, but to any data visualization type.

There's so much to share about data visualization types in Oracle Analytics, but I hope this provides a good sense of the great power already at your fingertips. The platform is as powerful as you need it to be. Don't be afraid to explore its capabilities. Or contact your Oracle Analytics Leader for more tips.

Schedule a meeting today to talk to the Oracle Analytics product team and learn more about how you can visualize your data in Oracle Analytics.

Benjamin Arnulf

Senior Director, Product Strategy, Oracle Analytics

Benjamin Arnulf is Senior Director, Product Strategy covering Oracle Analytics and AI.


Previous Post

Oracle Analytics updates to be excited for in 2022

Benjamin Arnulf | 4 min read

Next Post


Oracle Analytics ML Algorithms: Make Sense of Your Big Data

Benjamin Arnulf | 4 min read