I have played a little with Oracle’s Data Visualization cloud and it is really fun to be able to so quickly turn raw data into nice and sometimes meaningful visuals. I do not pretend I grasp the full potential of Data Viz CS, but I can show you some simple steps to quickly create something good looking and potentially really useful.
My very first steps were documented in this earlier article: https://technology.amis.nl/2017/09/10/hey-mum-i-am-a-citizen-data-scientist-with-oracle-data-visualization-cloud-and-you-can-be-one-too/.
In this article, I start with two tables in a cloud database – with the data we used for the Soaring through the Clouds demo at Oracle OpenWorld 2017:
As described in the earlier article, I have created a database connection to this DBaaS instance and I have created data sources for these two tables.
Now I am ready to create a new project:
I select the data sources to use in this project:
And on the prepare tab I make sure that the connection between the Data Sources is defined correctly (with Proposed Acts adding fact – lookup data – to the Albums):
On the Visualize tab, I drag the Release Date to the main pane.
I then select Timeline as visualization :
Next, I bring the title of the album to the Details section:
and the genre of the album to the Color area:
Then I realize I would like to have the concatenation of Artist Name and Album Title in the details section. However, I cannot add two attributes to that area. What I can do instead is create a Calculation:
Next I can use this caclculation for the details:
I can use Trellis Rows to create a Timeline per value of the selected attribute, in this case the artist:
It is very easy to add filters – that can be manipulated by end users in presentation mode to filter on data relevant to them. Simply drag attributes to the filter section at the top:
Then select the desired filter values:
and the visualization is updated accordingly: