TDWI World Conference Las Vegas, NV February 12-17, 2012

Prerequisite: None

Ralph Hughes

With agile data warehousing, we unleash developers to deliver ETL and BI as fast as humanly possible. But how do you know if the team is producing quality results that can be put into production? You could insist they test everything, but wouldn’t that destroy the team’s agility?

In this course, a veteran data warehouse architect and the author of Agile Data Warehousing will present a quality assurance strategy compatible with agile’s abbreviated time-to-market objectives. First, we will review the testing approaches typically utilized by warehousing departments of Fortune 500 firms. The course will systematically streamline these approaches and adapt them for iterative development efforts. We will build, layer-by-layer, a QA plan for BI/DW that culminates with a strategy for automated multi-scenario, multi-time-point validation for your warehouse and data marts.

This course will provide many valuable QA concepts, even for professionals using traditional methods.

You Will Learn

• A standard framework for software testing
• The requirements for proving that a warehouse project is complete and correct
• The secrets of agile’s test-led development
• How to streamline testing to accelerate developers
• A strategy for continuous integration and regression testing that yields “provably correct” ETL modules

Geared To

• DW professionals concerned with their teams’ existing QA effectiveness or wishing to lower the cost of BI/DW validation; senior-level participants in DW projects or programs, including solutions architects, lead technical team members, QA specialists, program managers, and project managers