Iteration Planned vs Actual
The Iteration planned vs actual dataset consists of data comparing planned and actual values for specific metrics or key performance indicators (KPIs) related to planning level iterations or sprints. It provides insights into how well the team's plans align with their actual performance during each iteration, helping project managers assess progress, identify areas for improvement, and make data-driven decisions to optimize future iterations.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Completed work item flag | Flag of the completed work item |
| Iteration | Unique identifier for the iteration |
| Iteration end date | End date of the iteration |
| Iteration start date | Start date of the iteration |
| Last refresh date | Date of the most recent update or refresh of data in a dataset. It is in date format. |
| Planned work item flag | Flag of the planned work item |
| Sys_source | Unique identifier for the source |
| Work item | Unique identifier for the work item |
| Work item planning level | Planning level of the work item |
| Work item portfolio item | Portfolio item of the work item |
| Work item team | Team of the work item |
| Work item type | Type of the work item |
| Metric Name | Description |
|---|---|
| % completed estimate (completed vs planned) | % estimate of stories completed in an iteration |
| % completed work items (completed vs planned) | Percentage of work items that have been completed compared to the total number of planned work items. |
| % completed work items (completed vs total) | Percentage of backlog items completed in an iteration |
| Added estimate | Count of estimates added to the iteration after the iteration started |
| Added work item count | Count of backlog items added to the iteration after the iteration started |
| Completed estimate | The total estimate or the total number of backlog items that were actually completed in each iteration. |
| Completed work item count | Count of backlog items completed in an iteration |
| Planned estimate | The total estimate of backlog items that were planned and completed in each iteration. |
| Planned work item count | Count of backlog items planned at the beginning of the iteration |
| Total story points | Summation of story points associated with all work items within a planning level |
| Total work item count | Count of work items in an iteration |