Self Service Business Analytics is great but there is more.

Last week I read an article from Bernard Marr about why #SelfService #BI, #Analytics and #Reporting might not be such a good idea.

There is a growing need with Business Users to do things themselves. The world is changing fast and there are situations where people want to act quickly to stay ahead of the competition. In this situations the use of various (sources) of data is essential. Some of this data is available in environments managed by IT. This data is modelled, governed and validated. Everyone who looks at these figures will get the same results; ‘One version of the Truth’. But what if there is additional data necessary? What if Sales data needs to be combined with figures about vistors or weather data. This kind of data normally is not available in an IT managed Data Warehouse. Still this data can be essential to make deciscions about increasing Sales based on visitors and weather conditions. In these case it might not be desirable to wait for IT before they combine and deliver the different data sources. Self Service capabilities would offer a Business User the tools to analyse this data.

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

Early this year there was a lot of noise about the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms. I wrote about the differences of opinion between Oracle and Gartner.

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 realise the full potential of Analytics.

Oracle’s Business Analytics Product offering

From what you can see from the picture below is that Oracle’s Business Analytics offers a Business Driven Data Visualization Suite. This suite includes products like Visual Analyzer and the Oracle Data Visualisation Desktop (DVD). Read some more about Oracle Data Vizualisation License Pricing here. Next to the Business Driven Data Visualization Suite Oracle offers IT Supported integrated platforms like OBI 12c and the Oracle BI Cloud Service (BICS).

Oracle’s strategy is to deliver the Oracle Business Analytics Product offering both On-Premise as well as in the Cloud. It does not matter where you use Oracle’s products, they are build on the same footprint.

One of the great advantages of the Oracle Business Analytics Product offering is that Oracle is able to combine IT curated data and additional data at runtime. If we go back to the previous example of the Sales Data combined with figures about vistors or weather data. Oracle Business Analytics allows you to upload a sheet or connect another Data Source. A Business User is able to connect the Sales data from the IT Supported Data Warehouse with external Data Sources (visitors, weather). All of this without interference of IT.

See the picture below. There is one Source of Truth where we can retrieve Revenue Data. The Oracle BI Server’s Computation Engine allows to combine Revenue Data with personal Forecasts. Both Data Sources can be combined into one visual. No need to export data to e.g. Excel and analyse data there.

 

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

Originally written for LinkedIn.

Oracle Data Vizualisation License Pricing

One of Oracle’s focus points within the Oracle Business Analytics Suite is Oracle Data Visualisation. The Oracle Business Analytics Strategy is based on three pillars. One of these pillars is; “See the Signals”, Visual Analytics in every solution.

It doesn’t matter whether you run Oracle Business Analytics in the Cloud or On-Prem, Stand-alone or integrated in the platform, Oracle Data Visualisation is available.

oracle-business-analytics-product-landscape

A few months ago you could have been able to read a blogpost about Oracle Data Visualisation License Pricing. One of the products within the Oracle Data Visualisation offering is the Oracle Data Visualisation Desktop (DVD).

Is it possible to buy only DVD?

We had a discussion about this question in the #obihackers IRC channel. The answer to the question wasn’t as easy as the question itself or maybe we made it more difficult then necessary. Basically it comes down to the following:

You cannot buy “only DVD”. A customer buys Oracle Oracle Data Visualisation (DV) License. The fee is $1250 per named user (minimum lowered to 1). For this the customer gets both  (1) the ability to use DV with OBI 12c if they have it and (2) the ability to use DVD. So if the customer does not have OBI 12c then they effectively do buy “only DVD”.

Why would you buy “only DVD”? That’s the question. It might be better to start with a DVCS subscription and start from there.

If you want to know more about the Oracle Data Visualisation offering, the following resources (thanks to Mike Hallett from Oracle) will be helpful:

Cheers.

Daan

OTN Appreciation Day : Dual Table

otn-appreciation-dayI have been working with Oracle products for about 20 years now. One of the great things about Oracle is the Oracle Community. Central platform within this community is the Oracle Technology Network (OTN). I have been frequenting OTN loads of times (downloading software, exchanging knowledge on the forums, etc. ). A lot of people I know in the Oracle Community, I have met via OTN.

Today I read the OTN Appreciation Day announcement on Tim Hall’s blog.

“considering OTN is all about community, I figured it would be fun if we got as many people as possible to write a small blog post about their favourite Oracle feature and we all post them on the same day”

I immediately thought about the Dual Table in the Oracle database.

Dual Table

What I like about the Dual Table, is that something which looks so simple can be so powerful. You can select the date, the length of a string, the result of calculation and so on. One simple table, with just one varchar dummy column is able to tell you almost everything you want.

I can illustrate how powerful the Dual Table is by a short anekdote. The story could be a little bit different but it’s all about the scope. One of my former colleagues (I won’t tell his name) wanted to test part of his code. Therefore he decided to insert a record in the Dual Table. I think it was in the Oracle database version 7 / 8 timeframe. It might have been a smart move in his mind, but it was disastrous for the application running. Very slowly the application collapsed. The application code expected one row when selecting from the Dual Table. It took some time to realise that the Dual Table contained an extra record. As far as I know the functionality of the Dual Table has changed since then, but I guess there is no need at all to mess with the Dual Table.

Curious what other people have to share on OTN Appreciation Day, check here.

Cheers,

Daan

Wat hebben kippen en de Cloud met elkaar gemeen? (Dutch)

Binnen de BIWA SIG worden diverse onderwerpen en thema’s behandeld binnen de vakgebieden Business Intelligence (BI) en Data Warehousing (WA). In Oracle termen vertaalt zich dat in Business Analytics en Data Integration.

Wilt u het antwoord weten op bovenstaande vraag? Kom dan naar de eerstvolgende BIWA SIG (Special Interest Group) meeting van de OGh.

Tijdens deze avond zullen er twee producten (Oracle BI Cloud Services en Oracle Data Visualization) uit de Oracle Business Analytics Suite aan bod komen.

De volgende onderwerpen zullen behandeld worden.

Qcompany presenteert; “Chickens in the Cloud”

Oracle Business Intelligence Cloud Services werd bij 1 van de grootste fastfoodketens geïmplementeerd in minder dan 2 maanden door Qcompany B.V.

Een presentatie over hoe je succesvol een Oracle Cloud Business Intelligence Platform realiseert op miljoenen rijen data.

BI Modernization (hands-on) Workshop

Samen met Oracle NL organiseren wij een hands-on workshop over BI Modernisering. Doe mee aan deze en ervaar vanaf uw eigen laptop (liefst 8 GB geheugen of meer) met de onlangs vrijgegeven Data Visualization Desktop wat Oracle Data Visualization voor u kan betekenen!

De meeting zal gehouden worden op dinsdag 11 oktober 2016 aanstaande

Volg deze link voor meer details en inschrijving.

Daan Bakboord

Separate the Signals from the Noise

Earlier this year I wrote two blogposts about the publication of Gartner’s Magic Quadrant for Business Intelligence and Analytic Platforms.

Without choosing sides between Gartner or Oracle, it is clear that the landscape of analytics (and the tools and techniques to support analytics) is changing.

Today I viewed a webcast where both Rita Sallam (Research Vice President Business Analytics and Data Sciences @ Gartner) and Rich Clayton (Vice President Business Analytics @ Oracle) express their views on:

  • The current and future state of the BI/Analytics market
  • Oracle’s answer to the evolution of this market
  • Some of the types of Analytics use cases
  • How to see the signals in your data and discover the answers

Find the link to the webcast below:

The Industry Experts’ Guide to the Changing Landscape of Analytics

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

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