The Myth of Self-Service Analytics

Recently, I read an article titled ‘The Myth of Self-Service Analytics’ (http://www.perceptualedge.com/blog/?p=2467) which discusses the danger of jumping on magic solutions based on colourful software tools which, supposedly, can enable everyone and anyone to analyse information and business data. My favourite gripe is about Self-service BI because there is more than meets the eye when it comes to this topic. There are several points to keep in mind while discussing Self-service BI because they are, as usual, not black and white but grey.

 

  1. BI companies want to sell their Self-service BI (SSBI) tools as widely as possible.
  2. The target group for SSBI tools is the management level. Data analysts and information professionals are preferably left out of the sales process as they understand what is really needed to make sense of data and present information in an appropriate manner.
  3. Self-service BI can NEVER work without a data warehouse of some kind. This means that the whole concept is, to a point, a deception. “Here is your tool, here is your database with 25 thousand tables. Give me sales figures and a forecast for the next year tomorrow.” It goes without saying that this is an unrealistic scenario.
  4. SSBI can work for superusers who work with a set of well-defined data. Nevertheless, there is always a risk of more than one version of the truth under those circumstances. Of course, that danger is also present when data scientists and information professionals are involved but the risk is greatly reduced.
  5. SSBI has been around for a long time but not necessarily under that name. DSS – DW – OLAP – Analytics – SSBI. These are not necessarily exactly the same concepts but there is a very big overlap. To a certain extent making users self-sufficient has always been the goal of BI and it is certainly possible but it doesn’t happen without a solid foundation and that foundation is your data warehouse.

Oracle Day 2015 – Simplify IT

In association with Miracle ehf, Oracle is pleased to invite you to a 1 day workshop under the banner of “Simplify IT”. You will be able to meet with top Oracle experts and share our vision on different subjects such as Digital Engagement, Cloud, Oracle Storage and Database Ecosystem, Software in Silicon and Big Data. We will also bring you the latest news and developments from Oracle Open World in San Francisco.

The day will consist of 1.5 hours sessions with breaks in between, giving you the flexibility to choose the talk tracks that are relevant to you and your business. Sessions will include both overviews and technical deep dives with demos. We will also have breakout and networking sessions in between, where you will be able to address your questions directly with an Oracle Specialist or network with your peers. You can find further information about the agenda on the workshop’s web site.

The workshop is free of charge but we ask you to register in advance. We will provide lunch and refreshments throughout the day.

We look forward to seeing you!

od2015

Clever feature in Oracle

I came across an article that describes a mechanism in Oracle that automatically performs a function that has traditionally been implemented “manually”. It caches results from functions so they only have to be called once for each value sent to the function. This works for version 11.1 and newer and version 11.2 offers some improvements. The benefit of the way Oracle implements this is that the mechanism works across sessions, i.e. if function f(x) is called in session 1 then the function does not have to be called again in session 2 because the result is cached if RESULT_CACHE is correctly configured.

The article offers a very good explanation of these concepts: https://oracle-base.com/articles/11g/cross-session-plsql-function-result-cache-11gr1.

We’re hiring!

We are looking for a programmer, a software expert or a software engineer to work with us. Please call us at +354-544-5900 or email us at miracle@miracle.is if you’re interested and if you think someone else might be interested you can share our post on Facebook (Icelandic only, sorry).