The Ask
The client wanted an application to effectively manage risks within their organization by ensuring the implementation of appropriate controls.
The Challenge
The application was designed to enhance the process of assigning risks to owners within the organization, allowing for the incorporation of various controls to effectively manage these risks. It was also necessary to offer users a comprehensive overview of risks, organized and represented through pie charts and other visual tools to emphasize areas that need attention. Furthermore, an approval workflow was crucial to guarantee that relevant stakeholders were informed when new risks were recorded.
The Solution
We initiated the project by creating a fundamental data model, outlining the essential tables and their interconnections within the application. In partnership with a UX designer, we meticulously designed the layout and user flow to guarantee efficient screen navigation and optimal object positioning. After receiving client approval for the design, we proceeded to develop the application utilizing Microsoft Power Apps. To enhance the approval workflow, we incorporated Power Automate, facilitating automatic notifications through Outlook and Teams whenever risks were introduced or modified. For data visualization, we considered two strategies: integrating Power BI dashboards or producing visuals directly within the application.
The Outcome
Our systematic methodology led to the development of an intuitive application that effectively oversees risk distribution and control delegation. The incorporation of an automated approval process guarantees that essential stakeholders are kept updated, while the customized visual insights provide transparent, actionable information for enhanced risk management.