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
STQA	Software Testing and Quality Assurance Techniques	3 Days	I	Details
STBC1	Software Testing Bootcamp - Part 1	2 Days	I	Details
DWCONI	Introduction to Data Warehouse Concepts	1 Day	I	Details
DWMODEL	Dimensional Modeling for Data Warehouse Projects	5 Days	II	Details

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]