supply chain spend analytics dashboard overview

supply chain spend analytics dashboard overview
supply chain spend analytics dashboard overview thumbnail 1
supply chain spend analytics dashboard overview thumbnail 2
supply chain spend analytics dashboard overview thumbnail 3
supply chain spend analytics dashboard overview thumbnail 4

πŸ“Š Supply Chain / Spend Analytics Dashboard Overview

Focus Areas: Shipping Methods 🚚 | Product Categories πŸ“¦ | Supplier Performance 🧾
Period Covered: 2021–2023


✈️ 1. Shipping Method Spend

  • Air: $9.87M (highest spend)
  • Ground: $8.48M
  • Sea: $9.11M

πŸ“Œ Insight:
Air shipping leads in spend but only slightly edges out sea and ground. Assess trade-offs: speed vs. cost. Air may offer speed, but is the premium worth it?

πŸ“¦ 2. Spend by Product Subcategory

  • Top Subcategory: β€œQM” – $2.1M πŸ’° (likely high-priority)
  • Others: Range from $0.1M–$1.5M

πŸ“Œ Insight:
β€œQM” commands the largest share. Prioritize procurement optimization, supplier terms, and accurate demand forecasting here.

🧾 3. Supplier Spend Analysis

  • #1: C King-Rodriguez – $934.64K (9.47% of total) πŸ₯‡
  • Others: (e.g., Smith PLC, White and Sons): $400K–$600K (β‰ˆ4–6% each)
  • Long Tail: Dozens of smaller suppliers contributing <5% individually

πŸ“Œ Insight:
Consider supplier consolidation. Strengthening ties with high-spend partners may yield cost savings and improve operational synergy.

πŸ“¦πŸ”„ 4. Total Stock Received by Supplier

  • Repetitive data labels suggest unclear correlation
  • Spend vs. volume delivered needs clarity

πŸ“Œ Action:
Correlate inventory volumes with spend. Spot mismatches like high spend/low volume (or vice versa) to fix overstocking or supplier inefficiencies.


πŸ“Œ Key Recommendations

  • πŸš€ Optimize Shipping: Assess if air freight's premium brings enough value. Shift toward ground/sea where feasible.
  • 🀝 Supplier Rationalization: Focus on key suppliers like C King-Rodriguez for volume leverage, better pricing, and streamlined onboarding.
  • 🎯 Product Subcategory Focus: Double down on β€œQM” β€” deploy forecasting tools and dynamic reorder strategies to stay ahead.
  • πŸ“‰ Clarify Data Gaps: Refine metrics around stock received to ensure inventory aligns with actual spend and consumption.

Technologies Used

Other Projects

Telco Churn
Telco Churn
Telco churn refers to the rate at which customers discontinue their services with a telecommunications company-whether it's mobile, internet, cable TV, or bundled services. It's a critical KPI in the telecom industry because high churn rates = revenue leakage + brand instability.
Data-Science
Python
Scikit-learn
Pandas
Numpy
Tensorflow
Keras
Pytorch
View Project
Scraping Airbnb
Scraping Airbnb
This project demonstrates my ability to combine web scraping techniques with machine learning to classify images. The goal was to build a pipeline that scrapes images of shoes from a website and uses them for training a machine learning model.
WebScraping
BeautifulSoup
Selenium
Scrapy
View Project
Customers Transaction Analysis
Customers Transaction Analysis
A comprehensive database management system for a small business.
Database
SQL
MySQL
PostgreSQL
MongoDB
Pyspark
View Project
Bulldozer Sale Price Prediction
Bulldozer Sale Price Prediction
This project tackled a real-world business problem sourced from a Kaggle competition hosted by Caterpillar Inc. Using structured data containing product specifications, usage history, and transactional attributes, I built a machine learning pipeline capable of forecasting future equipment prices a key tool for optimizing resale strategy in capital-intensive industries.
Data-Science
Python
Scikit-learn
Pandas
Numpy
Tensorflow
Keras
Pytorch
View Project
Credit Score Prediction
Credit Score Prediction
This project focuses on building a predictive model to estimate an individual's credit score category-poor, Standard, or Good-based on financial and behavioral attributes. The goal is to assist financial institutions in automating credit risk assessment, improving loan approval decisions, and reducing default rates.
Data-Science
Python
Scikit-learn
Pandas
Numpy
Tensorflow
Keras
Pytorch
View Project
Customer Booking Prediction
Customer Booking Prediction
This Customer Booking Prediction project uses historical transaction data, customer behavior patterns, and contextual variables to forecast the likelihood and timing of future bookings. By applying machine learning models such as Logistic Regression, XGBoost, or Neural Networks, organizations can identify which customers are most likely to make a booking, when they are likely to do so, and what factors influence their decision
Data-Science
Python
Scikit-learn
Pandas
Numpy
Tensorflow
Keras
Pytorch
View Project
Bike Sharing Prediction
Bike Sharing Prediction
This project Bike Sharing Prediction leverages historical rental data, weather patterns, seasonal trends, and time-based variables to forecast future demand for shared bicycles. This predictive modeling process typically involves data preprocessing, feature engineering, and the application of machine learning algorithms such as Random Forest and Gradient Boosting
Data-Science
Python
Scikit-learn
Pandas
Numpy
Tensorflow
Keras
Pytorch
View Project
Customer Segmentation
Customer Segmentation
Developed a predictive classification model to determine the likelihood of a customer completing a booking. The project enables businesses to reduce cart abandonment, optimize marketing strategies, and increase conversion rates.
Data-Science
Python
Scikit-learn
Pandas
Numpy
Tensorflow
Keras
Pytorch
View Project
Sales Dashboard using Power BI
Sales Dashboard using Power BI
This Sales Performance Dashboard provides actionable insights into product sales, customer segmentation, and regional performance. Built with Power BI, this dashboard supports strategic decision-making by consolidating large volumes of transactional data into an interactive and visually intuitive interface.
Visualization
PowerBI
View Project
Vehicle Repair Dashboard
Vehicle Repair Dashboard
This Vehicle Repair Dashboard provides a strategic lens into fleet maintenance activities across suppliers, vehicle brands, and service types. It enables data-driven decision-making by highlighting repair patterns, supplier performance, and maintenance trends.
Visualization
PowerBI
View Project
Web Scraping and Image Classification with TensorFlow
Web Scraping and Image Classification with TensorFlow
This project demonstrates my ability to combine web scraping techniques with machine learning to classify images. The goal was to build a pipeline that scrapes images of shoes from a website and uses them for training a machine learning model.
WebScraping
BeautifulSoup
Selenium
Scrapy
View Project
British Airways Customer Review Web Scraping, Text Classification, Sentiment Analysis, and Customer Satisfaction
British Airways Customer Review Web Scraping, Text Classification, Sentiment Analysis, and Customer Satisfaction
This project demonstrates my ability to combine web scraping techniques with machine learning to classify images. The goal was to build a pipeline that scrapes images of shoes from a website and uses them for training a machine learning model.
WebScraping
BeautifulSoup
Selenium
Scrapy
View Project
British Airway Webscraping with Beautifulsoup
British Airway Webscraping with Beautifulsoup
This project demonstrates how web scraping can be used to extract valuable data from airline websites, specifically British Airways, using Python's BeautifulSoup library. The goal was to scrape flight-related data, such as flight details, prices, and other useful information, from the British Airways website for analysis.
WebScraping
BeautifulSoup
Selenium
Scrapy
View Project
Ecommerce Website Webscraping
Ecommerce Website Webscraping
This project uses requests and BeautifulSoup to scrape product listings from StockX’s e-commerce platform. The scraper extracts product name, description, price, and image link across multiple paginated results, storing them in a structured dataset for analysis or integration into business workflows.
WebScraping
BeautifulSoup
Selenium
Scrapy
View Project
Jumia Website Scraping
Jumia Website Scraping
This project uses requests and BeautifulSoup to scrape product listings and prices from Jumia Nigeria. The scraper works across multiple pages and categories, returning structured datasets ready for analysis.
WebScraping
BeautifulSoup
Selenium
Scrapy
View Project
Stack Overflow Text Classification
Stack Overflow Text Classification
This project involves building a multi-class classification model to predict the tag of a Stack Overflow question based on its content. The goal is to classify programming questions into specific tags such as Python, CSharp, JavaScript, and Java using Natural Language Processing (NLP) techniques.
Data-Science
Deep-Learning
Python
Numpy
Tensorflow
Keras
Pytorch
View Project
Fruits Image Classification
Fruits Image Classification
This project leverages image classification techniques to classify fruit images into their respective categories using Convolutional Neural Networks (CNN). The dataset used is the Fruits 360 dataset, which includes a wide variety of fruits and vegetables, and the goal was to build a model capable of predicting the type of fruit based on the image.
Data-Science
Deep-Learning
Python
Numpy
Tensorflow
Keras
Pytorch
View Project
Purchase Prediction
Purchase Prediction
Purchase Prediction with Logistic Regression.This project focuses on using logistic regression to predict customer purchases based on various demographic and behavioral features. The goal was to predict whether a customer will make a purchase (binary classification) using factors such as age, gender, marital status, income, occupation, and more.
Data-Science
Scikit-learn
Python
Numpy
K-Means
PCA
Logistic Regression
View Project
Ebay Sneakers WebScraping Using Selenium
Ebay Sneakers WebScraping Using Selenium
This project demonstrates the use of Python-based web scraping to extract product information from eBay. The focus was on collecting structured data such as item titles, prices, and condition from search result pages, enabling price analysis and market research.
WebScraping
BeautifulSoup
Selenium
Scrapy
View Project
Uber Ride Analytics Dashboard Overview
Uber Ride Analytics Dashboard Overview
This project involved building an interactive Uber Analytics Dashboard to provide insights into ride bookings, payment methods, vehicle usage, and location-based demand. The dashboard enabled stakeholders to monitor trends in customer behavior, evaluate revenue drivers, and optimize fleet allocation for operational efficiency and strategic planning.
Visualization
PowerBI
View Project
HR Analytics Dashboard Employee & Attrition Insights
HR Analytics Dashboard Employee & Attrition Insights
This project involved building an Interactive HR analytics dashboard covering employee attrition, hiring, salaries and departmental performance. Includes data visualizations and KPIs for strategic HR decision-making.
Visualization
PowerBI
View Project