How BI can help your reputation and more…

It concerns me to see several car manufacturers recalling their vehicles to carry out urgent safety repairs.

Not only is there a massive cost involved in such a process, but the impact on a firms reputation can be far higher.

A number of the manufacturers involved have previously been held in high regard. The actions taken now by these manufacturers in resolving these problems will determine future consumer buying decisions.

And this leads me to my point about BI.

If you have BI, and you have a metric which monitored problems reported by owners, wouldn’t there have been an early opportunity to spot that something was going wrong? Perhaps an ‘outlier’ on that chart or scattergram which suggested something was looking odd. Perhaps an alerter which indicated a higher percentage of faults on a particular model or range than the norm.

It’s when you start to visualise these outliers – those items which sit outside of the normal boundaries, that you should start paying attention. And I say visualise, because you won’t spot these outliers too easily on a table of values. You need a visual prompt, be it a chart or an alerter.

Another case of leveraging your BI tools to spot trends. I read somewhere, and forgive me for not providing the source, that a large Wall Street firm spotted a worrying trend in mortgage defaults in the US, long before the worst of the financial crisis took hold. It promptly decided to withdraw its exposure from that part of the market. It probably saved their firm from going under.


New challenger to Business Objects EDGE

IBM have recently announced the release of IBM Cognos Express – “…an all-in-one business intelligence and planning solution specifically designed and priced for midsized clients.”

Targeting the mid-market space, the product appears to be a direct response to the success of the SAP Business Objects EDGE product. Perhaps, confirming that the mid-market space is a vast potential untapped market, IBM Cognos have released their product in three flavours:

  • Reporter – for ad hoc reporting
  • Advisor – for dashboarding KPI’s
  • Xcelerator – in memory analytics

IBM acquires SPSS

Building on its recent purchase of Cognos, IBM has once again opened the purse strings for yet another BI acquisition.

News reaches the bobjblog newsdesk that IBM has agreed to acquire SPSS for $1.2bn.

SPSS is a worldwide provider of predictive analytics software and solutions. Its software is used to access, manage and analyze various types of data to spot ways to improve customer loyalty, decrease marketing costs, minimizing risk and otherwise improve business performance.

As predicted by Doug Henschen in his Intelligent Enterprise article of Dec 18 2008 and more recently in June 4th 2009, IBM finally tied the knot with its analytics partner of choice.

Is Microsoft winning the BI race?

I just finished reading an interesting article written by Oudi Antebi of Panorama Software.

In it he states that the Microsoft BI path has been somewhat confusing over the past few years – what with their purchase of Proclarity, and it’s subsequent withdrawal (please bring it back!), it’s development of Performance Point Server, and it’s subsequent integration into Sharepoint. (And possibly PPS revival). This has left consumers and consultancies wondering whether to invest in the Microsoft BI stack at all.

However, Oudi points out that Microsoft may be following the pareto rule of 80/20 and trying to win the hearts of 80% of the BI population by integrating basic BI features into its Office and MOSS products. It is then happy to leave the remaining 20%, otherwise known as the power users, to use software from the likes of Panorama (shameful plug Oudi), Oracle and SAP Business Objects.

Oudi’s article is interesting on several levels.

Many of you will know that I am a fan of several BI applications – Panorama, Tableau and Qlikview. These powerful applications provide the end user with a simple GUI interface and allow you to really dig down into your data and present it in a wide variety of ways. The resulting output, I feel, is at the cutting edge of BI reporting.

Several vendors are looking at offering their wares over data you may (one day?) hold in the ‘cloud’. No doubt the cloud will grow in popularity over time and it removes the cost of purchasing and maintaining hardware on site. Google is not far behind either. It has been working on several initiatives including Google Wave and Google Squared. Google has in fact worked closely with Panorama on several projects involving its Google spreadsheet application. Google also bought the rights to the Gapminder graphical application which allows you to view you data over several dimensions over a moving time period. Fantastic product and demonstrated like no other by Ola Rosling in several conferences. I wrote about a presentation he done at TED which was unbelievable. But I digress.

The fact is that Oubi thinks that this is a race with one winner.

I disagree.

Microsoft, with its current BI stack, will not win the BI race. In fact, I don’t think there will be or can be a winner. BI means different things to different people. BI is vital to all organisations, and will one day be used by every employee at every level. From basic tabular reports, to graphs to dashboards. We are all living in an age where we are confronted by mountains of data. Data storage is growing exponentially. Simply look at the size of your home storage, and the volume of music or photos or files that you may store. How does that compare to your system of 5 years ago? And imagine the data being collected by telecoms companies, retail companies, reward schemes, etc. So any system which can aggregate that data, cleanse it and present it in a form which is accurate, timely and relevant will be of enormous value to an organisation.

There are people who prefer to see tables of data for which Excel is an excellent option. There are others who want to track metrics and KPI’s, and several applications, including Xcelsius allow you to do just that. Other people or power users may want to drill down into the underlying data, to really determine the causes of a strange number – an outlier. Several companies are offering applications on mobile devices such as the iPhone, as discussed here by Timo Elliot. Again, this advance will satisfy a small subset of the BI community.

Price also plays an important part, and this is where Microsoft will win many hearts and minds, and perhaps more importantly, the signature on the purchase order. A number of BI vendor solutions are very expensive indeed. Others are more realistically priced, and several Microsoft solutions may be used at no additional cost depending on the type of licence you hold. With Office being the predominant application on users desktops, embedding simple BI functionality into Excel is a no brainer. Perhaps an organisation is using Sharepoint as an internal document portal. Well, now you can put up some dashboards using PPS functionality.

While I think there is a big place for Microsoft in the BI world, I certainly don’t think it is going to be the ‘winner’. Smaller, more nimble BI software companies, are pushing the boundaries of what can be achieved with BI, offering us with ever more imaginative ways of viewing our data and extracting the key information we need to know. Several of the larger vendors offer organisations a strong case to use use their complete stack, from database, to ETL and data cleansing, to creating cubes/universes, reports and right through to dashboards and KPI’s. A one stop solution from one of the largest BI vendors.

These vendors are focused 100% on BI.

Not Office.

Not Windows.

Not XBox.

Just BI.

And having a laser like focus on BI will give these organisations the edge to develop the very best products on the market.

%d bloggers like this: