[10k]: Delivery dashboard - Metrics

[widal001]

Description

Create a series of scripts that calculate key sprint and delivery metrics that we want to track within the project and publish on the delivery dashboard.

Business goals

• Prioritize a series of metrics that help inform sprint planning and delivery management
• Create a series of reusable scripts that make it easier to calculate future metrics
• Provide a narrative explanation of how metrics are calculated, so that members of the public can understand the logic behind these metrics

Sub-Tasks

Sub-tasks will be tracked in this milestone

Acceptance criteria

• [ ] Project stakeholders can report on the following metrics:
  • [ ] Sprint completion -- # of tickets and/or points created vs planned per sprint
  • [x] Sprint burndown -- Total number of points remaining over the course of the sprint
  • [ ] Sprint burnup -- Total number of open and closed tickets per day in the sprint
  • [x] Deliverable completion -- % of tickets and/or points completed per deliverable
  • [x] Deliverable burndown -- Total number of points remaining over time for a given deliverable
  • [ ] Deliverable burnup -- Total number of open and closed tickets over time for a given deliverable
• [x] If any of the metrics above require custom code to generate, that code is stored in an analytics/ sub-directory
• [ ] Each time new code is pushed to the analytics/ directory the following code quality checks are run:
  • [ ] Linting
  • [ ] Auto-formatting
  • [ ] Type checking
  • [ ] Unit tests

[widal001]

We were planning to create a separate issue but decided to repurpose this one instead

[acouch]

@widal001 For the initial dashboard, I'm thinking we could use the BI tool to do the querying between the two initial tables for items like the burndown chart:

Surely there will be room for improvement on the data side and at some point we could create views to reduce the queries we will need in the BI tool, but for now we could focus on getting the data accessible and the BI tool stood up.

Can we close this one for now or should we move to another deliverable?

[widal001]

Replacing our old 10k ft deliverable issues with a new Epic format

[widal001]

Reopening for review during sprint planning