SSupply Chain AnalyticsProblem Statement Overview

Imagine that you are working as a data analyst in Smart Consultants and your client who handles an open$-$pit mine comes with you for understanding some key metrics as below:

Equipment Availability

No$.$ of equipment operating in the field

No$.$ of equipment under maintenance

Production Rates

Production vs Plan

Top$-$performing equipment

Poorly performing equipment

Efficiency of Operations

Overall Equipment Effectiveness $($OEE$)$

Availability, Performance, Quality

At present, the mine is not working at optimum efficiency and has poor production. Their key performance metrics such as availability, performance and quality are not optimised, and their head of supply chain would want to understand how to optimise their performance by understanding the current performance of the mine.

As a part of the analytics team, you would want to prepare proper visualisation dashboards such that you can show these key metrics to a senior technical or a business stakeholder. This will help them understand the current situation of the production at the mine and help them make key decisions for improving the performance and efficiency of the processes. With the help of the insights received from the metrics, you will be able to provide key recommendations to the executives to increase the production and efficiency of the mine.

Industry & Function

Supply Chain

Manufacturing

Capstone Breakdown

Specialised Content Duration: ~$2$ Weeks

Project Duration: ~$3$ Weeks

Specialised Content Topics

Introduction to Supply Chain

Demand Forecasting

Inventory Optimization

Network Optimisation

Soft Skills in the Project

Domain & Business Understanding

Business Impact and Data Storytelling

Hard Skills in Project

Data Cleaning and Preparation

KPI and Metrics Calculation

Visualisation and Dashboarding for the KPIshow me the steps to solve