Automate the distribution of supply chain operational reports with visuals built in HTML emails with Python
Automate the decision-making process for the yearly budget allocation of an International Logistics Company.
In this Article,we will build a fully automated solution to share a one-page operational report in an HTML email using Python.
60+ case studies with source code, dummy data and mathematical concepts here 👉 Analytics Cheat Sheet
Click on the image below to access a full tutorial video to understand the concept behind this solution
You are a continuous improvement manager in an international clothing group that has stores all around the world.
The company is producing garments, bags and accessories in factories located in Asia.
Stores are delivered from local warehouses that are directly replenished by factories.
On a regular basis, you have to share warehouse operational indicators with your management.
This is a manual process in which you need to
- Extract data from the Warehouse Management System (WMS)
- Process data and built visuals with Excel
- Send a short report by email with the visuals and comments
To be efficient, you would like to automate this process using Python.
Your solution will be a simple python script, deployed on the cloud, that will automatically perform these four steps:
- Extract prepared order lines of last week from the WMS SQL database
- Process the data and compute KPIs with key insights
- Automatically send an HTML email with visuals and comments
This repository code you will find all the code used to explain the concepts presented in the article.
Senior Supply Chain Engineer with an international experience working on Logistics and Transportation operations.
Have a look at my portfolio: Data Science for Supply Chain Portfolio
Data Science for Warehousing📦, Transportation 🚚 and Demand Forecasting 📈