List: Automation (RPA) | Curated by Samir Saci | Medium

Oct 24, 2024

13 stories

1 save

Automation (RPA)

Automate Manualt Tasks with Python/VBA

Samir Saci

What Is RPA? Robotic Process Automation

Use Python to automate business processes, process transactions, and communicate with other digital systems

Aug 5, 2023

A diagram illustrating the automation of invoice processing using Robotic Process Automation (RPA). The process begins with multiple invoices in PDF format, which are then processed using Python. The data from the invoices is extracted and entered into an Excel file, followed by validation and uploading to a digital system. The diagram shows Python at the center, automating the data extraction, validation, and uploading of invoice data into a structured format, improving efficiency.

Aug 5, 2023

In

TDS Archive

by

Samir Saci

Automate Video Editing with Python

Automate the editing of explainer videos to create shorts with text-to-speech comments for the training of warehouse operators.

Nov 10, 2022

Flowchart showing the process of automating video editing with Python. The raw video is processed by muting the background music and cutting the video into shorter clips. Each short video is then paired with text-to-speech comments, creating three distinct clips, ‘Short 1’, ‘Short 2’, and ‘Short 3’, each with its corresponding comment.

Nov 10, 2022

In

DataDrivenInvestor

by

Samir Saci

SAP Automation for Retail

Design RPA solutions using Visual Basic scripts built with SAP GUI Scripting Tool

Jul 29, 2020

SAP Automation for Retail

Jul 29, 2020

In

DataDrivenInvestor

by

Samir Saci

SAP Automation of Product Listing for Retail

Automate Product Listing in SAP with SAP GUI Scripting Tool using Visual Basic

Jul 29, 2020

SAP Automation of Product Listing for Retail

Jul 29, 2020

In

DataDrivenInvestor

by

Samir Saci

SAP Automation of Orders Creation for Retail

Automate Purchase Order Creation in SAP with SAP GUI Scripting Tool using Visual Basic

Jul 29, 2020

SAP Automation of Orders Creation for Retail

Jul 29, 2020

Samir Saci

Build a GPS Routing API with Python Flask

Create a free Distance Matrix API using Python Flask with a Selenium bot deployed on the cloud

Mar 14, 2021

Build a GPS Routing API with Python Flask

Mar 14, 2021

In

DataDrivenInvestor

by

Samir Saci

Automate Outlook Email Back-Up with VBA

Generate emails back-up in HTML format that can be read without Outlook Account

Mar 26, 2021

Automate Outlook Email Back-Up with VBA

Mar 26, 2021

In

TDS Archive

by

Samir Saci

Build Excel Automation Tools with Python

Design of Excel Automation Tools for Sales Analytics ready to be used by your colleagues without any prior knowledge of Python

Apr 17, 2021

The image titled ‘Design Automation Tools for Excel Users’ illustrates four steps to create Excel automation tools for sales analytics using Python. The first step is ‘Data Analysis to Provide Insights’ represented by a chart icon. The second step is ‘Automate the Calculation Using Python,’ symbolized by a calculator. The third step shows ‘Export Your Python Code in Executable File (.exe)’ with a robot icon, and the fourth step is ‘Share Your File with Your Colleagues’ with a sharing icon.

Apr 17, 2021

In

TDS Archive

by

Samir Saci

Automate Accounting Tasks using Python

Build Solutions to Automate Repetitive Tasks for Financial Audits and Share them with Your Finance Colleagues to Improve their Productivity

Apr 27, 2021

The image titled ‘Design Automation Tools for Excel Users’ illustrates four steps to create Excel automation tools for sales analytics using Python. The first step is ‘Data Analysis to Provide Insights’ represented by a chart icon. The second step is ‘Automate the Calculation Using Python,’ symbolized by a calculator. The third step shows ‘Export Your Python Code in Executable File (.exe)’ with a robot icon, and the fourth step is ‘Share Your File with Your Colleagues’ with a sharing icon.

Apr 27, 2021

In

TDS Archive

by

Samir Saci

Automate Budget Planning Using Linear Programming

Select the projects that maximize the return on investment and follow the management guidelines while respecting budget constraints.

Jan 7, 2022

Budget planning problem for selecting projects with maximum ROI using linear programming with Python, showing cost and ROI comparison for Electric Trucks, Voice Picking, and Space Rental projects over 3 years. The image highlights financial projections, CO2 emissions, productivity improvements, and business opportunities.

Jan 7, 2022

In

TDS Archive

by

Samir Saci

Excel Automation Tools for User-Friendly Reports with XlsxWriter

Automate excel report creation with python by writing explicit excel formulas that any Excel user can read.

Aug 16, 2022

A group of three people sitting around a wooden table with laptops. One person is working on a laptop displaying a calendar or scheduling tool in an Excel-like interface. The individual is holding a coffee cup while taking notes. This image illustrates a collaborative working environment where team members are discussing or reviewing data on their laptops.

Aug 16, 2022

In

TDS Archive

by

Samir Saci

Automate Operational Reports Distribution in HTML Emails using Python

Automate the distribution of supply chain operational reports with visuals built in HTML emails with Python.

Sep 7, 2022

This diagram outlines the process for automating a weekly operational report creation and email distribution using Python. It begins with data extraction from a Warehouse Management System (WMS) database, continues through SQL queries to extract prepared order lines, followed by Python scripts that calculate key performance indicators (KPIs), and ends with an automated report delivered by email, including visuals created in the HTML report.

Sep 7, 2022

In

TDS Archive

by

Samir Saci

Automate Flash Cards Creation for Language Learning with Python

My experience using Python to support my long journey in learning Mandarin as a native French speaker.

Sep 15, 2022

Flowchart illustrating the process of validating language learning flashcards in Mandarin using Python. The process starts with a translation of the word into Mandarin (超市 for ‘supermarket’), followed by a phonetic check (pinyin ‘Chāoshì’). If both translation and phonetics are correct, the learner proceeds to the oral test. If the learner’s oral pronunciation is correct, they move on to the next flashcard. Failures at any stage lead to review and retry.

Sep 15, 2022