Plataforma de documentación y automatización del registro de auditorías internas para la empresa Pares& Alvarez.
Loading...
Date
2024
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Universidad de Concepción
Abstract
Este proyecto se enfoca en el desarrollo e implementación de una plataforma innovadora para la documentación y registro de auditorías internas en la empresa Pares&Alvarez. Utilizando una combinación de herramientas del ecosistema de Microsoft 365, como Power Apps, Power Automate, Power BI y SharePoint, se ha logrado crear una solución integral que permite consolidar, visualizar y analizar los datos de auditorías de manera eficiente. Esta plataforma no solo busca mejorar la eficiencia operativa, sino que el principal objetivo es facilitar la toma de decisiones en la empresa.
Pares&Alvarez enfrentaba desafíos en la gestión y registro de sus auditorías internas debido a la falta de un sistema centralizado de datos. Este problema se traduce en dificultades para el análisis de datos y problemas con el cumplimiento normativo.
El principal objetivo del proyecto es diseñar una plataforma que integrará la base histórica de las auditorías internas, facilitando su análisis y utilización para la toma de decisiones. Se busca crear una herramienta que no solo mejore la eficiencia operativa, sino que también promueva la cultura de calidad y mejora continua dentro de la organización. Para lograr esto se utilizaron diversas herramientas del universo de Microsoft 365, destacando SharePoint como la columna vertebral del proyecto y Power BI como la herramienta clave para el análisis de datos.
Como resultados, la plataforma ha permitido una mejora en la eficiencia del equipo mediante la automatización con Power Apps y Power Automate, reduciendo tiempo y esfuerzo manual necesario para registrar y procesar datos de auditorías. También se logró la centralización de datos en SharePoint y se espera que la plataforma creada en Power BI con visualizaciones interactivas de datos, mejore la toma de decisiones estratégicas y asegure un mejor cumplimiento normativo.
La implementación de tecnologías avanzadas y la automatización de procesos han situado a Pares&Alvarez a la vanguardia en el uso de herramientas de gestión de auditorías. Este proyecto no solo ha mejorado la eficiencia y precisión en el manejo de datos, sino que también ha sentado las bases para futuras innovaciones.
This project focuses on the development and implementation of an innovative platform for the documentation and recording of internal audits at Pares&Alvarez. By utilizing a combination of tools from the Microsoft 365 ecosystem, such as Power Apps, Power Automate, Power BI, and SharePoint, we have created a comprehensive solution that consolidates, visualizes, and analyzes audit data efficiently. This platform not only aims to enhance operational efficiency but also primarily seeks to facilitate decision-making within the company. Pares&Alvarez faced challenges in managing and recording their internal audits due to the lack of a centralized data system. This issue resulted in difficulties in data analysis and compliance with regulatory standards. The main objective of the project is to design a platform that integrates the historical database of internal audits, making it easier to analyze and use for decision-making. The aim is to create a tool that not only improves operational efficiency but also promotes a culture of quality and continuous improvement within the organization. To achieve this, various tools from the Microsoft 365 universe were used, with SharePoint serving as the backbone of the project and Power BI as the key tool for data analysis. As a result, the platform has improved team efficiency through automation with Power Apps and Power Automate, reducing the time and manual effort needed to record and process audit data. Data centralization in SharePoint was also achieved, and it is expected that the platform created in Power BI with interactive data visualizations will enhance strategic decision-making and ensure better regulatory compliance. The implementation of advanced technologies and process automation has positioned Pares&Alvarez at the forefront of using audit management tools. This project has not only improved efficiency and accuracy in data handling but also laid the foundation for future innovations.
This project focuses on the development and implementation of an innovative platform for the documentation and recording of internal audits at Pares&Alvarez. By utilizing a combination of tools from the Microsoft 365 ecosystem, such as Power Apps, Power Automate, Power BI, and SharePoint, we have created a comprehensive solution that consolidates, visualizes, and analyzes audit data efficiently. This platform not only aims to enhance operational efficiency but also primarily seeks to facilitate decision-making within the company. Pares&Alvarez faced challenges in managing and recording their internal audits due to the lack of a centralized data system. This issue resulted in difficulties in data analysis and compliance with regulatory standards. The main objective of the project is to design a platform that integrates the historical database of internal audits, making it easier to analyze and use for decision-making. The aim is to create a tool that not only improves operational efficiency but also promotes a culture of quality and continuous improvement within the organization. To achieve this, various tools from the Microsoft 365 universe were used, with SharePoint serving as the backbone of the project and Power BI as the key tool for data analysis. As a result, the platform has improved team efficiency through automation with Power Apps and Power Automate, reducing the time and manual effort needed to record and process audit data. Data centralization in SharePoint was also achieved, and it is expected that the platform created in Power BI with interactive data visualizations will enhance strategic decision-making and ensure better regulatory compliance. The implementation of advanced technologies and process automation has positioned Pares&Alvarez at the forefront of using audit management tools. This project has not only improved efficiency and accuracy in data handling but also laid the foundation for future innovations.
Description
Tesis presentada para optar al título de Ingeniero Civil Industrial
Keywords
Auditoría interna, Software computacional Desarrollo, Análisis estadístico de datos