The latest articles on DEV Community by alexander valencia (@aljutupapa). https://dev.to/aljutupapa https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F24324%2Ff502d338-10ad-429a-ad6a-31169497cd44.png https://dev.to/aljutupapa en alexander valencia Sun, 04 May 2025 14:09:35 +0000 https://dev.to/aljutupapa/-data-cleaning-process-modeling-with-bpmn-and-bizagi-2f78 https://dev.to/aljutupapa/-data-cleaning-process-modeling-with-bpmn-and-bizagi-2f78 <h2> 🎯 The Challenge </h2> <p>Clean a sales dataset using Python and Pandas. The process included: </p> <ul> <li>Uploading a CSV file </li> <li>Detecting outliers with IQR </li> <li>Deploying to AWS S3 </li> <li>Optional S3 verification </li> </ul> <h2> 🧩 BPMN Diagram </h2> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnrmmyml2lt38ij4g4wbi.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnrmmyml2lt38ij4g4wbi.png" alt="BPMN Diagram" width="800" height="556"></a> </p> <h2> 💡 Key Learnings </h2> <ul> <li> <strong>BizAgi Modeler</strong> helped visualize the flow. </li> <li> <strong>GitHub Actions</strong> automated the AWS deployment. </li> </ul> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F8xtw3lwh03aixe41viza.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F8xtw3lwh03aixe41viza.png" alt="AWS S3" width="800" height="380"></a></p> <h2> 🔗 Project Repository </h2> <p><a href="https://github.com/jotalexvalencia/limpieza-datos-python-pandas" rel="noopener noreferrer">GitHub - Data Cleaning with Python</a></p> programming python aws bpmn alexander valencia Sun, 04 May 2025 13:22:40 +0000 https://dev.to/aljutupapa/modelando-procesos-de-limpieza-de-datos-con-bpmn-y-bizagi-2fpa https://dev.to/aljutupapa/modelando-procesos-de-limpieza-de-datos-con-bpmn-y-bizagi-2fpa <p>Como desarrollador con 9+ años de experiencia, recientemente apliqué <strong>BPMN 2.0</strong> para automatizar la limpieza de datos en un proyecto crítico. Aquí explico cómo lo hice: </p> <h2> 🎯 El Reto </h2> <p>Limpiar un Dataset de ventas usando Python y Pandas. El proceso incluyó: </p> <ul> <li>Subir un archivo CSV </li> <li>Detectar outliers con IQR </li> <li>Desplegar en AWS S3 </li> <li>Verificación opcional en S3 </li> </ul> <h2> 🧩 Diagrama BPMN </h2> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdrzspix9kppn8hxivm9m.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdrzspix9kppn8hxivm9m.png" alt="Diagrama BPMN" width="800" height="556"></a> </p> <h2> 💡 Aprendizajes Clave </h2> <ul> <li> <strong>BizAgi Modeler</strong> me ayudó a visualizar el flujo. </li> <li> <strong>GitHub Actions</strong> automatizó el despliegue en AWS. </li> </ul> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fczo1nuqym28tg4wvvslm.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fczo1nuqym28tg4wvvslm.png" alt="AWS S3" width="800" height="380"></a> </p> <h2> 🔗 Repositorio del Proyecto </h2> <p><a href="https://github.com/jotalexvalencia/limpieza-datos-python-pandas" rel="noopener noreferrer">GitHub - Limpieza de Datos con Python</a></p> programming python aws bpmn