Customer Segment: Federal Government Agency
The Challenge
Our client requires users to fill in an Excel spreadsheet detailing the application they want to use. It includes a matrix where the user enters scores about the app. Depending on that will determine if the app is considered a “Crown Jewel”. It then goes to our client for review and endorsement if a crown jewel. Essentially this app is to make it easier for users to answer questions and for our client to keep track of new apps that could potentially become crown jewels.
The following core features were identified:
- Data Collection: PowerApp is used to collect data on various systems.
- Data Normalization: The app can normalize the collected data into a standardized format to facilitate analysis and correlation, regardless of the source or format of the data.
- Data Enrichment: The app can enrich the collected data with additional context, such as threat intelligence, vulnerability information, and user identity, to enhance the accuracy and relevance of the analysis.
- Data Storage: SharePoint is used for Data storage.
- Data Visualization: The app can provide interactive dashboards and visualizations to help users analyze and explore the collected data. Power BI is used for this purpose.
Our development approach:
Data Sources: SharePoint was used as the data source to store the correspondence data.
Power Apps: Canvas app was created in Power Apps to allow users to interact with the corresponding data stored in the data source.
Power Automate: Power Automate was used to automate tasks such as sending notifications when new data is added, setting reminders for follow-up actions, or archiving old correspondence.
Power BI: Power BI was used to create dashboards and reports to provide insights into the correspondence data, such as the system vulnerability report. Current status of all apps showing cyber security status.
Integrations: The solution was integrated with UpGuard.
The Solution
The following have been delivered as part of the solution outcome:
- Developed high-level requirements
- Converted these requirements into detailed use cases and personas
- Developed detailed technical architecture
- Developed solutions in pre-defined iterations and regular demos were organised to get feedback from business stakeholders
- Developed a detailed training guide and conducted sessions
- Various Office 365 groups as part of the various roles in the workflow. In the context of the workflow, only specific users that fall under a certain Office 365 group can access different areas of the application and utilise specific functionality of the app. The connector is used to fetch & query these specific users falling under the respective Office 365 group.
SharePoint was used to store any attachments. Each workflow activity generates a folder in SharePoint to store relevant documents.
