License

Licensed under a Creative Commons License

Disclaimer

All data and information provided on this site is on an as-is basis and for informational purposes only. We do neither guarantee for accuracy, completeness, suitability or validity of information on this blog nor be liable for any errors in this information or any damages arising from its use. This blog may contain links to other web sites. We do not have any control over the content contained on those sites.

2 posts from November 2009

Saturday, November 28, 2009

How to create Microsoft Excel dashboards to monitor the progress of a software development project (part 1 of 3)

When it comes to manage software development projects, you have to monitor a lot of different quantitative and qualitative metrics in order to answer the main question:

“Where are we?”

As in any other project you have to take care of the usual suspects in project controlling like the completion rate of tasks, the milestones and quality gates, the budget adherence, etc. In software development projects, however, there are a couple of very important specific additional facets to be monitored closely:

The actual status and the trend of software defects

The test progress, test coverage and test success

The actual status and the development of change requests

Today’s article is the first of a 3 post series on how to create minimalist, dynamic software project dashboards with Microsoft Excel; this time a software defect monitor dashboard including the Microsoft Excel workbook for free download.