Setup Guide

Contents

The Security Metrics Toolkit contains two files:

1. Security Metrics Excel Template (.xlxs)

2. Security Metrics PowerBI Template (.pbit)

The Security Metrics Excel Template comes preloaded with demo data, meaning you can hook it up to the PowerBI template right away. Keep in mind, you will need to replace the content of the Excel file to load in your data.

Note: This quick start guide assumes you already have Microsoft PowerBI Desktop installed. If you do not, you can download it free from Microsoft.

1) Host the Excel Template in Cloud Storage

You will need to fill out the Excel Template: Documentation

Upload the Excel Template to one of the following cloud storage solutions:

• Microsoft Teams

• Microsoft SharePoint

• Microsoft OneDrive

File Path

The file path is not the URL or link to the file

After, note the path to reach the file. The easiest way to find this is by opening the Excel Template in the desktop application. Ensure you are opening the file from the cloud storage location and not the local device.

Then, in the Excel desktop application, go to "File" > "Recent" > Right click on the file > "Copy path to clipboard."

Paste the copied path into a text editor and remove the suffix "?web=1" so that the path ends with the file extension.

2) Open the PowerBI Template

Ensure you removed the suffix "?web=1" from the path before entering it into PowerBI.

Navigate to the PowerBI Template file (.pbit) and open it in Microsoft PowerBI Desktop. After opening, PowerBI will prompt you for the filepath we gathered in step 1. Paste the filepath and click okay. PowerBI will then load in and transform the data.

3) Save the PowerBI Report

Go to "file" > "save as" and save the PowerBI report. This will save it as a .pbix file. If you want to setup another security metrics report, simply repeat the first two steps.