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:
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.
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.
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.
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.
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:
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.
These types help you identify data group categories, clusters, and outliers:
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:
The tools under the heading of "Other Visualization Analytics" include:
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 is Senior Director, Product Strategy covering Oracle Analytics and AI.