Having well-defined workflows is crucial for any organization as these directly impact operational efficiency and the quality of decision-making. Standardized processes ensure tasks are performed consistently, minimizing human errors and facilitating the onboarding of new personnel. In this context, the SRK office in Colombia has achieved a significant breakthrough by integrating automated workflows and transforming data collection and processing.
The development begins with field data collection using third-party software like Survey123. Supervisors fill out detailed surveys on tablets, recording daily activities, volumes and observations. Once completed, the surveys are sent to a cloud-based database, a trigger is activated, and an automated workflow linked with a Power Automate and Gsheet is run. This workflow not only generates a PDF report sent via email, but also updates databases and dashboards in Power BI in real time.
The implementation of this system has had an immediate impact. The data is accurate and consistent, eliminating human error thanks to the use of multiple-choice lists and predefined fields. Moreover, the automation of workflows has standardized processes, ensuring that any new team member can quickly adapt to the established procedures without relying solely on personal criteria. This optimizes data collection and report delivery, maintaining uniformity and quality in procedures.
The next step in this implementation is to expand the use of this development to laboratory tests. The plan is to develop dynamic surveys that adapt based on responses, ensuring the necessary data for each type of test is collected. This will improve data accuracy and ensure that reports and dashboards reflect the most up-to-date information in real time.
Contact the authors in the SRK Colombia office
