Testing a Business Intelligence/Data Warehouse Project

When an organization builds a data warehouse, critical business decisions are made on the basis of the data. But how do you know the data is accurate? What should you test, and how? Karen Johnson discusses how to test in the highly technical areas of data extraction, transformation, and loading. Stored procedures, triggers, and custom ETL (extract, transform, load) transactions often must be tested before the reports or dashboards from a business intelligence (BI) project can be tested. The volume of data is frequently so large that testing “all the data” is simply not possible so choosing an appropriate test data set is often one of the most strategic decisions in BI testing. Karen shares stories about past BI projects and ideas on how to test data warehouse and business intelligence projects. Learn the techniques for ensuring quality data on your vital databases.