Supply Chain Order Analysis
The Supply Chain Order Analysis project focuses on analyzing sales and canceled orders from a supply chain dataset. It uses SQL to extract insights from two CSV files- “canceled_test.csv” and “sales_test.csv” which include data such as order numbers, customer IDs, item details, and the number of units ordered and shipped. The project involves performing volume analysis, service level calculations, and ABC classification to classify items based on their contribution to total sales. Through this project, key supply chain metrics like order fulfillment, customer behavior, and cancellation patterns are analyzed, helping identify inefficiencies and trends for further optimization.
I downloarded the dataset from Kaggle.
You can downloard and practice it too.
Link- https://www.kaggle.com/datasets/annelee1/supply-chain-cel-dataset
Or
Don't stress so much, I am giving you the files
https://github.com/mdntarif/SQL-Supply-Chain-Order-Analysis