When talking about testing in a data project we have to first identify that the testing we need to do is similar but different to the testing we do in application development project.

One of the useful way to identify these differences is to understand a number of the test concerns we have in data projects.

Concern 1 – Is the data right?

(Often called functional testing)


[left right pattern]

Data Profile

[does the system of record data look the way we expect][has the data changed]

ELT Code

Business Rules Code

Concern 2 – Does the platform work?

(Often called Performance and Load testing)

Concern 3 – Will the platform survice?

(Often called Stress and Fail Over test)


[load testing elt]

[load testing users volume]

[failover testing]

Test Patterns

[left right]