Loading...
Quick Links

Microsoft® Project Do’s and Don’ts: Creating a Risk Assessment Dashboard: Part 3

In Part One of this series I illustrated a simple method to identify, quantify and evaluate risk in tasks and projects.

Part Two illustrated how to use the information from Part One to create a “Risk Assessment Dashboard”, complete with a custom table, lookup tables, formula and graphical indicators.

This article will show how to use the new “Risk Assessment Dashboard” in data grouping. When the custom fields were created in Part Two, Project was ready to group them. Once grouped, tables could be employed to view specific types of information such as how much work or cost is anticipated for each level of risk. See the figure below for details. Click on any figure in this post to enlarge the figure.

huffmanpart3_1


Want more Do’s and Don’ts? Check out MPUG’s new book: Microsoft® Project Do’s and Don’ts!


Grouping a field is built into the AutoFiltering feature in Project. Select the “Risk Assessment Table”, then check that field grouping is available by first examining the “Risk Severity” field’s column heading. If you see a list icon to the right of the field description, you can begin grouping immediately. The figure  below illustrates where the list icon is in the column heading.

huffmanpart3_2

If it’s enabled, click on it and you’ll be rewarded with a list of options including “Group on this field”.

huffmanpart3_3

When selected, the grouping is presented. Note that data in  each group is being summarized via data rollup in the figure below. At this point choose the table that meets your need, such as “Cost” or “Work”. The first figure in this post is displaying the Cost table.

huffmanpart3_4

If AutoFiltering is turned off and the list icon is not visible, turn it on! Choose the “View” tab and click on the “Filter:” list icon to get the list of filters and filtering options. Click on the “Display AutoFilter” option.

huffmanpart3_5

When it is time to remove the group, ensure you are back in the “Risk Assessment Table”, then click on the group’s field heading and choose “No Group”.  You’ll be returned to the ungrouped table.

In Part Four of this series I will use the fields, the formula, graphical indicators and grouping from this blog entry to report on risk. I will illustrate how to use a defined custom data group to summarize the cost, work and schedule that is developed in the project so far by their respective risk severity. Then we’ll graph it!

 

Did you enjoy this blog post? If so, please let me know in the comment fields below! I love to hear from my readers.

 

Share This Post
6 Comments
  1. Very interesting series and very logically laid out in a step by step manner, I look forward to trying this in my current IMS.

    Reply
  2. Hi Sam,

    Great series of articles. The only item I would change is to put a number next to Low/Medium/High names in the fields. They would still group the correct way, but also be sorted from Most important (highest risk) to least important.

    Reply
  3. Sam Huffman

    Nice tip Bob!

    Reply
  4. Excellent tip Sam! Looking forward to see more of those tips used in ms project.

    Reply
  5. Am really enjoying following your blog and updating the risk matrix. Thanks Bob!

    Reply
  6. Smart Man

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

9 + 1 =

Thanks for submitting your comment!
You must be logged in to comment.