Building a successful data warehouse depends not only on choosing the right hardware and software, but also on understanding and verifying your data before you begin your project. By adding a data validation step during the design phase of data warehouse projects, companies can actually save time during the coding and testing of warehouse reports. Time savings can be realized in areas such as: discovering data that is missing or the wrong type; discovering differences between data and the documented business rules; and doing "what if" analysis on a sample of the data.

Continental Airlines contracts with EDS to provide support for their data warehouse projects. Various groups in Continental have requested that a Customer Information System (CIS) data warehouse be constructed to help them better understand the needs of their customers. Continental will leverage several projects from the data in the data warehouse. This article talks about the roll of data analysis in enhancing the success of two of these projects.

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