Q:  

I am looking for information on evaluating the success or failure of a data warehouse after implementation from a business point of view. I am looking for a methodology and tools for doing this if one is available.

A:  

Clay Rehm's Answer:The best way I can think of is to interview each and every user do determine if they are using the data warehouse and how often. I would go further and try to find out what they like about it, what they don't like and how they would change it if they could.

To me, the success of a data warehouse is expressed by how many users are using it and how often. Additionally, if these users are showing up at meetings and presenting data using the data from your data warehouse, that is a pretty good sign that there has been success.

Sid Adelman's Answer: You need something against which to make a comparison. The comparison should be against your goals for the data warehouse. For example, if one of your goals was that 80 percent of those trained become active users of the data warehouse, you can measure that usage and if the percentage is 85 percent, you have one measure indicating success. These are few more measures of success:

  1. High quality data - yes, this can be measured.
  2. On time - make sure you have a reasonable schedule and make sure your task plan drove the schedule.
  3. All the function delivered - the functions should have been itemized in your scope agreement.
  4. On or under budget - did you remember all the costs when you budgeted?
  5. SLA realized for availability, e.g., 98 percent for the scheduled hours.
  6. ROI realized - read http://www.teradata.com/t/pdf.aspx?a=83673&b=86833.
  7. High user satisfaction - be sure to measure user satisfaction at least twice a year.

Management recognizes the benefits of the data warehouse - give management a one-page monthly report on usage, response time, availability, user satisfaction and ROI.

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