Cloud

O SpecGold OracleBusIntApps7 clr

 Gcloud

 

   Call us now 

  Manchester Office

  +44 (0) 8450 940 998

 

  

 

Mark Daynes - Director of Beyond Systems

As you'd expect from the winners of the Specialized Partner of the Year: Business Analytics at the Oracle UKI Specialized Partner Awards 2014, Beyond work with leading edge BI Applications primarily within the UK Public Sector. We intend to share some of our ideas and discoveries via our blog and hopefully enrich the wider discussion surrounding Oracle Business Intelligence and driving improved insight for customers

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form

Oracle Data Visualization V4 - Data Flows

  • Font size: Larger Smaller
  • Subscribe to this entry
  • Print

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 .....

b2ap3_thumbnail_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.

b2ap3_thumbnail_img2.png

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

b2ap3_thumbnail_img3.png

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

 

b2ap3_thumbnail_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

b2ap3_thumbnail_img12.png

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

b2ap3_thumbnail_img14.png

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

b2ap3_thumbnail_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.

b2ap3_thumbnail_img16.png

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

b2ap3_thumbnail_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.

b2ap3_thumbnail_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 

b2ap3_thumbnail_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.

b2ap3_thumbnail_img21.png

This creates us a new bin column as shown

b2ap3_thumbnail_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

b2ap3_thumbnail_img23.png

Validate and save that

b2ap3_thumbnail_img25.png

Now let us save the data to a new data file

b2ap3_thumbnail_img26.png

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

b2ap3_thumbnail_img31.png

Last modified on
in Business Intelligence Hits: 233 0 Comments
0
Mark's first experience of Oracle was back in the 80's building applications using very early versions of Oracle Forms at Staffordshire University. Upon graduating in 1990 with a First Class B.Sc.(Hons) in Information Systems, he joined Oracle UK's consultancy team working on some of the first Oracle Applications implementations across the UK, eventually working for Oracle Local Government. Over the subsequent years to 2006 he worked in a mainly technical/functional capacity across sectors such as Corporate Banking, Utilities and Public Sector, solely on projects underpinned by Oracle technology. In 2006 he became a founding Director of Beyond Systems where he has honed the focus of the company to be one of enabling public sector customers to achieve excellence with Oracle Business Intelligence, especially Oracle BI Applications sourced from Oracle E-Business. Mark has presented at many joint Oracle/Beyond events as well as contributing his perspectives on the technical/strategic business usages of Oracle to various magazines, the first appearing in ODTUG back in 1995. Outside of business, Mark is a keen musician and plays lead guitar in a covers band and also enjoys sports, especially skiing and golf.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest
Guest Friday, 19 January 2018