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

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

This material is directly related to Clay's brand new course SEC557: Continuous Automation for Enterprise and Cloud Compliance