The main problem that was being solved with this tool was the need for automated reporting. Everything prior to these scripts would be generated into a PowerBi dashboard and then sent over to the client. The main question that would be brought up is… “Can we have this information in a PDF format?”. At the time, the only way to create a PDF report is to take a screenshot of the PowerBI Dashboard and then past the images into a Word document to be provided to the client.
The solution to this problem was to grab all of the data that was present in our PowerBI dashboard (Log Analytics, Nessus, Dark Web), house this information in a MySQL database for processing, and export to an automated reporting software (BrightGauge).
How was this application built?
| Technologies Used | Python, PowerShell, PowerBI, MySQL, BrightGauge, Github |
| Type of Project | Professional |
| Role | Main Designer |
| Time to Completion | 3 Months |
Features Used
- Ingests the following data in from multiple different sources to be processed at the beginning of the month.
- Dark Web Monitoring
- Log Analytics Data (for processing)
- Nessus Data
- Microsoft Graph data (Licensing numbers / total users)
Things Learned
- Further understanding of Microsoft’s APIs and technologies when it comes to Azure Sentinel, Azure Active Directory, and Microsoft Graph.
- Got a better understanding of the Software Development Lifecycle and working with upper management to get requirements needed to complete this project.
Johnathon Kelley's Portfolio 