Welcome to the Beyond Blog

2 minutes reading time (433 words)

Oracle Data Visualization V4 - Data Flows

Data Flows in v4 of Oracle Data Visualization (in the new OAC as well as Desktop) is much improved, so let's look at creating a flow to :

  • Join together two datasets
  • Filter the columns
  • Create some bins
  • Add a new calculated column
  • Save the results as a singe data source that we can then analyze.

Our flow will eventually look like this .....

img1.png

We will start with one data set I have created, that being a spreadsheet of ficticious sales people and their travelling and renumeration.

img2.png

The second data set is a sheet of the sales people with the cars that they drive

img3.png

So let's get the basics out of the way and load them both up as data sets ....


img4.png

Once we've done that let's goto the data flows and build up our flow - starting with the data set of the cars

img12.png

Now click on the "plus" indicator to add another step

img14.png

Choose "Add Data" in order to add a second data set - and here select the Salesmans' renumeration sheet

img15.png

Note that DV has automatically joined the two data sources together by identifying there is a column called Salesman in both of them. In this case this is exactly what we want, so we will leave this alone, however you can of course change this if this is not what was required.

img16.png

Now click on the plus icon and add in Select Columns as shown below

img17.png

1. By default all are selected, so move the Salesman_1 column to the left hand side by highlighting it and clicking on Remove Selected. As both data sets has a column called Salesman then one of them was renamed to Salesman_1 to avoid duplicate names and as they show the same data we only require one of them.

img18.png

Now we can add some bins; if you are fmailiar with Oracle BI then this is a similar concept, but basically it is a way of assigning items into buckets

img19.png

I have created on here by setting the options to smooth out the buckets so we have the same number ( or as close as possible ) of records in each bin.

img21.png

This creates us a new bin column as shown

img22.png

Now let us add a new column to the flow. We will ceate a column that takes the commission and calculates that as a percentage of the sales amount

img23.png

Validate and save that

img25.png

Now let us save the data to a new data file

img26.png

Now we can execute the flow and then create a project based on the results of the flow

img31.png

Simple Machine Learning
Data Visualization Desktop – Data Actions

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Sunday, 05 July 2020

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Suite 1.01 Jactin House,

24 Hood Street, Manchester

M4 6WX United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk