Posts tagged treemap
ADF 12c – The Hierarchical Mystery Tour – Treemap, Sunburst, Treetable, Hierarchy Viewer and Thematic Map0
Hierarchical data is common phenomenon in the real world. Presenting such data to allow users to quickly grasp the composition of numbers, to compare quantities, to navigate through a data set and to have a pleasant experience with potentially dreary facts is quite valuable. ADF 12c (as well as previous releases) offer a wealth of components that help us present data in interesting, meaningful ways. For hierarchical data, components that come to mind include the Hierarchy Viewer, the Treemap and Sunburst components and if the data is of a geographical nature the Map components. Of course the tree and treetable and pivot table can be used to present such data as well.
This article demonstrates the use of a number of these components on population statistics for cities, countries, continents and regions. I hope you spot the hierarchical pattern in this list. This YouTube movie (4.20 minute, no sound) shows the components in actions. The resources section of this article makes the JDeveloper 12c (12.1.2) application available for download, with all the source code inside.
The recent JDeveloper/ADF 11gR1 Patch Set 6 release introduced the Sunburst component, one of the many data visualization components in ADF. Sunburst (sometimes called Rings Chart) provides an attractive and useful way to quickly learn about the hierarchical build of certain values. One well known example is the space usage on a storage device, such as on the Gnome desktop on Linux – see on the right.
The left side of the figure shows the directories on the file system and their relative and absolute size. The rings chart or sunburst makes it abundantly clear which directories contain the most data and which subdirectories inside are the big ones.
The ADF DVT Sunburst component allows us to create a similar representation of the build up of a values from their constituents and their constituents. A simple and not very exciting example is presented in this article: the salary distribution in table EMP – per department (level 1) and per employee (level 2). We will also compare this presentation as sunburst with the counterpart presentation using Treemap. The two are quite similar and can be used in similar circumstances, depending on whether the focus of using the data visualization More >
We all know a lot of money is involved with professional sports. One of Europe’s major sports is football (or soccer as some like to call it). A lot of money changes in hand in football. And it seems that the results are determined primarily by the money. The major pan-European competition – the UEFA Champion’s League- is called out of reach for representatives from smaller countries – because of their lag in terms of yearly budget. And the national leagues are dominated by [clubs that have the] money.
Together with my son Tobias we decided to investigate. How much money is in the budgets for all clubs taken together in each of the major football leagues? And how is that money distributed over the clubs. Is it evenly allocated or are there wild variations? And is money a guarantee for success?
We decided to use the ADF DVT Treemap component to visualize our findings. From left to right, you see four treemaps, representing the football leagues of England, Spain, Germany and The Netherlands. The size of each treemap corresponds with the sum of all club budgets in that league. Inside the treemap, each area represents a club. The size of the area corresponds with the budget of the More >
In a recent article (http://technology.amis.nl/2013/04/02/adf-dvt-using-the-tree-map-visualization-component-to-compare-relative-sizes-and-distributions/) I discussed the ADF DVT Treemap component. This component visualizes data in such a way that comparisons between data values for different records and categories can quickly be made. The size of areas is a measure for some numerical value. As an additional dimension, the color of the areas can be used to identify groups (all members of the group having the same color) or to visualize a second numerical value (color can range for example from dark red to rich green depending on the net revenue per record).
This article describes the situation where we want to use multiple Treemap instances lined up. Each Treemap instance represents a collection of records on one or possibly multiple levels. Each instance can be drilled down into independently. And each instance can represent a different data set, even though we want to compare these data sets. Using a PanelGridLayout, it is easy to position multiple instances in a row or a grid. Using the inline style to scale the width and height of the Treemap instances, we can set the relative More >
The tree map component is one of those data visualization components that can tell an entire story through a simple picture. But of course that picture is anything but simple. And it is not even just a picture: it supports various forms of interaction such as drill down and popup. I had seen the Tree Map for the first time in demonstrations by Oracle Product Management. It seemed okay, but nothing very spectacular. Now, after having tried out the component for myself as well as studying the documentation, I may have to revise my initial opinion: it is actually a pretty cool and powerful component.
The Tree Map is used to present data values in a way that makes comparison easy, using two dimensions: (relative) size and color. The TreeMap uses containers for nodes with sizes relative to the numerical value associated with the nodes. Each node can have details and the container is presented with enclosed areas for each of the details. The size of these areas is proportional again to the value associated with the child node. All areas can be colored automatically – to create a pretty picture – or can be colored according to rules we can specify in order to have the colors also convey More >
One of my favorite areas of ADF is Data Visualization. The rich, interactive and (un)usually attractive components that allow me to spice up an ADF application in a very easy straightforward way have a special appeal. We all know that pictures speak volumes. And that a plain table presents data while a carefully designed visualization presents information and perhaps even a call to action. One of my highlights during Oracle Open World 2012 was – not surprisingly – the presentation by the ADF DVT team – Katrina, Hugh and Jairam – together with Yiannis and Vangelis from PCS in Greece who built a wonderful ADF application for private investment management, with beautiful and very effective data visualizations all over the place.
The story of ADF DVT is one that started probably even before ADF with the BI Beans and before that perhaps even with Oracle Graphics. However, forget about all that history and look to the present and the future. No presentation of Fusion Applications is held without showing off its many data visualizations as a means to turn data into information and information into action. Drawing the user to exceptions, deadlines, alerts, patterns and items to act on is More >