Tue 26 Sep 2006
What They Didn’t Tell You About Data Warehousing
Posted by Nishith under BI, Data Mining, Analytics , Data Warehousing[28] Comments
Most Data Warehousing projects fail. As many as 70-80% as per some claims. Still, no one talks about them.
Data Mining, Analytics and BI roll-outs are unlike any other project your organization may have undertaken. Political and non-technical issues can derail the fragile project which is anyway struggling to handle ambiguous and constantly changing requirements.
Mark Demarest, in his classic 1997 article The Politics of Data Warehousing says:
Data warehousing projects are frequently side-tracked or derailed completely by non-technical factors, in particular the political treaty lines within the firm, and the politicized nature of data itself. Because data warehouses are infrastructure for sociotechnical systems (STSs) within the firm, politics and the exercise of power are inherent in data warehousing projects, and data warehouse designers have to adopt work practices and methods from non-technical disciplines, think of themselves in new ways, and employ some fairly sophisticated qualitatively sociological methods in order to optimize the chances for successful deployment of data warehouses.
The Politics of Data Warehousing also lists down 10 warning signals to detect politicization of the project, and 10 countermeasures – essentially the recipe for delivering on the project promise.
Larry Greenfield, in a more recent article titled Data Warehousing Political Issues identifies three common threads as:
1) Data warehousing imposes new obligations whose responsibilities are unclear
2) Data warehousing requires changes in processes that an organization is comfortable with
3) Data warehousing requires agreement on some, but not all, definitions of data.
Larry classifies the political issues into those that are within the IS organization (IS to IS), those that are between IS and the users (IS to Users), and those that are between users (User to User). Click here to read Data Warehousing Political Issues.
And don’t miss the article Data Warehousing Gotchas, listing some little known nuggets of wisdom and experience that can save your project. As Larry says, “Forewarned is forearmed!” Click here to read Data Warehousing Gotchas
November 3rd, 2006 at 4:13 am
Yes, more than 70% of data warehouse project fail. I’m trying to talk about some of the reasons for this failure in my new data warehouse blog. I would appreciate any comments.
http://dwhblog.org/blog/index.php/2006/11/02/welcome-to-my-real-world-experience/
April 8th, 2008 at 9:03 am
You said that “Most Data Warehousing projects fail. As many as 70-80% as per some claims.”…
I would like to know where this statistic is coming from…
This post talks about the lack of proof on statistics and ‘failure predictions’ to BI initiatives: http://www.b-eye-network.com/blogs/imhoff/archives/2005/03/failure_of_data_1.php
October 14th, 2008 at 9:31 am
Generic pharmacy
Buy Rx drugs from our generic pharmacy
August 6th, 2010 at 11:34 am
I’ve read that stat as well, but can’t remember where now.
On the open source front… Open Web Analytics (http://www.openwebanalytics.com) implements a star-schema based warehouse for web analytics data. The pre-defined schema takes a lot of risk out of building a warehouse from scratch.
August 22nd, 2011 at 12:05 pm
Learning database and managing them has always been my interest. medical writing servicesThere can be some research papers written on this topic as well.
December 19th, 2011 at 11:38 am
This site is good because they give us a new thing and new ideas and new topic how good all of they are we should appreciate them because of these good thing.
December 27th, 2011 at 7:14 pm
The information is especially helpful to someone like me
http://www.kenyanmba.com/data-analysis-services-in-kenya/
March 22nd, 2012 at 12:46 pm
You are here probably because you are looking for a scan tool 100Z
March 27th, 2012 at 11:10 am
I don’t have any words to appreciate this post…..I am really impressed ….the person who created this post surely knew the subject well..thanks for sharing this with us.EMDR Therapists
April 1st, 2012 at 7:35 pm
I really love your post here! Thank you for sharing!
April 5th, 2012 at 4:43 pm
I’m so happy to read this. This is the type of manual that needs to be given and not the random misinformation that is at the other blogs
April 5th, 2012 at 6:31 pm
I certainly enjoyed the way you explore your experience and knowledge of the subject! Keep up on it. Thanks for sharing the info.
April 11th, 2012 at 5:25 pm
This is one of the most incredible blogs Ive read in a very long time. The amount of information in here is stunning, like you practically wrote the book on the subject. Your blog is great for anyone who wants to understand this subject more. Great stuff; please keep it up!
April 12th, 2012 at 1:05 pm
This is my first visit here. I found some really interesting stuff in your blog especially this discussion and VigRX Plus one of the most complete herbal enhancement pills help about new happening. Here I have found the information for which I was looking for long time.www.ordervigrxplusonline.com
April 13th, 2012 at 4:19 pm
Seriously! I get pleasure from objective you placed in this post. That subject matter has become anything Image investigating only a few time whilst your write-up is amongst the very best I’ve got understand..
April 16th, 2012 at 12:32 pm
Great blog always offer the best and authentic information without creating exaggeration. This blog has given me opportunity to learn many things regarding products and services. http://www.miamigaragedoors.com
April 17th, 2012 at 4:23 pm
Tramadol is a non-opioid analgesic drug used to relief pain and stiffness or severe pain. Tramadol has proven to work on patients with Fibromyalgia.. A large number of visitors come on this blog for getting bona fide information.www.medscostless.com/buy-fioricet.html
April 18th, 2012 at 1:09 pm
Looking to dominate the search engines in Atlanta Georgia? Want top 10 listing in Google Places. SEO Firm Atlanta offers affordable and high quality local SEO services.
April 20th, 2012 at 11:16 am
I really appreciate the kind of topics you post here. Thanks for sharing information that is actually helpful. Good day!.
April 20th, 2012 at 12:04 pm
Your work is really looking good,I suggest that you take the help of Software development India to develop a software, helping you with the designing work.
April 20th, 2012 at 1:14 pm
I was looking for sites related to Offshore Software development, when I saw your post.
April 22nd, 2012 at 3:54 am
Hi are using WordPress for your site platform? I’m new to the blog world but I’m trying to get started and set up my own. Do you need any html coding knowledge to make your own blog? Any help would be really appreciated!
April 24th, 2012 at 3:28 pm
Looking for high quality SEO link building, link building service in Alpharetta, Atlanta, Georgia Contact best link building firm in Atlanta – SEO Firm Atlanta
April 30th, 2012 at 10:39 am
This is a really good post. Must admit that you are amongst the best bloggers I have read. Thanks for posting this informative article.
May 4th, 2012 at 12:37 pm
Great blog always offer the best and authentic information without creating exaggeration. This blog has given me opportunity to learn many things regarding products and services.
May 4th, 2012 at 3:34 pm
Good construction material is required to finish the work in time and the way it is required. Click here to get the finest deals on Strongboyhere.
for more info – http://www.scpburton.co.uk
May 4th, 2012 at 5:16 pm
Mens boxer shorts or boxer briefs are also called tight boxers. They are longer in the leg like boxer shorts and tight-fitting like briefs
for more info – http://www.toowhit.com
May 5th, 2012 at 5:13 pm
Useful information ..I am very happy to read this article..thanks for giving us this useful information. Fantastic walk-through. I appreciate this post.