Welcome to the Beyond Blog

2 minutes reading time (420 words)

Oracle Data Visualization v4 - Sentiment Analysis

Oracle Data Visualizer has been out for a couple of years now and is already on version 4. I'm a big fan and have been digging deep into the latest release which has brought in a substantial amount of changes. They are all available here, but I think that the most exciting inclusions are around the Explain capability and new algorithms that have been included in the product focused on Sentiment Analysis and Machine Learning, as well as the opportunity to load up your own custom scripts.

As an example, let us perform some Sentiment Analysis. I have created some sample data by means of some short reviews of three ficticious restaurants.

b2ap3_thumbnail_dv1.png

Two look pretty good to me and one somewhat less so. Let's push this through the sentiment analyzer and see what results we get. Firstly I navigate to the new super-dynamic Home Page in Data Visualizer v4 and selet the Data tab on the left hand side

b2ap3_thumbnail_dv10.png

As per previous versions, we can upload the data - it can of course be sourced from multiple types of sources, but for this example we're just uploading my small review spreadsheet.

b2ap3_thumbnail_dv3.png

Now we have the data file, we can goto the Data Flows section and create a new data flow. Here we start the flow with the source restaurant review data file.

b2ap3_thumbnail_dv4.png

Note that there are a substantial number of Machine Learning models now available to use in the flow and we will be covering examples of these in further posts.

b2ap3_thumbnail_dv5.png

So, let us add a Sentiment Analysis as the next part of the flow. We will tell Data Visualizer to use the Review column as the source of the analysis and to write out the sentiment to a new column called Emotion.

b2ap3_thumbnail_dv6.png

Let us now add the final storage step to hold the results of the output of the flow. If you look at the table below you can also see that the Sentiment Analysis has done it's job already actually and created what I think look to be pretty accurate results.

b2ap3_thumbnail_dv7.png

We will now save and run the data flow - which will be instant - and then we can look at the results by creaing a simple Project and a visulaisation with a bit of colour.

b2ap3_thumbnail_dv8.png

Personally I think we can now really see the investment in the product coming through and not only is getting so much more powerful, it stilll importantly remains intunitive to use and is a great tool to augment "traditional" BI.

Oracle APEX Application Exploits - Part 3
Oracle HRMS - Which View Should I Use?

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Monday, 23 July 2018

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Barnett House, 53 Fountain Street,

Manchester M2 2AN United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk