O'Reilly logo

Agile Data Warehousing for the Enterprise by Ralph Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16

Why We Test and What Tests to Run

EDW faces a stiff challenge in even deciding what to test because with more than 40 test types available and hundreds of data warehouse components needing validation, executing every possible test will be financially infeasible. Agile EDW teams develop feasible DW/BI QA plans by combining top-down and bottom-up planning. Top-down planning examines six dimensions of testing and then employs a 2×2 matrix that intersects the two types of conclusions tests can support with the two types of audiences to which a test can speak. Once this 2×2 matrix is completed, teams can then reflect on whether the four quadrants are balanced. Bottom-up QA planning considers more than a dozen techniques for authoring unit ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required