How to use Agile Project Management Dashboard Excel

Follow the below steps start using the Action Item Tracker Template:

Track the Agile Project progress using the Agile Project Dashboard template

The template has the following key sections

  • The Backlog
  • The Sprints
  • Risks and Issues
  • Burndown Chart (auto updated)

The Backlog

  • Enter the item number, description of items being worked for the project
  • Update the “sprint” should have the sprint in which the backlog item is being worked. (i.e:Sprint 1,Sprint 2,Sprint 3,etc)

The Sprints

  • Enter the start date and Finish date for each sprints.
  • The current sprint is Highlighted in Blue (Based on the the current date).
  • As you can see in above template images Sprint 1 is highlighted which is based on the system date the Project date in sprint 1
  • Update the status of the tasks in backlog as per the progress of tasks i.e: Complete,On Track,Delayed and Behind.
  • Enter Status as complete when the item is complete and ready to be shipped or released.
  • Enter task status as On Track when everything is as per the plan.
  • Enter Status as Behind when the task has slowed down  and could potentially get delayed.
  • Update status as Delayed when the task is already out and will need some more time or additional resources to complete.

Risks and Issues

  • In this section, for each sprints you can write the 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 issue - The team had a few unplanned leaves because of which the module has 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

  •  Displays the Burn down Chart for each sprint.
  • Burndown chart is graphical representation of work left v/s time.
  • We can edit the data of the graph in data tab which will capture Planned and Actual effort/story points which then feeds into the burn down chart. 
  • For every sprint we have planned and actual.
  • Either use work units or story points that you planned vs what was actually achieved in the sprint.