3-part series: PowerShell for Audit, Compliance and Security Automation and Visualization Part 3: Beyond CSVs - Visualization using PowerShell, Excel and Grafana

  • Thursday, 21 Jan 2021 10:30AM EST (21 Jan 2021 15:30 UTC)
  • Speaker: Clay Risenhoover

ZIP file full of CSVs. In this session, we will explore how to use data extracted from our environments to present tactical and strategic visualizations to the organization. Beginning with ad-hoc, tactical, automated import into Microsoft Excel for use in pivot tables and charts, we will then move on to using dashboard tools like Grafana to visualize trends in measurements over time. The session will focus on demonstrations of the techniques discussed.

Objectives

  • Use the ImportExcel PowerShell module to build functional spreadsheets from scripts
  • Use PowerShell to format data for import into time-series databases
  • Use Grafana to display time-series data in dashboards

Part 1: Introduction to Automation with PowerShell

Part 2: Audit and Compliance Data Acquisition with PowerShell