alogbawassy-max/downstream-petroleum-supply-chain-nigeria

Oil & Gas supply chain analysis using Excel, SQL, and Power BI # Downstream Petroleum Logistics and Inventory Optimization in Nigeria ## 📌 Project Overview This project analyses the downstream petroleum supply chain in Nigeria, focusing on logistics performance, inventory management, and cost efficiency across major depots. The objective is to identify operational inefficiencies, stockout risks, and key cost drivers using a data-driven approach with Excel, SQL, and Power BI. --- ## 🎯 Objectives - Analyse fuel distribution patterns across depots and states - Evaluate delivery performance and delay behaviour - Identify stockout risks and inventory imbalances - Assess inventory turnover and supply-demand gaps - Evaluate logistics cost efficiency across operations --- ## 🛠️ Tools & Technologies - **Excel** → Data cleaning, transformation, and feature engineering - **PostgreSQL (SQL)** → Data querying and business analysis - **Power BI** → Dashboard development and visualization --- ## 📂 Dataset Description This project uses a synthetic dataset designed to simulate real-world downstream petroleum operations. ### 🔹 Shipments Table - depot - product_type (PMS, AGO, DPK) - distance_km - quantity_litres - delivery_days - delivery_flag ### 🔹 Inventory Table - inventory_date - depot - product_type - opening_stock - received_stock - distributed_stock - closing_stock - stockout_flag - inventory_turnover ### 🔹 Cost Table - fuel_cost - driver_cost - maintenance_cost - security_cost - loading_cost - total_logistics_cost - cost_per_litre --- ## 📊 Dashboard Preview ### 🔹 Overview ### 🔹 Logistics Performance ### 🔹 Inventory Analysis ### 🔹 Cost & Efficiency --- ## 🔍 Key Insights - PMS accounts for the largest share of fuel distribution volume - Warri Depot records the highest stockout incidents, indicating supply pressure - Average delivery time is approximately 2.16 days across depots - On-time delivery rate is approximately 95%, showing strong logistics performance - All depots exhibit negative supply gaps, suggesting …