Once again, this article is inspired by a question on one of the many LinkedIn.com groups. As these are only viewable to members, I’ll confine myself to a general link to the site. The subject was what might be the best BI tool for a particular project. I was enormously encouraged by the number of people who said that this was putting the cart before the horse.
My experience is that while having a snazzy BI tool (Cognos PowerPlay being the one I have most often used) in place can win you plaudits, this is only because it is sitting on top of a warehouse that embodies the business information that the organisation needs. The four keys to a successful BI implementation are: –
- Forming a deep understanding of the key business questions that need to be answered.
- Piecing together the various elements of corporate data that relate to these questions (assuming that they exist) and establishing how they are linked together.
- Working out how to transform the data to meet the questions.
- Managing the behavioural changes required to ensure that use of BI becomes pervasive.
The above steps (which are typically iterative) form the foundation of a BI initiative that actually adds value. If you have followed them assiduously, then whatever front-end tool you choose, your users will like what they see*. You can argue about the precise figures, but 80-90% of your overall development project will relate to the three steps above and only 10-20% to layering a BI tool on top of your data.
When I presented at the Informatica World 2005 in Washington, DC I tweaked Thomas Alva Edison’s famous aphorism to suggest that: –
Business intelligence is 10% presentation and 90% integration.
Taking my admitted cheesiness to one side, I stand by this observation.
* Before I am accused of being agnostic about different BI tools, I should stress that they are not all the same, some are better than others and it is worth putting in the effort to pick the right one for your organisation. Instead my point is that if you do not have the correct data and business foundations, it is irrelevant how good your BI tool is. Equally, if you do have these underpinnings in place, then most BI tools will at least be adequate.
These were my initial comments on the LinkedIn.com thread:
If you are a member, you can view the discussion here.
Hello, Peter!
I jumped to your side through Linked In connection and really like your very common sence and no-nonsence approach which is clear and based on reality. Not much of this nowadays unfortunately.
You a very right about this 90 and 10 division. One other addtion I would make – for BI it is absolutely necessary that someone at the top ( or even better ) many people at the top are truly interested in the resulting data and its quality. Interested to the extent that they will be looking at it, knowing ( at least in general) what it means and what goes into it, and using it for the business management.
As I am now somewhere between CIOs and “real life” people I can clearly see what garbage and what mess can be happening on middle layer. Not possible to have a good data on top with those things down.
And until someone wants to make sure that all layers are in order and not afraid to find the truth – no good BI is possible.
Of course we can use BI just for report of invoices by customer and materials – but then should we actually call it buisness intelligence? Nothing new there – existed in thouthands years.
So – will fully depend on the company and management desire to go into this difficult path and emerge with clarity.
Galina,
Thank you for your comments. You are of course right about the need for a commitment to BI at the top of an organisation. If that does not exist, then a key role is of BI advocate, selling the idea of BI and explaining the value that it can unlock. I have performed this role and have found that it is important to find allies and to build coalitions to help promote your ideas.
On the issue of layers complexity and good data, it is interesting that I was recently thinking about this area and offered a slight twist on orthodoxy in this recent article.
Thank you for your input.
[…] with the general approach that I laid out in an earlier article, my two first objectives were to understand the needs of the various business groups across the […]
[…] echoing my comments on BI tools in general, I think an attractive looking dashboard is really only the icing on the cake. The cake itself has […]
[…] The main fly in the ointment with respect to outsourcing business intelligence is the fact that good BI is reliant upon four things (see also BI implementations are like icebergs): […]
[…] data sets and to more modern systems (this sits under area two of my model of BI development – see BI implementations are like icebergs). This is not an exercise that is very easy to estimate in advance. Indeed it may not be possible […]
[…] See also: BI implementations are like icebergs […]
[…] glisters is not gold” – some thoughts on dashboards. In this I comment: “[…] echoing my comments on BI tools in general, I think an attractive looking dashboard is really only the icing on the cake. The cake itself has […]
[…] of a BI implementation (I cover these in more depth in several places on the blog, including BI implementations are like icebergs and the middle section of Is outsourcing business intelligence a good […]
[…] an earlier article, BI implementations are like icebergs I argued that, in BI projects, the technology – at least in the shape of front-end […]
[…] cost of the BI tools themselves are only a minor part of the above (see also, BI implementations are like icebergs). Of course any savings made on tools may make funds available for other parts of the project. It […]
[…] I will come back to my four-pillared approach and emphasise the first pillar. There is an imperative to: Form a deep understanding of the key […]
[…] may have strong technological elements (though the former certainly has more than the latter, see BI implementations are like icebergs), but Knowledge and Wisdom imply a more human angle; even in these days of automated […]
[…] BI implementations are like icebergs […]
[…] Business Intelligence, I see some pertinent parallels. In a series of previous articles (including BI implementations are like icebergs, “All that glisters is not gold” – some thoughts on dashboards and Short-term “Trouble for […]
nice article – though I would add another dimension to the iceberg analogy: data quality. BI is useless without data and misleading without cleansed and realiable data.
Thanks for the comment Rob.
I’d have Data Quality under the behavioural section. See also: http://peterjamesthomas.com/2009/02/11/using-bi-to-drive-improvements-in-data-quality/
Peter