Summarizing Progress with Parking Lot Diagrams
February 28, 2007
Feature Driven Development (FDD) employs a smart way of rolling up development progress that provides an easily digested summary of project status using Parking Lot diagrams. Yet, their appreciation and use outside of FDD is quite rare. I taught an Agile Project Management class last week and nobody had seen or used them before, which is a shame because, especially for large projects, they are a great dashboard tool to illustrate overall progress and pain points.
Parking lot diagrams are not just for FDD projects, they can be used equally as well on XP, Scrum, or DSDM projects and this post will introduce them and provide you with a sample Excel spreadsheet for creating them.
As projects get larger the number of features (user stories) you likely have to manage increases. Small to medium size projects with a few hundred features can be managed fine with decks of cards, task boards, and burn-down charts, but as projects scale this information becomes hard to manage and difficult to digest by stakeholders. Parking Lot diagrams roll-up features into functional groups and then these groups into functional areas to better illustrate overall progress against business areas.
Let’s say we have 15 features associated with our order entry functionality. These features could be rolled-up under an Enter Order Details group and reported using a Parking Lot diagram as shown in the annotated example below.
There is a lot of information here. FDD promotes the idea of a chief programmer, an individual who is responsible for a piece of functionality. Their initials “FB” can be shown above the parking lot diagram. If a stakeholder has a question about this area, then they know (Fred Blogs) is the person to speak to. Alternatively, if you are working on an XP project with shared code ownership it may not be appropriate to display initials, in which case simply don’t. Inside the main box the feature group is named (Enter Order Details) and in brackets the number of individual features that make up this group or set is shown (in our case 15).
The colour of the box indicates status. With our colour scheme White for not started, Yellow for work in progress, Green for complete, and Red for late. Standards vary, some people use Blue for work in progress, Yellow for nearing the due date, and Red for late, but as long as all the project stakeholders agree on what each colour means you should be fine. The main box also contains a percent complete figure based upon the combined status of each of the (15) features within it.
The bottom portion of the box contains a progress bar that duplicates the percent complete figure to give a more visual measure of this number and the target completion month for this group of features.
The real power of this technique comes when these feature groups are combined into feature areas and an overall dashboard for the entire project is created.
In the example shown above we can see that the feature group “Enter Order Details” is just part of a larger “Order Processing” feature area that contains other feature groups such as “Create New Order”, “Capture Customer Details”, and “Process Payment”. Also, the project has other feature areas such as “Inventory Management” and “Customer Management”. We can also see that “Stock Search” is red, because it should have finished in January and is still not complete.
Using these roll-ups and grouping, the status on hundreds and even thousands of features can be summarized onto a one page view. Also, grouping by business area provides a useful tool to better engage business stakeholders in meaningful dialogue. It is easy to see where the problem areas are, the work in progress, and the work not yet started.
So, how do you produce these fancy diagrams automatically, without spending hours of fiddling around? Well, you can invest in fancy agile project management tool or download this free sample spreadsheet.
Creating these Parking Lot diagrams in Excel is actually quite easy. We can use Excel’s conditional formatting functionality to change the box colour based on status, and the trick to producing the progress bar is to strategically add a bar graph that has no formatting area or legend. This creates and automatically updating progress bar that stays in sync with the completion status.
In the sample spreadsheet, the default colour scheme is white for work not started, blue for work in progress, yellow for tasks due for completion within 14 days, and red for overdue tasks. To create your own custom project dashboard, use the formatting and formulae as a sample to build a dashboard for your project features. I would recommend engaging a customer and the development team in defining functional groups and functional areas.
On some projects I have included non-functional requirements such as architectural work and environment tasks in their own functional area of the dashboard. This helps the reporting of iteration zero risk mitigation tasks. So, however you choose to use them, Parking Lot diagrams are an excellent tool to have in your reporting toolbox. When a burn-graph or cumulative flow diagram just is not connecting with the business, try a Parking Lot diagram.
You can read more about Parking Lot diagrams at the FDD site.
That's a great tool....thanks!
Posted by: Eve Sheridan | March 01, 2007 at 09:19 PM
Great post and great contribution with the spreadsheet! Thanks.
Posted by: David Anderson | March 13, 2007 at 10:15 PM
Congratulations! Great post and spreadsheet!
Posted by: Lester Zimmer | March 18, 2007 at 12:14 AM
Posted by: Ed Page | November 11, 2007 at 02:05 PM