A leading Food and Beverage culinary chain automates its incident management process, guaranteeing a secure work environment using Power Apps| PreludeSys

About the client

The client is a food and beverage manufacturing company serving as the innovative culinary driving force behind well-known retail brands like Panera and Legal Sea Foods. With a network of outlets spanning the United States of America, they are headquartered in Massachusetts, and their production facilities are located in Texas and Oregon.


Client challenges
  1. The existing incident management application faced storage limitations within the access database. This constraint hindered the efficient capture and retention of injury and incident data across production and safety teams.
  2. The client encountered difficulties with a manual process for tracking data using different form types used by their production and safety teams. This manual approach proved time-consuming and increased the likelihood of errors and inconsistencies in data entry.
  3. The absence of a robust enterprise analytics system in their current incident access database posed a significant challenge. This limitation hindered the client’s ability to derive meaningful insights from the captured injury and incident data, impacting their decision-making and overall safety management.
Solution
  • Automated Incident Management Process: PreludeSys experts introduced a simple, automated incident management process tailored to the client’s needs.
  • Canvas Power Apps Application Design: The team designed a Canvas Power Apps application that allows production and safety teams to create forms based on the nature of their work and safety guidelines.
  • User-Friendly Interface for Multiple Facilities: The Power Apps application offers a user-friendly interface, enabling users from multiple facilities to log in, select their facility, and input the required information seamlessly.
  • Centralized Storage in SQL Server Database: Incident data is now stored in a centralized SQL Server database, addressing storage limitations and facilitating efficient data management.
  • Enterprise Analytics Integration: The centralized storage solution enables enterprise analytics and provides the client with valuable insights and the ability to track employee well-being, fostering a safe and healthy workplace.
  • Secure Incident Report Storage: The Power Apps application securely stores all incident reports, allowing authorized users to view, edit, and delete records as needed, ensuring data integrity and compliance with privacy and security measures.
Results at a glance
Expanded storage capacity and streamlined form processes Enhanced data security in a centralized warehouse Implementation of Enterprise Analytics System
Benefits
  • Effective incident tracking and management using the Power Apps Canvas
  • Automation of workflows of production and safety teams for increased efficiency and accuracy.
  • Smooth data transfer between the incident management application and a centralized SQL Server, facilitating organized data storage for interpretation and analytics purposes.
Technology

Power Apps – Model Driven and Canvas Application