Pointy Clicky Excel, Power Query, Fabric Workshop PART3

Oct 31, 2024 Pre-SIMPLY CYBERCON #GRC Workshop

Author

Steve McMichael
October 28, 2024

How to Make a Cyber Risk Scorecard That Wins Hearts and Minds

Oct 31 Pre-SIMPLY CYBERCON #GRC Workshop

www.cpatocybersecurity.com/p/pre-simplycybercon2024

Agenda

Step 17: Add scores to your template with XLOOKUP

=XLOOKUP([@Category], tblEquifax2021[[#All],[CSF Outcome ID]], tblEquifax2021[[#All],[Actual Score]], "No Match")

  • XLookup to tblEquifax2021 actual scores

Step 18: Add formulas for Gap to Target Columns

Step 19: Add Conditional Formatting

Step 20: Make a Pivot Table and Bar Chart, by CSF Function

Insert > Pivot Table

Step 21: Make a Radar Pivot Chart, by CSF Function

  • Adjust the series bounds to range from 0 to 8

Colo(u)r Palate for Charts

Green

B2D9B2

Yellow

FFFFB3

Red

FFB3B5

Adjust the order of the layers and the opacity

Step 22: Copy the Tab, and Present by Category

Step 23 (Bonus): 2-D Column Chart with 100% Series Overlap

Step 24: 🗣️ Communicate Your Top Five Cyber Risks!

Scorecard Template