Data Science Collective

Advice, insights, and ideas from the Medium data science community

Member-only story

Create GPTs to Automate Supply Chain Analytics

Samir Saci
Data Science Collective
13 min readDec 6, 2023

--

A diagram showing the relationship between Excel file input, data analysis, and communication processes. It depicts a workflow automated with a custom GPT where an Excel file leads to the automation of decision-making processes for supply chain optimization. The output involves a GPT called Supply Chain nalyst performing classification tasks, with the final result displayed in an understandable format for communication.
Create GPTs to Automate Supply Chain Analytics — (Image by Author)

ABC Analysis in Supply Chain Management can be defined as a strategic product categorization method used for demand planning and inventory management.

In a previous article, I described the methodology I used to automate this analysis using a web application deployed on the cloud.

A process flow diagram for the ABC analysis in Supply Chain visualizing steps from Excel data input to analysis and filtering using sliders. It illustrates how data is classified and analyzed into distinct categories (A, B, C) based on selected variables, which supports decision-making.
ABC Analysis Simplified in 3 Steps — (Image by Author)

This app gathered 1,000+ users with excellent feedback from Supply Chain Professionals and Data Scientists.

As a next step, I wanted to explore the idea of improving the user experience using a Large Language Model agent as an interface with users.

My first experiment involved designing an automated supply chain control tower connected to a database using the LangChain framework.

A diagram showing an automated supply chain control tower workflow with GPT and Langchain starting with ambiguous input (represented by question marks), proceeding through SQL queries, machine learning analysis, and generating insights that are communicated to users in an understandable form.
Supply Chain Control Tower Agent with LangChain SQL Agent [Article Link] — (Image by Author)

--

--

Data Science Collective
Data Science Collective

Published in Data Science Collective

Advice, insights, and ideas from the Medium data science community

Samir Saci
Samir Saci

Written by Samir Saci

Top Supply Chain Analytics Writer — Case studies using Data Science for Supply Chain Sustainability 🌳 and Productivity: https://bit.ly/supply-chain-cheat

No responses yet