DM Review Published in DM Review Online in July 2002.
Printed from DMReview.com


I would like to know if you have any studies comparing different software for business intelligence?

by David Marco  and by Les Barbusinski

Summary: I would like to know if you have any studies comparing different software for business intelligence?

Q:

Question: I would like to know if you have any studies comparing different software for business intelligence?

A:

David Marco’s Answer: At Enterprise Warehousing Solutions we have studies on ETL (extraction, transformation and load) tools evaluation and meta data integration tools Evaluation. For more information please feel free to visit http://www.ewsolutions.com/research_paper.asp.

Les Barbusinski’s Answer: The most comprehensive survey was published in July 2001 that is still very relevant.   It was titled The OLAP Survey and was authored by Nigel Pendse.   You can purchase it directly on the Web at http://www.survey.com/reports/olap/ or call the market research company, Survey.com, directly at (408) 907-0001.

The survey contrasts ROLAP vs. MOLAP vs. DOLAP tools and ranks most of the major BI tools for a variety of characteristics such as market penetration, suitability to task, Web deployments, percentage of purchases that end up as “shelfware,” customer loyalty to the product, success rates, problems encountered, etc.   The only weaknesses in the article is that it did not survey Informatica’s new BI offering (it was released after the study), and the incomplete results on Microsoft’s BI offering (because it was released just as the survey started).


David Marco is an internationally recognized expert in the fields of enterprise architecture, data warehousing and business intelligence and is the world's foremost authority on meta data. He is the author of Universal Meta Data Models (Wiley, 2004) and Building and Managing the Meta Data Repository: A Full Life-Cycle Guide (Wiley, 2000). Marco has taught at the University of Chicago and DePaul University, and in 2004 he was selected to the prestigious Crain's Chicago Business "Top 40 Under 40."  He is the founder and president of Enterprise Warehousing Solutions, Inc., a GSA schedule and Chicago-headquartered strategic partner and systems integrator dedicated to providing companies and large government agencies with best-in-class business intelligence solutions using data warehousing and meta data repository technologies. He may be reached at (866) EWS-1100 or via e-mail at DMarco@EWSolutions.com.

Les Barbusinski is vice president of technology and co-founder of Digital Symmetry, LLC, a consulting firm that specializes in the design and development of data warehousing and business intelligence solutions. He has more than 20 years of experience in data warehouse and operational systems development and provides hands-on expertise in data warehouse design, development and project management. Les can be reached at dwexpert@dsym.com.

Copyright 2005, SourceMedia and DM Review.