Analysis of the portfolio risk register in MS Excel

Contents:

1. Analysis of the server portfolio risk register in MS Excel
2. Formation of a portfolio risk management plan in MS Excel
3. Setting up the "Analysis of the portfolio risk register in MS Excel" dashboard in MS Excel
4. Chat

Analysis of the server portfolio risk register in MS Excel

Several approaches can be used for practical implementation of calculating the priority of portfolio risks:

• Products of probability and impact (in points) of risks. The higher the obtained value, the higher the priority of the risks.
• Product of probability and impact in risk costs. The obtained value shows the company's losses when risks occur. Based on this value, a reserve for portfolio risks is formed.

The probability and impact matrix allows you to display portfolio risks by location on the graph. The greater the probability and impact of a risk on the portfolio the more attention should be paid to managing this risk.

The impact and probability matrix allows you to select the most priority risks. In the future, the project teams spends more time analyzing priority risks, which allows you to plan the team's time more effectively.

A more detailed description of risks allows for an assessment using the costs of minimizing negative consequences. The probability of risk occurrence is measured in percentages, and the impact in the costs of implementing measures to minimize negative consequences.

The use of this matrix at this stage allows for a more accurate determination of the risks that need to be addressed when implementing the portfolio.

Formation of a portfolio risk management plan in MS Excel

Developing response methods - defining sequences of actions that allow using positive opportunities and countering threats.

The risk management plan includes two groups of activities:

• Mitigation plan. The activities described in this group are implemented from the project budget and should be immediately included in the project.
• Contingency plan. The activities described in this group are implemented from the project reserves. With clearly defined reserves of 15-20% of the projects budget, it is necessary to select the most significant risks. These activities are included in the plan in the event of a risk event. If the project team managed to prevent the risks, the funds for the implementation of this event go to the team's motivation fund.

Setting up the "Analysis of the portfolio risk register" dashboard in MS Excel

How to get the "Analysis of the portfolio risk register" dashboard in MS Excel

1. Register or log in to the site.
2. Make a payment.
3. Download the file with the document.

Load MS Excel and log in with your account

1. Open the report in MS excel
2. Go to the “Data” menu, the “Get data” item and the “Launch Power Query editor” sub-item
3. Change the server address for the table.
4. To do this, click on the “Source” item and replace the line “https://studyoberemokii.sharepoint.com/sites/en/” with the address of your server.
5. Go to the “Home” menu item and the “Update preview” sub-item.
6. Go through all the steps and update the column names in the queries
7. In the same “Home” item, click the “Close and Apply” button