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

Lucas Jellema 1
0 0
Read Time:1 Minute, 46 Second

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

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.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

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: