Excel Template
The data for the Risk Register Power BI Report is pulled from the Risk Register Excel Template. The Excel template is stored in a cloud location for easy automated refresh and to act as a collaborative source-of-truth. The Excel template has the following columns:
Risk ID
Unique identifier for the risk row.
M-01
Risk Description
Plain-language description of the risk.
Yes
Risk Category
Category, e.g. Endpoint Security, Cloud Security, Compliance.
08/26/2025
Date Opened
When the risk was first recorded.
08/31/2025
Risk Decision Date
When a treatment decision was made.
Implementation
Date Last Updated
Most recent modification date.
Percent of workstations covered by endpoint detection and response (EDR)
Risk Owner (Individual)
Name of the person accountable for the risk.
Endpoint Security
Inherent Risk Probability
1–5 scale text, e.g. 4 - Likely (see Section 7).
Implementation of EDR
Inherent Risk Impact
1–5 scale text, e.g. 5 - Severe (see Section 7).
Number of workstations covered by EDR / Total workstations
Target Risk Probability
1–5 scale text. Probability after planned controls.
0.95
Target Risk Impact
1–5 scale text. Impact after planned controls.
14
Risk Response Type
One of: Mitigate, Accept, Transfer, Avoid.
Mitchell Telatnik
Risk Response Controls
Free-text description of the planned controls.
CrowdStrike, CMDB
Risk Response Due Date
Deadline for the response action.
Percentage
Cost of Mitigations
Estimated cost in your currency unit.
Higher
Compensating Controls
One of: Full, Partial, None.
02/15/2026
Residual Risk Probability
1–5 scale text. Actual probability after controls.
Not driving actionable value
Residual Risk Impact
1–5 scale text. Actual impact after controls.
Risk Status
One of: Open, Closed.
Notes
Free-text additional notes.
Adding Columns
You can additional columns to the end of the table to capture additional details related to risks. When loaded into the Power BI Template, these columns will carry through into the data model for you to use, however they will not appear as a filter or in visuals out of the box and must be customized.
Last updated