Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Data Warehouse Failure Statistics

5 posters

Go down

Data Warehouse Failure Statistics Empty Data Warehouse Failure Statistics

Post  YoungBuddy Wed Nov 24, 2010 5:34 am

Is there any recent study / statistics / surveys on data warehouse project pitfalls and risks ?
Your help is truely appreciated.


Best Regards,

YoungBuddy

Posts : 8
Join date : 2010-07-14

Back to top Go down

Data Warehouse Failure Statistics Empty Re: Data Warehouse Failure Statistics

Post  warrent Wed Dec 01, 2010 8:26 am

I don't have any current references, but Gartner and TDWI have published papers on this topic in recent years. I think some of the other industry analysts have as well. In general, the main problems always seem to be soft in nature: lack of business requirements, poor business sponsorship, lack of user involvement, bad/no methodology, etc. I'm sure this comes as a shock to anyone who's read anything we've ever written. ;-)
--Warren
warrent
warrent

Posts : 41
Join date : 2008-08-18

Back to top Go down

Data Warehouse Failure Statistics Empty Re: Data Warehouse Failure Statistics

Post  hang Wed Dec 01, 2010 9:29 pm

warrent wrote:In general, the main problems always seem to be soft in nature: lack of business requirements, poor business sponsorship, lack of user involvement, bad/no methodology, etc.
Three Ps - Personalities, politics and Power struggles. I have just been victimised by these forces in my last two BI projects when trying to apply best practices. You may not believe it, using Kimball's mini-dimension concept to address multimillion monster dimension could lose your job only because some DBA did not like the concept, even though it has delivered a perfect solution for the business.

Most BI/DW projects failed not because of technical reasons, but because of political reasons. Huge amount of money can be wasted for the political correctness while little effort can be put to address core issues.




hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Data Warehouse Failure Statistics Empty Re: Data Warehouse Failure Statistics

Post  Jeff Smith Thu Jan 06, 2011 12:16 pm

I think it always helps to bring someone from the Mainframe world to head up a DW, which has been the case in the last 2 places I worked. And then rely on guys from the transaction side to dictate design.


Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

Data Warehouse Failure Statistics Empty Re: Data Warehouse Failure Statistics

Post  hang Thu Jan 06, 2011 6:09 pm

Why should people from Mainframe world and transaction side dictate the design to help. I thought their comfort zone is in legacy system not BI/DW world. I believe the trust should be on BI/DW professionals to deliver viable BI solutions.

Whenever a BI/DW design is dictated by knowledge only applicable in old word, the architecture becomes the recipe for failure. Mainframe knowledge is good skill, but it's very old, older than Client/Server technology which is the foundation of RDBMS. Similarly, relational thinking from transaction side is very useful in operational system but needs to be replaced by dimensional thinking when it comes to the BI/DW world.

I am not saying people from old world cannot become front runners in the new world, and actually most, if not all, best BI/DW experts have evolved themselves from the old world. All I am saying is people need to realise the paradigm shift between the old and new and learn from the best practice to become champions in the new BI/DW world. Unfortunately not many people are consciously doing that when things are out of their comfort zone, and consequently their knowledge and skills become a detrimental force in the new world.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Data Warehouse Failure Statistics Empty Re: Data Warehouse Failure Statistics

Post  BoxesAndLines Fri Jan 07, 2011 1:09 pm

LOL, Hang, I was hoping Jeff's comment was sarcasm. I know it can be difficult to determine on these boards.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Data Warehouse Failure Statistics Empty Re: Data Warehouse Failure Statistics

Post  hang Fri Jan 07, 2011 5:31 pm

Hoops! Thanks B&L for reminding me, and sorry Jeff, for the lack of my sense of humour.

Well, it couldn't be better timing as I just told my friend that I have improved my English writing skills through the forum. Obviously it's time for me to focus on listening skills. However you see the point, switching to something new is always challenging as I originally came from non English background, but I am getting there.

So let me rephrase my previous comment as an extension to Jeff's sarcasm.

Yeah, and DBA should remain the king of DW without any skill surgery, as they have ruled the Database World for so many decades.

BTW, I have just also changed my profile so that people would not pick on my lack of humour sense.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Data Warehouse Failure Statistics Empty Re: Data Warehouse Failure Statistics

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum