SecureMetrics PowerBI Template Docs
  • 👋Welcome to the SecureMetrics!
  • NIST CSF 2.0
    • NIST CSF 2.0 User Guide
  • Attack Surface Discovery
    • Attack Surface Discovery User Guide
  • SecureMetrics Risk Register
    • 🛠️Getting set up
      • 📑Risk Register
      • 📊Installing the PowerBI App
      • 🪄Connecting your data
      • 🪪Understanding licensing
    • 🥳Neat PowerBI Features
  • Astra PowerBI Plugin
    • ✨Welcome to Astra
    • 📓Release Notes
    • 💻PowerBI Visual Architecture and Data Security
  • Multicloud CIS Benchmarks with Prowler
    • Page 1
  • CIS Controls Reporting
    • Getting Started
  • Assessment & Data Import File
  • PowerBI Slide Template
  • Cyber Risk Quantification (CRQ) Community Edition
    • Welcome to CRQ Community
  • Using the Template
  • Understanding FAIR Inputs
  • Cyber Risk Quantification (CRQ) Pro
    • Welcome to CRQ Pro
  • Excel Model
  • PowerBI Model Report
  • PowerPoint Charts Template
Powered by GitBook
On this page
  • Getting Started
  • Step 1 - Setting up the assessment input folder
  • Step 2 - Filling out the assessment input files
  • Step 3 - Loading the PowerBI Template
  1. NIST CSF 2.0

NIST CSF 2.0 User Guide

PreviousWelcome to the SecureMetrics!NextAttack Surface Discovery User Guide

Last updated 11 months ago

SecureMetrics' NIST CSF 2.0 PowerBI Template allows security teams or consultants to report on the maturity of an organization against the NIST Cybersecurity Framework (CSF) version 2.0.

Note: there are two license versions for the NIST CSF 2.0 Template: Internal & Consultant. There is no difference between the template, only the licensing terms.

Getting Started

When you purchase the NIST CSF 2.0 PowerBI Template, you will receive a download with the following items:

  1. PowerBI template file (.pbit)

  2. Excel assessment input template (.xlsx)

  3. Sample input Excel files (.xlsx)

The PowerBI template will use the Excel assessment input files to load assessment data into the dashboards. The PowerBI template will accept multiple assessment input files stored in a folder on the filesystem for continuous monitoring over time.

Step 1 - Setting up the assessment input folder

You'll need to store all the assessment input files (.xlsx) that you wish to import into the dashboard in a single folder on the file system.

  1. Create a new folder on your computer in a convenient place such as "Documents"

  2. Note the full filepath of the folder, as you'll be prompted for this when we load the PowerBI dashboard

Step 2 - Filling out the assessment input files

Each assessment date will utilize it's own excel input file. All input files stored in the folder you created will be ingested into the PowerBI dashboard. If you are just getting started, you may only have one assessment completed. However, over time you'll be able to monitor for changes over time as you add additional assessment files.

Note: three sample assessment input files are included. You can move these to your assessment input folder if you would like to test functionality without creating assessment input files

  1. Open the Excel assessment input file (.xlsx)

  2. Fill out the required columns

  3. Save the file into the assessment input folder

Step 3 - Loading the PowerBI Template

Note: Three parameters are prompted for when opening the template. The first parameter is the full filepath of the data import folder. The remaining parameters, "Ignore" and "Also Ignore" should not be changed.

  1. Open the PowerBI template file (.pbit)

  2. You will be prompted to input the full filepath of the folder from step 1

  3. Dashboards & datamodel will be populated with data

  4. Save the file as a .pbix file to save the report

That's it!

You can now either use the dashboard locally in PowerBI Desktop, or publish to the PowerBI Service to host in the cloud.

Setting up the assessment input folder
Filling out the Excel assessment input file (.xlsx)
Storing assessment files in the folder
Loading assessment data into PowerBI