courage-analytics-glitch/npa-petroleum-distribution-analysis

Power BI dashboard analysing Ghana downstream petroleum distribution across 213 OMCs using real NPA BIDEC data, January 2025 to April 2026 # NPA Petroleum Distribution Analysis — Ghana (2025–2026) ## Project Overview This project analyses Ghana's downstream petroleum distribution sector using real operational data from the National Petroleum Authority (NPA) BIDEC reporting system. The dataset covers 213 licensed Oil Marketing Companies (OMCs) across 17 petroleum product categories from January 2025 to April 2026 — a 16-month window capturing full-year 2025 performance and early 2026 trends. Built as part of an MSc Applied Business Analytics portfolio at Glasgow Caledonian University. ## Tools Used - Power BI Desktop (data modelling, DAX, dashboard design) - Power Query (data cleaning, transformation, unpivoting) - Microsoft Excel (raw data source) - DAX (calculated measures and ranking logic) ## Data Source National Petroleum Authority Ghana — BIDEC Distribution Data Covers: January 2025 to April 2026 Scope: 213 active OMCs, 17 product categories ## Dashboard Pages ### Page 1 — NPA OMC Performance 2025 - Total volume distributed: 9.27 billion litres - 213 active OMCs tracked - Monthly volume trend line chart - Top 10 OMC bar chart with conditional formatting - Product mix donut chart - Slicers: Month, Product, Company ### Page 2 — OMC Deep Dive - Company-level monthly trend analysis - Product breakdown per OMC - Identifies distribution concentration at company level ### Page 3 — Market Share Rankings - Full RANKX-based ranking of all 213 OMCs - GOIL PLC ranked 1st with 8.44% market share - HHI market concentration score: 377 (competitive market) ### Page 4 — 16-Month Trend (Jan 2025 to Apr 2026) - Total volume across 16 months: 13 billion litres - Active OMCs across 16 months: 223 - Period Number on X-axis for correct chronological sorting ### Page 5 — OMC Activity Analysis - Identifies OMCs with fewer than 12 active months - Companies like BIGEN PETROLEUM and FUELIT ENERGIES recorded only 1 active month - 39% of licensed OMCs showed underutilisation ## Key Findings and Opportunity Spotting …