Welcome to the Beyond Blog

2 minutes reading time (428 words)

Data Enrichment and Obfuscation in OAC 18.3.3

Enrichment OAC Enrichment

The new (September 2018) version of Oracle Analytics Cloud (OAC) now includes data enrichment functionality.  To show a snippet of this in action, we have a small excel file with made up credit card details, a name and an address.  We can use both obfuscation and enrichment to enhance and secure this data and then perform some visualisation on the enhanced data.  

Firstly, load up the data into a data set.

Let us start by clicking on the credit card number.  A list of options in context then appears; in this case 'Obfuscate' and 'Delete'.  This is of course a completely made up number as you can guess, but it is recognised as following the correct format of a credit card number (which I believe is the Lunn Algorithm).  

Click on 'Obfuscate' and then press the 'tick' button to select it.  

This has the immediate effect of hiding the content of the field whilst retaining the size.
Now click on 'Forename' and we see that we can add gender.

Selecting this has the effect of adding a new column called 'Forename_gender' which is set to MALE.  This is a useful facility for an "indicative" analysis of data should there be a requirement to create an initial binary segregation of genders (so far as that can be achieved by the only reference point being a forename).  

Now let us turn our attention to the 'City' element of the data we have.  This is particularly impressive in terms of the scope of enrichment that can be applied, even so far as Population and Elevation.  

We will select the 'Lat' and 'Long' options which give us the Latitude and Longitude for the town and also the 'Country'.  You can see the Preparation Script being dynamically built up on the left hand side.  

Here I have run the 'Apply Script' and then created a new project.  ( I also went and renamed the initial spreadsheet to something more appropriate).

​I will also toggle the Longitute and Latitue columns to be Attributes not Measures so that I can use them in a map.

OK; Let's select the City and the Lat/Lon and create a map.

​Here we see that the Lat/Lon have indeed been calculated and we have 'Altrincham' on the map.

Let's bring in some the other enriched data so we can see that too.

​This capability is a really exciting addition to the already powerful capabilities of the OAC suite by adding additional value to the data.  It'll be interesting to see how this capability develops in future releases.  

Connecting to an Essbase Cube using Smart View
New Visualizations in OAC 18.3.3 and DV Desktop v5...

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Thursday, 18 October 2018

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

76 King Street, Manchester

M2 4NH United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk