200 Templates
for just $29
Why buy our templates?
- 200 project management templates.
- Focus on managing projects not templates.
- Multiple formats - XLS Doc, PPT etc.
- Detailed explanation for each template.
- Jump start with your project.
- New templates emailed every month.
- No questions asked refund policy.
- Guaranteed support response in 24 hours.

Templates Included
Project Status Report  - 24 templates.
General Planning  - 24 templates.
Project Initiation - 20 templates.
Resource Planning - 16 templates.
Agile PM Templates - 16 templates.
Task Management - 15 templates.
Project Plans  -13 templates.
Project Meetings - 12 templates.
Project Registers & Logs - 11 templates.
Project Timelines - 10 templates.
Project Dashboard - 9 Templates.
Change Management - 6 templates.
Heatmap for Issues - templates.
Project Budgeting - 4 templates.
Risk Management - 3 templates.
Project Closure - 2 templates.

* Other Benefits 
One time payment. No monthly fees.
Access to member only premium templates.
New templates emailed every month.
Link for immediate download.

November 15, 2016

Agile Project Management Dashboard Excel Download

One of the key challenges for any project manager responsible for an agile project is report the right picture of the project progress.

Agile Project Management Dashboard Excel Free Download
Agile Project Management Dashboard

Because of multiple sprints involved stakeholders may not be able to see a forward view of the project. This dashboard template attempts to address the issue of giving a line of sight for an agile project.

Provides a high level overview of the backlog and sprints contained in the project. For each sprint captures start, finish, backlog items planned, a burn down chart and risks/issues.

The Backlog

  • Contains the list of items being worked for the project.
  • The backlog has item number, description and Sprint. 
  • The last column "Sprint" should have the sprint in which the backlog item is being worked on.
  • Typical values for that coulmn will be "Sprint 1", "Sprint 2", "Sprint 3" etc.

The Sprints

  • Based on the start and finish dates for the sprint the current sprint is highlighted in blue. 
  • So, if you see the above image sprint 2 highlighted which currently based on the system date the project is in Sprint 2.
  • Each of the items or tasks in the back log can have different statues - Complete, On Track, Delayed and Behind.
  • Using Complete status when the item is complete and ready to be shipped or released.

  • On track status should be used when everything is as per plan.
  • Behind status should be used when the task has slowed down and could potentially get delayed.
  • Delayed is when the task is already out and will need some more time or additional resources to complete.

Risks and Issues

  • The Risks and Issues section for each sprint should be used to report any impediments the project team is facing. 
  • It is a free form text update to you can report a few issues or one issue in detail.
  • Examples a list of issues - 1. The team capacity needs to be looked at., 2, Some of the defects need re-design. 3. Login module took longer than expected.
  • Example of one detailed issues - The team had a few unplanned leaves because of which the module have been delayed. The delay has had a knock on impact on testing as testers will now need to wait as there are no other modules ready. This delay will impact on the timeline and cost of the project.

Burndown Chart

  • Each of the sprints has a burndown chart. 
  • A burn down chart is a graphical representation of work left to do versus time.
  • Data tab to capture Planned and Actual effort/story points which then feeds into the burn down chart. 
  • Please see below image for details.
  • Each sprint is assumed to be of 10 days. For every sprint we have planned and actual. 
  • You can either use work units or story points that you planned vs what was actually achieved in the sprint.

Data for the Dashboard
Data for the Dashboard

Subscribe and Download 

No comments:

Post a Comment