Thursday, May 22, 2008

Business Intelligence:”I’m not dead.”

If you are a fan of Monty Python, you will recognize this line from “Monty Python and the Holy Grail”.

I had a bit of a positive experience today with a client that caught me a bit off guard. It may be because there are times in this industry where you feel business intelligence has become a commodity. Seems like every organization owns at least one, and in most cases, multiple BI tools. There is pressure in the consulting industry from offshore resources, which I am personally not convinced about for BI applications. So needless to say, at times I am a bit jaded.

So that brings me to today. I am working at a client to build out a new reporting architecture. It’s a pretty significant size initiative and will replace numerous disconnected reporting packages that are managed through a hodge podge of manual processes. We are using the Cognos 8 reporting platform, specifically Report and Query Studio. As part of design, we have been prototyping a reporting package that is currently being done in Excel and packaged into PowerPoint. There are a lot of charts, formatting and commentary that goes into the package. Thus far, I have been thoroughly impressed with the Cognos tools to replicate the current set of reports. But the shocker was the level of excitement from business users who are currently saddled with creating these reports manually. And on top of that, the flexibility to expose the dimensional model would support a majority of the ad-hoc requests that the group receives.

So the point is I guess people are still not getting what they can from their investments in business intelligence and corporate performance management technologies. A majority of organizations are still in the 80/20 position of spending 80% of their time gathering data, creating highly formatted reports manually. If that is the case, it is hard to be called a commodity. I guess the software could be since the tools are there, but organizations haven’t yet realized the value from the investments.

There is another scene from the Holy Grail that draws parallels to the current state of BI.

King Arthur: Go and tell your master that we have been charged by God with a sacred quest. If he will give us food and shelter for the night, he can join us in our quest for the Holy Grail.
French Soldier: Well, I'll ask him, but I don't think he will be very keen. Uh, he's already got one, you see.
(Replace King Arthur with software sales rep and Holy Grail with BI tool)


Business Intelligence Jim said...

Interesting thoughts, got to love Monty Python although I must admit, I never really considered comparing the Holy Grail to Business Intelligence

Joaquin said...

why not save your customer a ton of money and use an open source BI solution? We are using Jaspersoft for ad hoc reporting and analysis. We started with the open source versions and moved into supported releases after our POC.