When I joined the Real-Time Systems Security Engineering team at Exelon, I was asked to look at the way the team measures and reports work. It became immediately apparent that the biggest pain point in the process was data entry. There was not a consistent, user friendly way to input data. I developed a form to capture inputs and used applications in the Microsoft suite to create an automatic flow of information from input to visualization. The process uses Forms, SharePoint lists, PowerBI, and Teams.
NEW DATA IS INPUT USING MICROSOFT FORMS
NEW DATA IS STORED IN A SHAREPOINT FORM
=MICROSOFT FLOW MOVES THE DATA THROUGH THE PROCESS