Oracle OOW17 Data Visualization Hands-on Lab @Home

Check out the following on the Twitter account of Mike Durran.

For those too lazy to type over the urls, find the links below.

Download / Cloud Trial:

Impact of Social Media –>
Creating Data Flows –>
Data –>

Analytics Library:

Have fun!

Oracle Mobile Analytcis options for the Oracle Analytics Cloud

A few weeks ago I wrote a piece about Oracle Mobile Analytics. Now a few weeks later I would like to add to this post with some things and findings I ran into over the last couple of weeks. I have been looking at the new Oracle Analytics Cloud (OAC) offering. This post is based on how Oracle Mobile Analytics relates to OAC.

In OAC there are various options for Mobile Analytics. First you can go to the mobile devices browser. Just startup the url in the browser. No need to download a mobile app. Using a mobile browser does come with some  issues / challenges. There are differences between the different browsers. Not all content on all browsers is rendered (the same). Also you cannot make use of mobile touch gestures like; touch, tap, double-tap, drag, pinch, swipe, zoom.

Two other options are Oracle Mobile HD (Consume the dashboards and reports via an app) and Synopsis (Free – offline – Data Analysis on the go).  The latter; Synopsis is not necessarily related to OAC. One would use Synopsis to analyse offline datasources. These might be OAC extracts, but there is no direct connection.

Oracle Synopsis 2.0 now available on Android devices. Picture yourself using your eyes as a data-set. Check out the Lens feature for free.

Last but not least Oracle Day by Day (BI Ask) – “This time it’s personal”.

With Oracle Day By Day, Oracle has made a fresh start on mobile, focusing on users’ information needs rather than on simple BI delivery. – The Forrester Wave™

The idea behind Oracle Day by Day (DxD) is to deliver personalised content (what) to the user when and where he/she wants it. It will know who a user communicates with. Eventually DxD will understand why a user is interested in certain content. Based on an users interactions with the app, DxD will learn how to integrate Analytics into the users (professional) live instead of the other way around. Oracle Day by Day is all about providing a platform where the user is not having to actively request information (i.e. issue queries), but instead receive delivered, personalised reports on their mobile or tablet as and when they need it.

It will be nice to further explore the capabilities of Oracle Day by Day. I will try to cover that in another post.

So there are three different applications in the Oracle Mobile Analytics Landscape when it comes to Oracle OAC. What are the major differences between these three?

This post is written as part of my Exploring Oracle Business Analytics series.

Thanks for reading.


Oracle Data Visualization Desktop for Mac is now available for download

Last week Oracle Data Visualization Desktop for Mac became available for download on OTN.

Unfortunately this version has not (yet) the same capabilities as the Windows version. According to a comment in the following thread on the Oracle OTN forum there are some issues with ‘R’ in the Mac version. Therefor the Advanced Analytics functionality is not available. Also because of driver availability DVD for Mac cannot connect to as many datasources as DVD for Windows.

Still for the Mac users amongst us, this is a first step in the ‘right’ direction.



Oracle Mobile Analytics

Imagine yourself without a mobile device. There was a time we used our mobile phone to make calls only. Ok, we did some text sending via sms. But that was it. Nowadays (if I look at myself) I do not use my phone to make phone calls. Yes, when I am in the car the phone comes in handy to speak to others and to kill time. The main reason I use my phone is to lookup information or to interact with other people. This is not by speech but by sending messages.

In lot’s of situations the smartphone or the tablet have taken over the role of the desktop computer. The same goes for Analytical Applications. People use their mobile devices to run analytics where the used to do that via their pc connected to the local network.

Also Oracle has a strategy for mobile analytics. Oracle currently offers three different mobile apps for analytics:

  • Oracle BI HD
  • Synopsis
  • Day By Day


Although it looks a little bit confusing, there just is a separate app for a different purpose.

Oracle BI HD is Oracle’s first mobile application for analytics. It’s basically another platform to run your desktop reports. Oracle BI HD can be licensed on top of on-premise OBIEE and is integrated with the Cloud license.

If you download the application from the app-store (Apple in my case) you can just connect to any Oracle BI Server you have available. I chose to connect to our Quistor BI Cloud environment. Of course you can add any other Oracle BI Server URL you want to connect to.





You have to enter a host. In the case of the Quistor BI Cloud environment you will enter the Service Instance URL which you can find in the BICS Service Details.

After the server is added and you connect to it, you have to enter the login details. This is similar to logging into the BICS environment.





Now you enter into the Analytics Environment where you have access to the same dashboards as you have available in the Cloud. Check here the General Ledger Dashboard of our Quistor BINGO environment.

The same dashboard on the left as it shows on my smartphone. Of course you do not have the same experience as on the desktop or even the tablet. But it is nice that you can bring your dashboards with you and analyse data while being on the road.




Synopsis allows a user to analyse files (received on) a mobile device without the need to access a Oracle BI Server.

Imagine you have an Excel spreadsheet available in a Box Cloud environment. In this case it is the Pipeline.xlsx.

After you download the application from the app-store (Apple in my case) you can import this spreadsheet directly into the Oracle Synopsis mobile application.



After the data is imported into the application, you have a project with the imported spreadsheet.



You can immediately analyse the Pipeline data. The application already prepared some analysis for you based on the data it finds.

Check out Youtube to see Oracle Synopsis in Action.





Day By Day is Oracle’s latest addition to the Oracle Mobile Application offering. This application is different from the Oracle BI HD application. You will use search technology, either by voice or by typing, to create your analysis.

You can download the application from the app-store (Apple in my case).

Starting up the application allows you to enter. One of the prerequisites of this application is an Oracle Analytics Cloud (OAC) environment with BI Author and DV Consumer roles. At this moment I do not have an OAC environment at my disposal. There is a demo included in the app. Select ‘Try a Demo’ and after you are welcomed to the application you can start analysing data.



Via a typed or spoken search string (in this case; ‘revenue per customer segment’ you can create an analysis.








This search leads to the graph on the right. Of course this is only an easy example. For more details and examples, please have a look here.





Interesting applications to check out. They might not all be evenly useful, but it’s good to have a choice of functionality to satisfy your mobile analytical needs. What I don’t get is that all the applications start with a blue screen. Not the bsod, but why Oracle did not choose an Oracle Red startup screen is a mystery for me.

This post is written as part of my Exploring Oracle Business Analytics series.

Thanks for reading.

Exploring Oracle Business Analytics

In the blogpost about “Gathering new Knowledge” I decided to investigate a few different areas of the Oracle atmosphere. Oracle Business Analytics was one of them. In a series of different blogposts I will cover different parts of the Oracle Business Analytics  product suite. At the end of this post there will be a list of different links to the blogposts I will be sharing.

I will begin with a post I created earlier. This is because of the importance of the subject. One crucial element in Oracle Analytics is the Oracle BI Server. Thanks to Christian Berg, we were able to go to the Core of Oracle Analytics.

Last month Oracle released a new version of Oracle Data Visualization V3.0. In this upgraded version you can expect some new functionality regarding:

  • connections to data sources & data preparation,
  • enhanced data flow
  • intuitive data visualization process setup & formatting
  • comprehensive system management toolset

When the posts are ready, I will post the links below. I hope you will find my findings interesting. Please share your comments.

This post is written as part of my Gathering new Knowledge series.

Thanks for reading.

Oracle Data Visualization V3.0

Last month Oracle released a new version of Oracle Data Visualization V3.0. In this upgraded version you can expect some new functionality regarding:

  • Connections to data sources & data preparation,
  • Enhanced data flow
  • Intuitive data visualization process setup & formatting
  • Comprehensive system management toolset

Check out the presentation of Philippe Lions below where he gives a tour of the Oracle Data Visualization V3.0 new features.

 did an excellent job outlining the new features. Also Francesco Tisiot has put his thoughts about V3 into a blog.

You can also directly have a look at this Youtube video below.

If you want to have a more detailed look (also mentioned in  blogpost), please check out these Oracle PM video playlist.

The guys over at Vlamis put together an interesting webcast outlining and showcasing some of the new V3 features.

The opportunities within Oracle Data Visualization are expanding and improving. Sometimes it is just too much to catch up with. Fortunately there is the Oracle Analytics Store. Here you can find different examples of the capabilities of Oracle Data Visualization. Some are create by Oracle PM and some by Oracle Partners. These examples can be downloaded and imported into your own environment. You should really check this out.

Also nice to see is the Oracle Data Visualization Interactive Demo.

This post is written as part of my Exploring Oracle Business Analytics series.

Thanks for reading.