Oracle Business Analytics from a different angle

Gartner’s latest version of the Magic Quadrant for Business Intelligence and Analytics Platforms (#BIAMQ) caused a lot of noise in the Analytics Market. Gartner and Oracle have different views of this market. Gartner sees a difference; “…between a modern BI and Analytics Platform and a traditional, IT-centric Reporting and Analysis Platform”.

It’s clear that Oracle and Gartner have a different view on the Analytics Market. Is it Agile BI and / or Enterprise Reporting? There are probably several pros and cons for either view. In the end I don’t believe it’s a matter of right or wrong. Although Oracle is not included in Gartner’s Magic Quadrant, that does not mean that Oracle does not have a strategy when it comes to Business Analytics. It’s important that you see and understand the context of a certain view. I will try to give some more insights into Oracle’s Business Analytics Strategy.

Oracle Business Analytics Strategy

If an organization wants to stay ahead of the competition, it should focus on innovation. The Oracle Business Analytics Strategy supports this drive towards innovation with the Oracle Business Analytics Portfolio. This Portfolio consists of the following elements:

  • Operational Reporting (Monitoring)
  • Strategic Analytics (Optimization)
  • Visual Discovery (Innovation)

Operational Reporting (Monitoring) 

Although there is more and more focus on innovating an organization’s business, people still need (real-time) operational information to support their daily work. Employees use operational reports to solve problems or to monitor their daily operations.

Operational Reporting represents the current state of the different areas of the organization.

 

Strategic Analytics (Optimization)

Operational Reporting is specific per Line of Business. Business Leaders tend to look across the different Lines of Business. Strategic Analytics focuses on metrics that deliver insight. Questions like; ‘Why did it happen?‘ and ‘What will going to happen?‘ need to be answered.

Strategic Analytics represents the state of an organization as a whole.

Visual Discovery (Innovation)

The first two elements of the Oracle Business Analytics Portfolio are considered traditional forms of BI. Over the last years organizations have developed a need to explore various data sets without IT support. Organizations use visual data discovery tools to identify patterns and opportunities for innovation. These visual data discovery tools focus on ease of use and the ability to visualize different (complex) data sets.

Visual Discovery helps organizations answer questions like; ‚Should we invest in new sales channels?‘ or ‚Has a discount a positive effect on our revenue?‘.

To summarize, the Oracle Analytics Portfolio supports the drive towards innovation across the entire organization for all users and all analytic needs. According to Oracle, organizations need a bi-modal Business Analytics Strategy. This strategy is designed for IT-led (consistancy & scalability) and Business-led (speed & discovery) analytics initiatives.

 

Hybrid Cloud

Traditional BI platforms are characterized by IT-controlled reports and analysis on desktop dashboards. New BI platforms must be able to support the visualization of different (personal) data sets on mobile and wearables in the cloud or in a hybrid environment.

Oracle wants to extend existing investments in on-premise architectures with innovations in the cloud. Therefore the Oracle Analytics Portfolio can be deployed anywhere on-premise as well as in the cloud or in any hybrid form. It does not matter which deployment option is chosen, it’s the same architecture, the same standard and the same product.

Oracle’s Business Analytics Strategy aims at supporting IT-led buying as well as buying driven by the business. Next to that Oracle’s Business Analytics portfolio can be deployed on-premise as well as in the cloud. When it comes to; ‚buying driven by the business‘, Oracle offers Stand alone products as well as products integrated in the platform.The Oracle Business Analytics offering consists of the following products:

  • Data Visualization On-Premise
  • Data Visualization Cloud Service (DVCS)
  • Oracle BI Cloud Service (BICS)
    • Including Data Visualization
  • Oracle BI 12c
    • Data Visualization (add-on)

Oracle Data Visualization

With Oracle Data Visualization users can; ‚See the Signals‘. Oracle offers Visual Analytics in every solution, on every device, embedded in the cloud or integrated in the platform and even in the Big Data stack. Oracle Data Visualization enables users to create rich visuals of any data set in an intuitive way. Users can bring in different types of data sets to blend data together. Visualizations can be shared with others. Oracle Data Visualization supports; ‚Storytelling‘. This way users can help others see the same patterns and opportunities. Last but not least, Oracle Data Visualization is fully portable between any (mobile) device.

Oracle Data Visualization is simple but powerful. It is designed to support (small) departmental initiatives which should be performed without IT support. Oracle Visual Analytics projects can be started small, but can grow if necessary.

An organization can start with a subscription to the Data Visualization Cloud Service (DVCS) at a price of $150 per named user per month with a minimum of 5 users.

Sign up for a trial subscription to the Oracle Data Visualization Cloud Service here.

Oracle BI Cloud Service

The Oracle BI Cloud Service (BICS) is a complete Cloud Solution for Enterprise BI. With BICS it’s possible to combine any data from any data source. Via dozens of visualizations and calculations users can gain unique insights. BICS runs in the Oracle Cloud. The environment is fully managed, patched, backed up and upgraded by Oracle. This means that organizations running BICS can reduce significantly on operations, software, hardware and facilities.

Visual Analytics can be embedded into an Enterprise solution and that’s what makes Oracle unique. BICS makes it possible to integrate (blend) personal and enterprise data. Finally, BI applications are portable between on-premise and the cloud.

Sign up for a trial subscription to the Oracle Business Intelligence Cloud Service here.

Oracle Business Intelligence 12c

OBI 12c is one integrated platform which runs on-premise. Oracle Data Visualization can be embedded as a paid add-on. Oracle Business Intelligence 12c has a modern interface design. The new Alta UI, which is used across all Oracle’s applications, has a clean page design and is focussed on the data. One of the key new features in OBI 12c are the Advanced Analytics capabilities. This way a user can instantly answer predictive and statistical questions via a free distribution of R. Next to that Oracle made improvements to the mobile experience and the in-memory performance. Last but certainly not least, Oracle has made the OBI 12c a lot simpler. This means that Oracle has simplified the installation and configuration. This makes upgrading from 11g to 12c a lot less difficult than the upgrade from 10g to 11g. Also Regression Testing is made easy with the Baseline Validation Tool.

Oracle Business Intelligence 12c is an Enterprise Analytics Platform. It is Business Leader friendly as well as IT-friendly. OBI 12c allows users to upload their personal data and combine the results with IT-curated data for quick analysis and data visualization.

 

Summary

The Oracle Business Analytics Strategy is based on three pillars:

  • See the Signals
    • Visual Analytics in every solution
  • Sprint to Innovation
    • Cloud First strategy
  • Scale the Insights
    • One integrated platform

Quistor believes in Oracle’s strategy when it comes to Business Intelligence and Analytics. If necessary or desired, we would be happy to put things in context.

Daan Bakboord

This article is originally written for Quistor’s QPulse.

BIWA SIG Bijeenkomst op donderdag 26 mei 2016

Donderdag 26 mei 2016 was er een BIWA SIG Bijeenkomst van de OGh. De onderstaande onderwerpen zijn behandeld:

Metadata Management met Oracle Enterprise Metadata Management (OEMM). Eric van Ettekoven van Oracle gaf ons een introductie van deze tool waarmee zowel Data Lineage als Impact Analyse van Informatie systemen een stuk eenvoudiger wordt.

De presentatie van Eric is hier; http://bit.ly/OGh26052016oemm te downloaden.

Robbert Naastepad van MN gaf ons een inkijk in de Informatie Architectuur op basis van Oracle Data Integrator in combinatie met de Exa-hardware (Exadata & Exalogic) van Oracle. Robbert liet zien tegen welke uitdagingen je in deze betreffende architectuur kunt aanlopen en behandelde mogelijke oplossingen.

Ook de presentatie van Robbert is te downloaden en wel hier; http://bit.ly/OGh26052016ODI_Exa.

Over een volgende BIWA SIG Bijeenkomst wordt ook al nagedacht. Deze zal waarschijnlijk ergens na de zomer gehouden worden.

Mogelijke onderwerpen:

Oracle R (klantcase)
Oracle BI Cloud Service (klantcase)
Data Virtualistie
Oracle BI and Spatial

Mochten er andere interessante onderwerpen zijn laat dan even een berichtje achter of neem contact met mij op.

Hopelijk tot een volgende keer!

Daan Bakboord

BI & Analytics – Agile BI and / or Enterprise Reporting?

As I wrote in my last blogpost, Gartner’s latest version of the Magic Quadrant for Business Intelligence and Analytics Platforms () caused a lot of noise in the Analytics Market. Gartner and Oracle have different views of this market. Gartner sees a difference; “between a modern BI and Analytics Platform and a traditional, IT-centric Reporting and Analysis Platform”. I think this; ‘Behind the Scenes‘ gives some more background about how Gartner has put this Magic Quadrant for Business Intelligence and Analytics Platforms together. Find Part 2 of the story in the Market Guide for Enterprise-Reporting-Based Platforms.

It’s clear that Oracle and Gartner have a different view on the Analytics Market. It seems that also the different Analysts see things differently. To get a more complete view of the Analytics Market, it is good to evaluate the Value Index from Ventana and the Forrester Wave™ as well.

If you are on Twitter, you should check the following hashtags; #BalancedBI, , There are some interesting discussions going on.

Daan Bakboord

So Oracle did not make it to the Magic Quadrant for Business Intelligence and Analytics Platforms?

MQ for BI & Analytics - 2016Earlier this month Gartner released a new version of the Magic Quadrant for Business Intelligence and Analytics Platforms. This release has caused a lot of noise in the Analytics Market. Vendors have changed quadrants or even disappeared completely (eg. Oracle).

Traditionally, the Analytics Market is characterized by IT-led buying. Over the last years there is a transition ongoing towards Business-led buying. IT-led buying focusses on governance, consistency and scalability. Business-led buying on the other hand has a focus on speed and discovery.

So why did Oracle disappear from the Magic Quadrant? Oracle and Gartner have a different view / opinion when it comes to Business Intelligence & Analytics.

Gartner writes the following in their Summary; “The BI and analytics platform market’s multiyear shift from IT-led enterprise reporting to business-led self-service analytics has passed the tipping point. Most new buying is of modern, business-user-centric platforms forcing a new market perspective, significantly reordering the vendor landscape.” 

Oracle’s Business Analytics Product offering focusses on IT as well as the Business. It’s Oracle’s vision to support both to be able to realize the full potential of Analytics.

Since Oracle acquired Siebel, Oracle offers a platform; OBIEE, which supports the IT-led buying. Over the last years Oracle experienced a lot of competition from companies like QlikView and Tableau. These companies have successfully targeted the Agile / Self-Service preferences of the Business. Oracle was not able to compete with these companies. Last year Oracle has launched their Oracle Data Visualization (Visual Analyzer) product. Visual Analyzer is Oracle’s answer to QlikView and Tableau. Now Oracle is able to service both IT as well as the Business.

This is the difference between the view / opinion of Gartner versus Oracle. Gartner focusses in its Magic Quadrant for Business Intelligence and Analytics Platforms on the Business and Self-Service. Oracle focusses both on IT and the Business. Oracle offers OBIEE (IT) and Visual Analyzer (Business) On Premise or BICS (IT) and Visual Analyzer (Business) in the Cloud. 

The confusing thing might be that Gartner shifted its focus to solely Business Intelligence and Analytics for the Business, while the name of the Magic Quadrant still is the same as last year.

For me it is not a matter of right or wrong, but I think it is good to see things in context.

I believe in Oracle’s strategy when it comes to Business Intelligence and Analytics. If necessary or desired, I would be happy to put things in context.

Daan Bakboord

Het bestaande hoeft zich nooit te verdedigen en het nieuwe moet zich constant verantwoorden.

Een keer in het jaar sta ik samen met Eric van ‘t Zelfde op een hockeyveld in Schiedam. Wij maken beiden deel uit van een illuster gezelschap; Semper Stultior ’96. Elk laatste weekend van augustus komen wij samen om te strijden om de Japie Cup. Naast het feit dat we een hoop lol maken biedt dit ons de kans om Japie (een gezamenlijke vriend) te herdenken.

Afgelopen weekend heb ik de tijd genomen om Eric’s boek; Superschool te lezen. In Superschool vertelt Eric zijn levensgeschiedenis en beschrijft hij hoe hij en zijn team binnen vijf jaar een slechte school in Rotterdam Zuid promoveren naar een van de beste scholen van Nederland.

Superschool is een boek voor iedereen. Iedereen heeft in welke vorm dan ook ‘iets’ met het onderwijs te maken. Voor mezelf als vader is het leerzaam om te lezen hoe het onderwijs eruit kan zien vanaf de andere kant. Gek genoeg heeft het boek ook raakvlakken met mijn professionele leven als Oracle Business Analytics Consultant. Zaken als leiderschap, passie en ondernemerschap zijn onmisbaar in mijn werk. Ook met IQ, EQ en accu kom ik een heel end.

Een zin uit het Superschool is mij bijgebleven. Het is wellicht niet de kern van het verhaal, maar voor mij wel heel herkenbaar;  

“Het bestaande hoeft zich nooit te verdedigen en het nieuwe moet zich constant verantwoorden.”

Bij de veel van onze klanten waar ik binnenkom, wordt een bestaande Analytics omgeving vervangen door een nieuwe. Uiteraard heb ik een gekleurde mening. Ik ben besmet met het rode Oracle virus. Uiteindelijk maakt het niet uit voor welke oplossing of toepassing gekozen wordt. Als de keuze eenmaal gemaakt is, moet je er het maximale uit halen. Technisch is wat mij betreft alles mogelijk. De uitdaging zit hem vaak in de verandering. Het slagen van een nieuwe Analytics omgeving wordt bepaald door het gebruik ervan. De bestaande omgeving heeft zich al bewezen. De waarde van het nieuwe moet nog blijken.

De Oracle Business Analytics strategie is gericht op 3 pijlers

  • See the Signals –> Visual Analytics in every solution 
  • Sprint to Innovation  –> Cloud first
  • Scale the Insights –> One integrated platform

Deze strategie vertaalt zich in de volgende producten (On-Premise en in de Cloud)

Uw bestaande Analytics omgeving heeft zich wellicht al bewezen. Toch ben ik ervan overtuigd dat Oracle’s nieuwe aanbod waarde kan toevoegen. Ik kom graag met u de mogelijkheden van het Oracle Business Analytics aanbod doornemen.

Extracting Data from BICS / Apex via RESTful Webservice

A few days ago, I read the following post; Extracting Data from BICS / Apex via RESTful Webservice on the Oracle A-Team Chronicles website. I tried the example to see how things work.

Cocoa Rest Client

In the blogpost is referred to cURL to test the REST-endpoints. I have been testing this out on a Mac and used; Cocoa Rest Client.

If you test the created RESTful Service Handler, you get a window with a JSON formatted result set. You can copy the url.

Test_SQLWorkshop

Enter the copied url in the Cocoa Client.

Test_Cocoa

You will find the result in the Response Body of the CocoaClient. Don’t forget to enter your credentials to your BICS environment.

Oracle BI Cloud Service (BICS) – Planned Upgrade for 10-July-2015

As from the 10th of July the Oracle BI Cloud Service environment will be upgraded. Looking forward to the new features and enhancements to the Oracle BI Cloud Service. Find below a list of things we can expect.

Fresh new look to Oracle BI Cloud Service

Improved design that’s simple to navigate and easy to use. Includes a brand new Academy to help you get the most out of Oracle BI Cloud Service.

View your data in a heat matrix

Use a heat matrix view to see a two-dimensional depiction of data where values are represented by a gradient of colors.

Visualize geographical data on maps

Use a map view to display data on a map in several different formats and to interact with the data.

Manage your data files

Review, download, and delete the data files you’ve uploaded for analysis. Quickly see whether you’re close to reaching your quota.

Enhancements to Data Modeler

  • Let Oracle BI Cloud Service recommend fact and dimension tables when you first start building the data model.
  • Override the aggregation set for a measure for one or more dimensions.
  • Sort attribute values by a different column.
  • Define variables that return multiple values.
  • Programmatically clear data cached for your model through new REST APIs.
  • A copy of your data model saves automatically when you publish changes to the model. This makes it easy to recover to a previous version if something goes wrong.

Enjoy.