A road-map on Testing in Data Warehouse

Details

Category: DWBI Project Management

Published on Monday, 16 August 2010 22:24

Written by Akash Mitra

Hits: 745

Testing in data warehouse projects are till date a less explored area. However, if not done properly, this can be a major reason for data warehousing project failures - especially in user acceptance phase. Given here a mind-map that will help a project manager to think all the aspects of testing in data warehousing.

Testing Mindmap

Points to consider for DWBI Testing

1. Why is it important?
   • To bug-free the code
   • To ensure data quality
   • To increase credibility of BI Reports
   • More BI projects fail after commissioning due to quality issue

2. What constitutes DWBI Testing?
   • Performance Testing
   • Functional Testing
   • Canned Report Testing
   • Ad-hoc testing
   • Load Reconciliation

3. What can be done to ease it?
   • Plan for testing
   • Start building DWBI Test competency
   • Design code that generates debug information
   • Build reconciliation mechanism

4. Why is it difficult?
   • Limited Testing Tool
   • Automated Testing not always possible
   • Data traceability not always available
   • Requires extensive functional knowledge
   • Metadata management tool often fails
   • Deals with bulk data - has performance impact
   • Number of data conditions are huge

Use the above mind-map to plan and prepare the testing activity for your data warehousing project.

• < Prev
• Next >