Fun with Data Visualization Cloud–creating a timeline for album releases

Lucas Jellema 1

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:

image

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:

image

I select the data sources to use in this project:

image

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):

image

On the Visualize tab, I drag the Release Date to the main pane.

image

I then select Timeline as visualization :

image

Next, I bring the title of the album to the Details section:

image

and the genre of the album to the Color area:

image

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:

image

Next I can use this caclculation for the details:

image

I can use Trellis Rows to create a Timeline per value of the selected attribute, in this case the artist:

image

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:

image

Then select the desired filter values:

image

and the visualization is updated accordingly:

image

One thought on “Fun with Data Visualization Cloud–creating a timeline for album releases

Comments are closed.

Next Post

Watch Oracle OpenWorld 2017 Keynotes On Demand

Watch Keynotes on YouTube using these links: Larry Ellison (Sunday Oct 1st) – https://www.youtube.com/watch?v=HEupUSSSEBo Dave Donatelli (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=irvNYpCopA8  Thomas Kurian (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=cef7C2uiDTM  Larry Ellison (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=faKWViY6zEk&t=6s  SuiteConnect – Evan Goldberg (Wednesday Oct 4th) – https://www.youtube.com/watch?v=pURoDocJW1Y  JavaOne Keynote (Monday Oct 2nd) – […]
%d bloggers like this: