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

0 0

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:

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.

lucas.jellema@amis.nl

https://www.amis.nl/

Happy

0 0 %

Sad

0 0 %

Excited

0 0 %

Sleepy

0 0 %

Angry

0 0 %

Surprise

0 0 %

Related posts:

Oracle Functions – Serverless architecture on the Oracle PaaS Cloud Application Container Cloud and Multi Tenant Services – Oracle embracing 3rd party technologies and open source projects Oracle Public Cloud and Kafka – Events powering the cloud – The Oracle PaaS Cloud Event BusHub Hey Mum, I am a Citizen Data Scientist with Oracle Data Visualization Cloud (and you can be one too) OOW 2012 – Larry Ellison’s Keynote Announcements: Exa, Cloud, Database