Fundamentals of Data Warehouse Testing

Course:  DWTEST
Duration:  3 Days
Level:  II
Course Summary

This course introduces the student to the phases of testing and validation in a data warehouse or other decision support systems project. Students will learn the role of the testing process as part of a software development project, see how business requirements become the foundation for testing cases and test plans, develop a testing strategy develop audience profiles and learn about how to develop and execute effective tests, all as part of a data warehouse / decision support initiative. Students will apply the data warehouse concepts in workshops that enable them to create and refine the various artifacts of testing for their data warehouse programs

« Hide The Details
Topics Covered In This Course

Understanding Business Intelligence

  • Analyze the current state of the data warehousing industry
  • Data warehousing fundamentals
  • Operational data store (ODS) concepts
  • Data mart fundamentals
  • Defining meta data and its critical role in data warehousing and testing

Key Principles in Testing

  • Testing concepts
  • Overview of the testing and quality assurance phases

Project Management Overview

  • Basic project management concepts
  • Project management in software development and data warehousing
  • Testing and quality assurance as part of software project management

Requirements Definition for Data Warehouses

  • Requirements management workflow
  • Characteristics of good requirements for decision support systems
  • Requirements-based testing concepts and techniques

Audiences in Testing

  • Audiences and their profiles

User profiles

Customer profiles

Functional profiles

  • Testing strategies by audience
  • Test management overview

Risk Analysis and Testing

  • Risk analysis overview for testing

Test Methods and Testing Levels

  • Static vs. dynamic tests
  • Black, grey and white box testing
  • Prioritizing testing activities
  • Testing from unit to user acceptance

Test Plans and Procedures

  • Writing and managing test plans and procedures
  • Test plan structure and test design specifications

Test Cases Overview

  • Test case components
  • Designing test scenarios for data warehouse usage
  • Creating and executing test cases from scenarios

Validation and Verification

  • Validating customer needs for decision support
  • Tools and techniques for validation, verification and assessment

Acceptance Testing for Data Warehouses

  • Ways to capture informal and formal user issues and concerns

Test readiness review

Iterative testing for data warehouse projects

Reviews and Walkthroughs

  • Reviews vs. walkthroughs

Inspections in testing and quality assurance

Testing Traceability

  • Linking tests to requirements with a traceability matrix

Change management in decision support systems and testing

Test Execution and Documentation

  • Managing the testing and quality assurance process
  • Documentation for the testing process
What You Can Expect

At the end of this course, students will be able to:

  • Review the fundamental concepts of data warehousing and its place in an information management environment
  • Understand the role of the testing process as part of software development and as part of data warehouse development
  • Understand test strategies, test plans and test cases ??? what they are and how to develop them, specifically for data warehouses and decision support systems
  • Create effective test cases and scenarios based on business and user requirements for the data warehouse
  • Plan and coordinate usability testing for data warehousing
  • Conduct reviews and inspections for validation and verification
  • Participate in the change management process and document relevant changes to decision support requirements
Who Should Take This Course

Testing analysts, business analysts, project managers, business staff members who will participate in the testing function; data warehouse architects, data analysts

Recommended Prerequisites

Experience as a test analyst, business analyst or experience in the testing process.

Training Style

Instructor led with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
Software Testing and Quality Assurance Techniques
3 Days
Software Testing Bootcamp - Part 1
2 Days
Introduction to Data Warehouse Concepts
1 Day
Dimensional Modeling for Data Warehouse Projects
5 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]