Mistakes to avoid when building a Data Warehouse

By Paul Lewin on December 20, 2004 10:54 AM

This article by DMReview gives you a simple but affective list of 10 mistakes which you shouldn't make when developing a Data Warehouse.


  1. Leaving out the users

  2. Testing reports - not data

  3. Skipping the reconciliation of data warehouse data with source system data

  4. Underestimating the testing workload

  5. Failing to set proper expectations with business users

  6. "Fast tracking" the testing phase

  7. Underestimating the duration of the ETL process

  8. Choosing the "wrong" testers

  9. Skipping proper sign-offs

  10. Using "made up" test data

Categories: