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.

Gathering new knowledge

Last June I was present at the nl_OUG Tech Experience 2017. These kind of events are not only interesting because of the networking possibilities. One of the most valuable aspects  is the fact that people are sharing their knowledge. The Oracle community is a very active community so there were two days of intensive knowledge sharing. I wrote two blogpost to give a short impression of the 15th and the 16th of June.

I am active in Oracle related environments since the late ’90s. The world back then compared to the world today is completely different. We entered the “The Fourth Industrial Revolution”. New technologies and different ways of working, collaborating and communicating force us to change the way we act. This means learning new things. Tim Hall is writing a serie of blogposts about learning new things.

Following several presentations and keynotes at the “nl_OUG Tech Experience 2017” proved to me that there is a lot to learn. Even when I was preparing for my own presentation.

When searching for information and talking to several people it turned out that I learned new things along the way. After two days I had enough subjects to start investigating. It is so much that I had not got a clue of where to start. Lot’s of things are interesting. I decided to just have a go and see where it leads to.

Blogging gives me the opportunity to store my findings and share it with the rest of the world. I know that at least I will benefit from this.

There are three subjects in general were I want to share my findings. I will share these findings from one central blogpost where I will link to various other posts.

When these posts are ready, I will update these links. I hope you will find my findings interesting. Please share your comments.

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

nl.OUG Tech Experience 16 June 2017

Today the second day of the nl.OUG Tech Experience took place in ‘De Rijtuigenloods’. After a really interesting first day it was a real challenge to be at least as good as the day before on day 2. Also for this day the Dutch Oracle User Group has prepared an interesting and varied program. It is nice to see that there was a mix of people which represented the Oracle Community. There where ACE’s and non-ACE’s, men and also women, veteran speakers and relatively newbies (including myself), young and old, Dutchies and foreigners. All in all a great mixture of people with all the same goal; exchanging knowledge, meeting (new) people and having a lot of fun.

Duncan Mills (Oracle) kicked off the day explaining how he loves instead of fears the (Oracle) Cloud.

 

One of the things Duncan has learned in his long impressive career is to be pragmatic. You should make your life as easy as possible. The Cloud offers various tools to support this. In the end the Cloud is a ‘Force Multiplier’ for developers

After the keynote the Experience continued with the different parallel sessions. Also today, one of the SIG-Leads of the nl.OUG, I had the privilege to be part of the BIWA-track (Business Analytics & Data Integration). Today we had four different parallel tracks.

“Migration steps from OWB to ODI” – Gurcan Orhan

Oracle Data Integrator (ODI) is Oracle’s flagship product when it comes to Data Integration (ETL / E-LT). Officials Oracle Warehouse Builder (OWB) does not exist anymore. Still lot’s of company’s are using OWB. Migrating from OWB to ODI is not that easy by default. Gurcan explained which migration steps could make this process a bit easier.

“Introduction in Big Data Cloud Service and Use case” – Marco Klaassens & Daan Bakboord

When you talk about Big Data and the Cloud, Oracle might not be the first supplier people think about. Still Oracle is making serious progression when it comes to the various Cloud products. With an introduction into the Oracle Big Data Cloud Services, all the products could be placed into the context of the Oracle Information Management Reference Architecture. These architectures always make more sense when explained by a real use case.

“Oracle BI is just Lego for adults”

“A Day in the Life of an Oracle Analytics Query” – Christian Berg

When Christian Berg takes the stand you always know his message is supported by sarcasm, fun and beer. It does not matter which product you use in the Oracle Analytics stack, they are all based on the same core. With Oracle Analytics you don’t write a query (just use Oracle SQL Developer for that. Easier and cheaper). Oracle Analytics generates a query based on the metadata you provide. Therefore it is essential to understand how a query is constructed.

Of course Christian had one of the best one-liners of the day; “Oracle BI is just Lego for adults”. Different components fit together to make e.g. the perfect query. If one component does not fit, you don’t get a saw to make the component fit, you try another one which is made to fit in that place.

“Collaboration on analystics in the Oracle Business Intelligence and Data Visualization Cloud Service” – Hasso Schaap

There are several reasons to collaborate on Analytics. Sharing Insights and Story telling are just two examples. Oracle Analytics offers various options to collaborate. Hasso made some reusables. Get into contact with him and start collaborating.

At the end of two really great days, Lucas Jellema wrapped up the experience. With a few salutes, to the board of the nl.OUG for being so brave to host this event, to the audience for joining the conference and to the speakers who were well prepared and willing to share their experiences.

Special thanks to the sponsors.

 

It was a really great event. I enjoyed it a lot. It’s great meeting ‘old’ friends and meeting new ones. The bar is set high for next years experience. Already looking forward!

Download presentations from #OGhTech17 from https://www.nloug.nl/handouts.aspx – only a few slidedecks available, more to follow soon.

See you all next year.

Originally written for LinkedIn

nl.OUG Tech Experience 15 June 2017

Today the first day of the nl-OUG Tech Experience took place in ‘De Rijtuigenloods’. De Dutch Oracle User Group has prepared an interesting and varied program with different speakers from various countries covering almost the complete Oracle RedStack.

 

But first Chairman Robin Buitenhuis kicked of the #OGhTech17 and announced the name change of the OGh. From now on it will be nl.OUG!

Sesame Street SQL

After Robin’s introduction, Maria Colgan from Oracle took the stand. She covered the struggle between developers & dba’s while developing applications. With the (new) Oracle 12c database there is less reason to argue. Here presentation covered subjects like JSON, REST and Docker. In the end Maria could conclude that the Oracle 12c database is the ‘Universal Peace Maker’. Check some more here, to get an impression about some of things Maria showed.

Maria must have had the best term of the day by using; ‘Sesame Street SQL’ which refers to some easy lines of SQL code.

The Experience continued with the different parallel sessions. As one of the SIG-Leads of the OGh I had the privilege to be part of the BIWA-track (Business Analytics & Data Integration). Today there were five different parallel tracks.

“Is Oracle the best Language for Statistics.” – Brendan Tierney

Oracle comes with over 300+ statistical functions. These statistical functions are available in all version of the Database. When people are performing statistical analytics it’s always about Excel and R. When doing statistical analysis in the database, there is no need to extract any data onto client machines. It would also eliminate the possible data security issues with using Excel, R or any other tools.

“OBIEE DevOps with Containers: How and Why?” – Gianni Ceresa

Business Analytics development processes should be flexible and agile. Oracle BI is not that flexible and agile by default. A DevOps strategy can be implemented with the help of Docker containers, version control software (e.g. Git) and continuous integration (GitLab) tooling.

“Running R in your Oracle Database using Oracle R Entreprise” – Brendan Tierney

After Brendan’s first presentation one could think there is no need using R. One can do it all with Oracle Database statistical functions. In this presentation we got an introduction into Oracle R Enterprise. Combining the power of R with the in-database Data Mining / Advanced Analytics capabilities.

“Data Modeling, BI Modeling and-or Data Blending & Wrangling. What should I do?” – Hasso Schaap

In Analytics it’s all about data. There are various ways to use this data. If you choose to use it directly you can just blend and wrangle the data in your self-service tool. In some cases it might be better to prepare, govern and secure the data. There will be a need to model the data, either upfront (Conceptual, Logical and Physical) or in the Business Analytics Tool.

“EDQ, OGG and ODI over Exadata in the Cloud for Perfection” – Gurcan Orhan

The BIWA track concluded this day with a taste of pizza as a metaphor of the various Oracle Data Integration tools (EDQ – Enterprise Data Quality, OGG – Oracle Golden Gate and ODI – Oracle Data Integrator) assembled on the Oracle Exadata Machine. Hardware and Software integrated together both On-Premise as well as in the Cloud.

All in all a very interesting day and (hopefully) a start of a new tradition in Oracle Redstack knowledge exchange in the Netherlands.

Originally written for LinkedIn.