Portfolio Item Weekly Snapshot
The Portfolio item weekly snapshot dataset provides a weekly update on the status, progress, and key metrics of portfolio items. This dataset offers critical insights into project performance, helping teams and stakeholders track the alignment of portfolio items with organizational goals. It includes data points such as planned completion dates, business value, and other relevant metrics, ensuring effective management and timely decision-making within the project portfolio.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Calendar date | Gregorian calendar date displayed in the format ‘M/D/YYYY’ |
| Calendar week | Gregorian calendar week displaying the week number. For example, |
| W21, W22. | |
| Lagging count of weeks | Count of defects for the current week and the preceding two |
| Last refresh date | Date of the most recent update or refresh of data in a dataset. It is in date format. |
| Portfolio item | Unique identifier for the Portfolio item |
| Portfolio item closed date | Date when a portfolio item is marked as closed |
| Portfolio item completed date | Date when a portfolio item is marked as completed |
| Portfolio item planned end date | Date when a portfolio item is expected to be completed within a planning level. |
| Portfolio item planned start date | Date when a portfolio item is planned to commence within a planning level. |
| Portfolio item planning level | Planning level of the portfolio item |
| Portfolio item planning level end date | End date of the planning level associated to the portfolio item |
| Portfolio item planning level start date | Start date of the planning level associated to the portfolio item |
| Portfolio item priority | Priority of the portfolio item |
| Portfolio item roll up state | Roll up state of the portfolio item |
| Portfolio item source url | URL of the portfolio item |
| Portfolio item state | Current state of the portfolio item |
| Portfolio item status | Current status of the portfolio item |
| Portfolio item title | Title of the portfolio item |
| Portfolio item type | Type of the portfolio item |
| Sys_source | Unique identifier for the source |
| Metric Name | Description |
|---|---|
| Actual estimate completion percentage | Percentage of work completed compared to the total estimated for a specific planning level. |
| Actual estimate greater within 15 percent | Percentage by which the actual duration exceeds the estimated duration within 15. |
| Actual estimate greater than 15 percent | Percentage by which the actual duration exceeds the estimated duration by more than 15. |
| Actual work item count completion percent greater than 15 | Percentage by which the actual work item completion duration exceeds by more than 15. |
| Actual work item count completion percentage | Percentage of work items completed relative to the total number of work items planned. |
| Actual work item count completion percentage within 15 percent | Percentage by which the actual work item completion duration is within 15 percent. |
| Portfolio item business value | The business value assigned to each portfolio item indicating its contribution to organizational goals. |
| Portfolio item completed story points | Total story points associated with a portfolio item completed at the end of each iteration. |
| Portfolio item completed work item count | Total number of work items completed at the end of each iteration associated with a portfolio item. |
| Portfolio item planned completion | The scheduled completion date for a portfolio item reflecting its timeline and alignment with project milestones. |
| Portfolio item swag | Total amount of swag in each planning level. |
| Portfolio item total story points | Summation of story points associated with all work items within a planning level. |
| Portfolio item total work item count | Count of work items in an iteration associated with a portfolio item. |