The Agile Data (AD) Method

Definition of Ready (DoR) for a Data Warehouse Team

The definition of ready (DoR) for a team typically calls out the analysis work to be done before a work item is brought into the team. A team’s DoR protects them from poor-quality requests, typically poorly described requirements.  The DoR is an agile quality gate that work requests must pass through to reach the team, as shown in Figure 1. There is a corresponding definition of done (DoD) that the team must meet for their work to continue downstream in the overall process.

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 DoR for an agile data warehouse team. Notice how this DoR includes criteria for both a question story and for a defect report, the two types of work items on their backlog. This team operates in a regulated environment and, as a result, works with an independent testing team that produces defect reports describing potential issues found.

Figure 2. Example definition of ready (DoR) for an agile data warehouse team.

A question story must meet the following criteria:

  • Required data elements identified
  • Official system of record, if it exists, for each data element identified
  • Additional sources for a data element, if any, are identified
  • Acceptance criteria for the question story are defined
  • Indication of implementation preference (report, dashboard, …), if any
  • UI sketch provided when requested

A defect report must meet the following criteria:

  • Internal release identifier provided
  • Severity of defect indicated
  • Description of setup, including screenshots where applicable
  • Description of what happened
  • Description of what should have happened
  • Link to original requirement, if known, provided

Figure 3 depicts an example of a DoR for a data warehousing team following a continuous delivery WoW rather than an agile one. One of the benefits of working this way is that the look-ahead data analysis effort required to support short sprints simply becomes something that the team performs once they bring the work item into the team. As a result, the criteria for a question story are much simpler. The criteria for a defect report remain the same because removing sprints doesn’t change the timing or the way a potential defect is reported to the team.

Figure 3. Example definition of ready (DoR) for a continuous data warehouse team.

A question story must meet the following criteria:

  • Indication of implementation preference (report, dashboard, …), if any
  • UI sketch provided when requested

A defect report must meet the following criteria:

  • Internal release identifier provided
  • Severity of defect indicated
  • Description of setup, including screenshots where applicable
  • Description of what happened
  • Description of what should have happened
  • Link to original requirement, if known, provided

Source

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

 

Recommended Resources