FOR CYBER SECURITY TEAM
In addition to changing the way we input our metrics, improving the user interface design of our SharePoint site was key. I created a landing page where team members could easily access the metrics input form and other frequently used items
How might we simplify the data entry process in order to reduce the amount of time team members spend maintaining spreadsheets?
New inputs are easily captured using Microsoft Forms and inputs are automatically recorded in a SharePoint list using Microsoft Flow
After inputs are recorded, MS Flow generates a series of notifications and a connection between the SharePoint list and MS PowerBI automatically updates a data visualization
Using conditional logic, MS Flow creates a post in a specific team and channel and sends an email in Outlook
This video shows the entire process from form entry to visualization in Power BI