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

This article will make the most sense if you read the previous three (short) parts first:

Part 1
Part 2
Part 3

In this final segment of the series I will create a custom group for use in reporting and graphing purposes. The report will look similar to the figure below at the end of this blog.

dashboardpt4_1

The first step is to create the custom group so it can be used in reporting, charting and graphing:

1. Click on the “View” tab then click on the “Group By:” list in the “Data” command group.

2. Click on “New Group By…” in the list.

3. In the “Group Definition” dialog, enter the data as itemized in the figure below, then click on “Save”.

dashboardpt4_2

4. Test the new group by choosing it from the “Group By:” list. Notice the location of the group in the figure below.

dashboardpt4_3

5. After successfully applying the “Risk Level” group, clear the group by choosing “[No Group]” from the “Group By:” list.


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


The second step is to create the “Risk Analysis” report and graph:

6. Click on the “Report” tab, then “New Report”.

7. From the choices offered choose “Comparison”. This will enable you to have multiple charts that graph work against cost and grouped by risk level. See the figure below for detail.

dashboardpt4_4

8. The “Report Name” dialog will appear, asking you to name the new report. I chose “Risk Analysis” for consistency. After the name is entered, click on the “OK” button.

dashboardpt4_5

9. Project creates the”Risk Analysis” report and places you in the “Design” tab. Note this is initially a blank slate. We will have to insert the charts for work and cost, then format them. It should look like the figure below.

dashboardpt4_6

10. Click on the “Chart” button located in the “Insert” command group. The “Insert Chart” dialog will appear. Since we will be using multiple fields and data sets, we will need a “Clustered Column” type of chart. Just click on the “OK” button to create it. The figure below points out the locations and selections for this new chart.

dashboardpt4_7

11. The basic chart is created and ready for formatting. Note that Project has placed you in “Chart Tools” for that purpose. Also note the fields compared in the chart. The fields are made visible or not by checking the “Select Field” in the “Field List” on the side of the screen. See the figure below for location of these details.

dashboardpt4_8

12. Add the “Risk Level” Group to the chart. At the bottom of the “Field List” find the “Group By:” list and choose the “Risk Level” group. The chart changes by organizing the amount of work by low, medium or high risk. See the diagram below for details.

dashboardpt4_9

13. Give the chart a Data Table. From the “Design” tab, click on “Add Chart Element”. Click on “Data Table” and click on “No Legend Keys”. You should get a chart formatted close to that of the figure below.

dashboardpt4_10

14. The chart would be clearer with a title. Click on “Add Chart Element” again and click on “Chart Title” and “Above Chart”.

dashboardpt4_11

15. When you click on your new chart, it now has the name “Chart Title”. Click in the title and change it to something descriptive like “Work Totals by Risk Level”.

[image33.png]

16. You can now format the chart to whatever chart type works for you by clicking on the chart and choosing “Change Chart Type” from the “Design” tab in “Chart Tools”. If you wish to replicate the format of the charts at the beginning of this blog entry, those were “3-D Column.”

17. If you wish to add a “Cost Totals by Risk Level” chart, follow the same steps as steps 10 through 16, but use “Actual Cost”, “Remaining Cost” and “Cost” fields from the “Field List”. You will need to modify the new chart’s title and possibly position the charts by clicking and dragging them where you want them.

Time to experiment!

Now that you have tried creating custom reports, experiment with them! Powerful options are a click away. Try inserting a table to the report you just made. Try inserting a picture. These reporting elements and more are waiting for your discovery in the “Design” tab and in the “Insert” command group.

Projects can be risky business. In this four-part series you have learned a very basic technique to identify, assess and convey the state of risks in your project. You have created custom fields in custom tables. You’ve created a formula that drives graphical indicators, learned in-field and custom grouping and created a custom report that makes visible the work and costs of a project in terms of risk levels.

Your next challenge is to manage project risk relentlessly by continually re-evaluating risk, keeping risk data current, and making data-informed decisions to moving forward.

Did you enjoy this series? I sincerely hope that they were helpful. If so, please leave a comment! I love to hear from MPUG members!

Written by Sam Huffman
Sam Huffman first gained insight into Microsoft Project while working as a member of the MS Project development and support team. He has maintained his depth of knowledge of MS Project with each release and is a leading authority in the use and features of MS Project, Project Server and Project Online. Since the early 1990's Sam has honed his instruction skills by delivering training programs to thousands every year. Sam is a frequent content contributor to the Microsoft Project User Group (MPUG) and speaks to groups often about MS Project, Enterprise Project Management and the discipline of Project Management. He was awarded Microsoft Most Valuable Professional from 2010-2017. Check out his blog on MS Project. The softcover version of my newest book Microsoft® Project Do’s and Don’ts is now available for purchase! It is portable, brief and to the point so you can find help when you need it. Through tips, best practices and examples it will help you jumpstart your project!
Share This Post
Have your say!
00
1 Comment
  1. While Sam certainly knows how to make MSP jump through hoops, it is not clear to me what the user can properly conclude from the information so impressively displayed.

    In fact I think the basic premise of qualitative risk analysis is hopelessly flawed. I strongly recommend Douglas Hubbard’s book “The Failure of Risk Management” in which he suggests that such approaches are not just useless but potentially counterproductive.

Leave a Reply