Cloud

O SpecGold OracleBusIntApps7 clr

 Gcloud

 

   Call us now 

  Manchester Office

  +44 (0) 8450 940 998

 

  

 

Welcome to the Beyond Blog

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
Subscribe to this list via RSS Blog posts tagged in dv desktop

Oracle Data Visualization Desktop has a lot of useful features that you might not know about on first inspection, so in this blog I will run through what Data Actions are, and the clever ways they can be used in your own projects.

A data action enables you to link a visualization with an URL, move to another page in your project or to another project all together. Data Actions can also be used on any visualization, or restricted to specific visualizations. Filters can also be passed through a Data Action from one canvas to another.

URL Data Actions

Create a visualization, select the Canvas Settings icon in the top right and select Data Actions.

 b2ap3_thumbnail_Data-Actions-1.png

Click the + icon in the Data actions menu, check type to be URL and enter the URL you want to link your visualization to.

b2ap3_thumbnail_Data-Actions-2.png

Now if you right click onto your visualization, you’ll see your data action on the menu. Click this and you’ll be brought to your desired URL.

b2ap3_thumbnail_Data-Actions-3.png

Last modified on Continue reading
in Technical 75 0
0

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. 

Last modified on Continue reading
in Business Intelligence 346 0
0

Oracle Synopsis was first announced at Openworld 2016; a mobile platform to allow data analysis on the go on a mobile device. Think of it a bit like Oracle Data Visualizer Desktop for your phone or tablet. Up until now though it's only been available for Android devices, however over the weekend the iOS version was released on the Apple Store.
So your first question might be Ok, so how much is it to licence?. Well - the answer to that would be £0; it's FREE! Yes Free! You don't need any back end OBIEE software or anything to run it either - it runs completely on your device. With that in mind I thought I should take a look.

The idea behind Synopsis is that you can take a spreadsheet from any existing App (email etc) and easily import that. So I took a spreadsheet of spend data from my local authority (.csv format), emailed it to myself and used the new option Import with Synopsis to load up the dataset.

Import with Synopsis

Synopsis then proceeds to import the data file. My file was about 7MB which is a reasonable size for a .csv, however it only took a minute or two to import.

Importing

Last modified on Continue reading
Tagged in: dv desktop OBIEE
in Business Intelligence 1313 0
0

DV Desktop v2 has been on general release now for a week or so and I highly recommend the following Oracle video to see some of the new functionality

https://www.youtube.com/user/OracleBITechDemos/videos

There's a lot to like about this release - the hugely enhanced connectivity and workflow for example, but some things I haven't seen many people talking about yet is the SDK or the ability to use plugins to add new content; here's a quick way of doing this.

1) Goto the Oracle BI Public store

b2ap3_thumbnail_dial2.png

2) Select a plugin and download it.  Note that you DO NOT UNZIP the file and also you will need to create the /plugin directory.  By default on windows your %LOCALAPPDATA% directory is hidden so you'll probably need to unhide it to find it!

b2ap3_thumbnail_dial3.png

3) Volia - the new visualisation is available for use; here I have tweaked the setup of the dials and used them in my application.

b2ap3_thumbnail_dial1.png

...any questions ... please ask.

Last modified on Continue reading
in Techniques 1515 0
0