Testing the Data Warehouse – Big Data, Big Problems

Data warehouses have become a popular mechanism for collecting, organizing, and making information readily available for strategic decision making. The ability to review historical trends and monitor near real-time operational data has become a key competitive advantage for many organizations. Yet the methods for assuring the quality of these valuable assets are quite different from those of transactional systems. Ensuring that the appropriate testing is performed is a major challenge for many enterprises. Geoff Horne has led a number of data warehouse testing projects in both the telecommunications and ERP sectors. Join Geoff as he shares his approaches and experiences, focusing on the key “uniques” of data warehouse testing including methods for assuring data completeness, monitoring data transformations, and measuring quality. He also explores the opportunities for test automation as part of the data warehouse process, describing how it can be harnessed to streamline and minimize overhead.

Session Takeaways:

  • Learn the uniques of testing data warehouses.
  • How to monitor data transformations.
  • How to measure quality of data transformations.
  • Uncover how automation can be used in the data warehouse test environment.
  • What the different test phases are in data warehouse testing.

Test Strategy
Location: Concord Date: October 8, 2015 Time: 3:30 pm - 4:30 pm Geoff Horne