Here are a few suggestions:Ĭreate charts to consolidate the information, such as “Risks by Category” or “Number of Risks Assigned by Resource.”Īdd slicers to the report to allow people to filter the data. To make effective use of the available data, you can create additional visualizations to increase the understanding of your report. Layout Adjustments and Final Considerations For example, we can see that the highest proportion of risks is concentrated in an area with medium impact and low probability (36 items), while the second highest concentration of risks hase medium impact and medium probability (20 items). Through this matrix you can easily identify how the risks are distributed. The table above shows the distribution of all the existing risks that have been created in the existing portfolio, combining their impact and probability. Now, repeat the steps for each possible combination in the risk matrix table to get your result: You can close the function to see the result: Finally, you need to determine the criteria to be applied, which will be available in the layers combination:.This time you will select the Probability column: While still in the COUNTIFS function, move to the next argument, which will be represented by the criteria_range2.This stipulates that for each row in the impact column, Excel will only consider values that are greater than or equal to 7. As you use the Impact column, you’ll need to determine the criteria by using the information that has been organized in the layers: Here you need to determine which criteria will be applied to the first range that has been selected. While still in the COUNTIFS function, go to the next argument (criteria1).As the first criteria_range, use the Impact column from the risks list tab: Place the cursor in the cell that represents the high impact vs.Use the screenshots below as a reference: You’ll then have to use the COUNTIFS function to count the number of items in accordance with the combination of impact and probability. Create your risk matrix table as follows: Once you have created the layers that will be used on the report, in Excel add a new tab. Notice that the layers will be very important, because they’ll be used as the reference for counting the risks according to each possible combination.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |