Posts tagged data visualization
Recently the ADF SIG at AMIS organized an ADF DVT Speed Date. During this speed date six AMIS consultants presented their favorite DVT Component. In a series of blogposts we share the knowledge and findings. In this post you get introduced to the ADF DVT bubble graph. I will also show you how to make it interactive by clicking on the bubbles. The ability to make a graph interactive can be very usefull.
In the following bubble graph that we are going to create, the Life expectancy (y-axis), income a year (x-axis) and the population (bubble size) is shown. This in steps of 10 years, for the last 50 years (1970, 1980, 1990, 20000 and 2010). So for each country 5 bubbles are shown. The location of the bubble has a meaning; for example in Japan (grey) the life expectancy is the highest and in Pakistan the lowest (green). -Have developing countries moved forward their income? -Do they have longer lifes than 10, 20, 30, 40 or 50 years ago? A picture says more than thousand words – you can see it immediately in the graph.
Out of the box usage of ADF DVT Scheduling Gantt Chart to report Database Query Results using stacked bar charts per time period0
Gantt Charts in ADF are interesting components to visualize data that is organized according to time. The Gantt Charts have a horizontal time axis. In rows along the vertical axis, resources or tasks are displayed. The cells in this time/resource matrix represent information about the resource or the task at some point in time or more specifically: in some time period.
In this recent blog-article, I explained how we can use the Schedule Gantt chart to present results per resource per period using something closely resembling horizontal bar charts. The key thought is that when we present data associated with a standard period, we can use the Gantt Chart’s capability to set the length of the bar to express the size of the value in a specific period. More specifically: we can use the end date property to manipulate the length of the bar. This article we will take this one step further and create a Stacked Bar Chart for each resource for each period. In this case, I will present the number of Employees hired per Department per Year and do so using Stacked Bar Charts with segments per Job. The result – driven directly from SQL query in a read only ViewObject – looks like this:
We can More >
ADF DVT: Thinking out of the box with the Scheduling Gantt Chart – Reporting by Period, for example Football Results over the years0
In various recent articles (such as Drag and Drop in ADF DVT Schedule Gantt) I have discussed the ADF DVT Gantt Chart component. And in these articles I have been describing the Gantt Charts as they were intended. However, something compels me to go beyond what was intended at the initial conception of the component. Just because I can, if for no other reason. So I am going to do just that in this article.
A Gantt Chart is basically a matrix report. The horizontal axis represents time, the vertical axis represents tasks or resources and the cells or bars positioned on this time vs. resources grid present an allocation of sorts of the resource in time. The Resource Utilization Gantt in ADF DVT is a slight variation on the theme – and it is where I got some inspiration from. It does not take time as a continuum but rather divides time in periods (days, weeks, months, quarters, years etc.) and presents for each resource its utilization per period through vertical bars.
My improvisation no the theme is to take the Scheduling Bar Chart and do something similar: present data per period, only using horizontal bars. This not only provides me with yet another way of presenting data – which More >
Recently the ADF Special Interest Group at AMIS organized an ADF DVT Speed Date. During this speed date, six ADF specialists from our team presented their favorite Data Visualization Component from the DVT library. In a series of blog posts we share the information with a broader audience. In this post you get introduced to Gantt Charts – which was my own date for this party.ADF DVT Gantt Chart – Introduction
The probably most distinguishing feature of any Gantt Chart is the horizontal time axis. Gantt Charts are used to present data against time.
Gantt Charts were invented in the 1910s by Henry Gantt (hence the name) – although a Polish engineer probably beat him to it but forgot to blog about it (http://en.wikipedia.org/wiki/Gantt_chart). They were used initially for presenting Project Schedules – showing tasks with their start time and end time and their dependencies. The essence of many modern project management tools is in fact a Gantt Chart – frequently an interactive one.
ADF DVT provides this project- and task overview in a Gantt format. Two additional Gantt Charts are provided as well:
In a recent article – Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions – I discussed how to use Analytical Functions in SQL to cleverly (!) derive the valid periods from a database table that contains periods of inclusion and exclusion. A valid period is a period for which there is at least one inclusion and for which there is no exclusion. I used several powerpoint based graphics to illustrate the business case. For example:
to depict the periods of inclusion and exclusion and this figure to demonstrate how to derive the valid periods (the blue bars):
After completing this article – and fiddling around in Powerpoint quite a bit – I realized that for visualizing data in a table, I have a perfect tool at my fingertips: the Data Visualization Tags (DVT) in ADF 11g are created for this very purpose: turning data into information through visualization. And this rich library of DVTs components contains – in addition to fairly straightforward visualizations such as bar charts, pie charts and line graphs – also more complex visualization components such as the Bubble Chart, Thematic Map and Gantt Chart. The Gantt Chart has three 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 >