Vehicle Repair Dashboard

Vehicle Repair Dashboard
Vehicle Repair Dashboard thumbnail 1
Vehicle Repair Dashboard thumbnail 2
Vehicle Repair Dashboard thumbnail 3
Vehicle Service & Repair Dashboard Analysis

🚗 Vehicle Service & Repair Dashboard Analysis

🔧 1. Workshop/Supplier Performance

Top Performer: Mecho Auto Tech handled 43 repairs/services (43.43%), leading the supplier chart. Dominated with 30 Routine and 14 Repair services.

Runner-Up: Adhoc (Others) followed closely with 34 services, mostly Routine (28).

Low-Activity Vendors: Mikano, Elizade (JAC), and Affordable Cars — only 1 record each.

Insight: Heavy reliance on 2 providers. Diversify to mitigate vendor concentration risk.

🚘 2. Vehicle Repair/Service Insights

Service Types:

  • Repair: 73.74%
  • Routine Service: 25.25%
  • Routine: 1.01% (negligible)

Top Brands Requiring Repairs:

  • JAC: 38 cases, mostly serviced by 5Speed Tech.
  • Mini Van: 18 repairs — serviced by Mecho Auto Tech.
  • Nissan Models: Almera, Pick Up, and Kicks show consistent issues.

Observation: JAC repairs heavily rely on a single workshop — vendor dependency risk.

📊 3. Service Trends in 2024

Repair Trend: Noticeable spike mid-year (July–August).

Routine Services: Fluctuate at low levels — preventive maintenance underutilized.

Operational Risk: Reactive maintenance dominates. This is inefficient and cost-intensive.

📌 Strategic Recommendations

  • Boost Preventive Maintenance: Increase Routine/Routine Service activities to avoid unplanned repairs.
  • Balance Vendor Load: Reduce dependency on Mecho Auto Tech and Adhoc. Onboard and empower alternatives.
  • JAC & Mini Van Analysis: High repair frequency — investigate usage patterns or quality issues.
  • Monitor Monthly Trends: Use monthly data to forecast and reduce peak maintenance pressure.

🧠 Executive Summary

Metric Top Performer / Insight
🛠️ Most Used Workshop Mecho Auto Tech (43 services)
🚗 Most Serviced Vehicle JAC (38 repairs, serviced by 5Speed Tech.)
🔧 Dominant Service Type Repairs (73%) – preventive services are lagging
📉 Underutilized Vendors Affordable Cars, Mikano, Elizade
📈 Trend Observation Repair peaks mid-year; preventive efforts are minimal

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
supply chain spend analytics dashboard overview
supply chain spend analytics dashboard overview
This project involved building an interactive Spend Analytics Dashboard to help logistics, procurement and finance teams gain real-time visibility into organizational spending. The dashboard consolidated multi-year spend data across vendors, product categories, and logistics channels - providing a centralized decision-support system for cost control and strategic sourcing.
Visualization
PowerBI
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
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