Il est bien plus beau de savoir quelque chose de tout que de savoir tout d'une chose. [Blaise Pascal]

Doing Scrum in Microsoft Project 2010

20 comments
Two year ago, I was involved in a project for a luxury company, and previous project manager used Scrum to manage it and the deliveries. After a quick introduction of this methodology, we used his tools (mainly Excel) to implement Scrum.
Today I would like to reuse Scrum in another project, but I wanted to see if it’s possible to use Microsoft Project instead of Excel to manage Scrum artifacts as Product backlog, Sprint Backlog and Burn down chart.
Note that this article will not explain the methodology; you can check this article in Wikipedia or watch this interesting video by Hamid Shojaee for a quick course on Scrum.

Step 1: Create Product backlog
Looking at Wikipedia article I read: “The product backlog is a high-level list (of features)”. This is basically what Microsoft Project does with tasks list. Then “The product backlog contains rough estimates of both business value and development effort”. This can be achieved by adding some custom fields and display existing ones.
·         Task Name
·         Description (will be done in the task note)
·         Sprint (Custom text or number, must be a lookup), see below how to create a lookup.
·         Points (using for example Fibonacci sequence) (Custom number or list), note that “Priority” as field name is already used
·         Baseline work
·         Actual Work
·         % Complete
·         Work
·         Duration
·         Start and finish date
·         Resource Names

Here is how to create a lookup field:

This is an example of a project file I made:

As you can see, on note mouse over, I see the task description (note). We can also add this field as a column to display it in the table.

Step 2: Sprint backlog
To display stories based on sprint, I just create a custom Group by (Group by Sprint). This will be my sprint(s) backlog.

Step 3: Burn down chart
Now it’s time to create the burn down chart. First of all I will input some actuals in my planning and update it. Note that the status date has been set to 16/01/2012 (I am a little bit ahead of schedule). Then click on Visual Reports.

Click on new template, select Excel application and Assignment usage as Data Type. You also need to add to your report custom fields you have created. Click on Field Picker and select the Sprint (Text 2) field; this can be used to filter data. Let’s use days as Level of usage data to include in the report (Note you can use weeks or any other time frame).

Important note: To be exported as a dimension, the custom field should be a lookup. This is why we have defined Sprint custom field as a lookup.


Create your pivot table in Excel as follow:

Now you need to create additional columns to make calculation of:
·         Cumulative Baseline: Cumulative of Baseline Work
·         Cumulative Actual: Cumulative of Actual work
·         Remaining Planned = Baseline Work Grand total – Cumulative baseline
·         Remaining Actual = Baseline Work Grand total – Cumulative actual
·         Copy also day number on the first column


This will be used to draw you burn down chart. Select the first 3 columns and insert a 2D line chart.

You have now your burn down chart. Yellow tag when remaining work is not moving is simply week ends. As you can see at the end of the graph, on Jan 16th we are ahead of schedule.

NOTE that of course this report can be saved as a template for future use. When saving your file, you will be prompted for that.

Alternative solution
Some people may say, “Wow it’s too complex for me, do you have any easier solution?”
There is always a simpler solution for lazy project managersJ. You can download the Microsoft Project 2010 Scrum Solution Starter. You can download this free package (under MICROSOFT PUBLIC LICENSE) on MSDN website.
The pitch given on this page is:
Microsoft Project 2010 Scrum Solution Starter is designed to provide guidance on using the Microsoft Project 2010 to manage Scrum projects, aiming to help individual Scrum teams to start using Project to:
·         Manage Product backlog
·         Manage Scrum backlog
·         Track progress and generate Burn down charts

You can check the overview document under download section for a quick “how to guide”.
I did not use it yet in a real project, but will try and will not miss to write on my experience.

20 comments :

  1. just linked this article on my facebook account. it’s a very interesting article for all.


    Scrum Courses- cPrime

    ReplyDelete
  2. Thanks Arumugam for your message, really appreciated

    ReplyDelete
  3. This is really great article and very well explained.

    ReplyDelete
  4. Many thanks Pankaj, do not hesitate to share it

    ReplyDelete
  5. Thanks Jeremy, that is what I was looking for. The MS Project Scrum Solution starter set does not work (yet). Bets regards from Germany
    Juergen Bruns

    ReplyDelete
  6. Hi Juergen,
    Thanks for the comment, do not hesitate to share this post with your contacts

    ReplyDelete
  7. You can also create burndownchart with a tool called projectsimple can be downloaded from download.com or www.adept.dk/english
    bobby

    ReplyDelete
  8. Thanks Bobby for this information. Less than 25$ i think this is something maybe users should try.

    ReplyDelete
  9. Hey thanks for the post its good idea to use scrum training methodlogy in microsoft project.

    ReplyDelete
  10. Your posts are good and so informative. Microsoft Office Word and Excel have their own distinct advantages.
    Business templates | Excel templates

    ReplyDelete
  11. Microsoft Office InfoPath is the Office information gathering as well as management program, which streamline the process of gathering information. office 365 product key

    ReplyDelete
  12. Do you want to learn Microsoft Project to manage your projects? Then you should take a Microsoft Project training course from PPM Global Services, Inc. They designed their course to lead students through the project life cycle, from planning to execution.

    ReplyDelete
  13. Learn why software licensing is just good business sense and is important to protecting your business. Don't let cheap pirates put your business at risk for a quick buck. windows 10 activation key

    ReplyDelete
  14. In this small article we would like to share our consulting experience, serving Houston business metro ERP/MRP/CRM market, in our case this is Microsoft Great Plains, Microsoft CRM, Microsoft Navision and Microsoft Axapta implementation, customization, integration & reporting windows 10 activation key

    ReplyDelete

Note: Only a member of this blog may post a comment.