The Data Warehousing Institute (TDWI), the leading provider of in-depth education and research in the business intelligence and data warehousing industry, has released the second report in its 2004 Report Series, "In Search of a Single Version of Truth: Strategies for Consolidating Analytic Silos." Report findings indicate that although few organizations have fully consolidated, activity is ramping up and return on investment is high for those who succeed. Key findings in this report include:

  • Organizations have an average of two data warehouses, six independent data marts, 4.5 ODSs and 28.5 spreadmarts left to consolidate. To date, they've only consolidated about one-third of all the structures in their environment.
  • The most prevalent driver of consolidation is the need for consistent data across the enterprise. Almost all survey respondents (90 percent) rated this factor as "very high" or "high." This was followed by "reducing costs and overhead" (71 percent) and "standardizing the IT portfolio" (50 percent).
  • Only 11 percent of organizations have completed a project to consolidate analytic silos. However, a majority (56 percent) are in the process of designing or implementing a consolidation project and another 26 percent are exploring the idea. Only 7 percent have "no plans."
  • The average ROI for consolidation projects is $3.34 million. The average payback period for consolidation projects is 2.1 years.
  • Survey respondents indicated (61 percent) that a central data warehouse architecture is the preferred post-consolidated environment.
  • One of the biggest challenges with consolidation is obtaining agreement from business group representatives on terms and definitions governing data in the new consolidated environment.

The research for this report is based on a survey that TDWI conducted in early 2004, as well as interviews with industry "experts," including end-user organizations, BI consultants, industry analysts and report sponsors.
A majority of the 615 qualified respondents (59 percent) were corporate IT professionals. The remainder included independent consultants (30 percent) and business sponsors/users (11 percent). Respondents' company sizes ranged from small to large corporations. More than one-third of the qualified respondents (38 percent) work at companies that have revenues in excess of $1 billion, while 51 percent have less than $1 billion. Most respondents are based in the United States and work in a range of industries, the largest portion of which are consulting and financial services.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access