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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Next Post

Watch Oracle OpenWorld 2017 Keynotes On Demand

Facebook0TwitterLinkedinWatch 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) – […]