The Agile Data (AD) Method

Definition of Done (DoD) for a Data Warehouse Team

The definition of done (DoD) specifies the quality criteria a team’s work must meet or exceed to be considered “finished.” The DoD for a team protects its customers from poor-quality work.  As shown in Figure 1, the DoD is an agile quality gate that a team’s work must pass through before proceeding downstream. There is a corresponding definition of ready (DoR) that protects your team from poorly specified requests.

Figure 1. A team’s DoR and DoD.

Agile Quality Gates: Definition of Ready (DoR and Definition of Done (DoD)

Figure 2 provides an example of a DoD for an agile data warehouse team. Notice how this DoD includes criteria for both releasing work to an independent testing team as well as to their end users. This team works in a regulated enviroment and as a result their work must pass through the hands of independent testers (there are several data testers internal to the team as well).

Figure 2. Example definition of done (DoD) for an agile data warehouse team.

DoD for Internal Release to Independent Testing:

  • All acceptance criteria have been implemented via executable tests
  • All tests run successfully
  • Detection and reporting of potential data errors implemented
  • Answers to each question story are available within Tableau
  • The change list describes what changed from the previous internal release
  • Supporting technical documentation is up to date

DoD for Potential Release to End Users:

  • All severity 2+ defects identified by independent or integration testing have been addressed
  • Compliant with applicable data regulations (SOX, GDPR, CPRA)
  • Meets accessibility requirements
  • Enterprise metadata captured, validated, and accepted
  • Demonstrated to stakeholders and accepted by them
  • Release notes updated

Source

Material for this article was adapted from Not Just Data: How To Deliver Continuous Enterprise Data.

 

Recommended Resources