Edmond-Boah/Analysis-of-Ghana-s-Petroleum-Product-Diesel-and-Petrol-Volumes

# 📊 Ghana Downstream Petroleum Liftings Analysis (2019–2025) --- ## Project Overview This project provides a comprehensive analysis of petroleum product liftings by Oil Marketing Companies (OMCs) in Ghana from **2019 to Date** using Power BI. The analysis focuses on: - **Premium Motor Spirit (PMS)** – Petrol - **Automotive Gas Oil (AGO)** – Diesel It demonstrates advanced capabilities in: - Data transformation (ETL) - Data modeling (Star Schema) - DAX calculations - Interactive dashboard design --- ## Objectives This analysis answers key business questions: - What is the total volume of petroleum products lifted? - Which product dominates the market? - Which OMC leads in market share? - Are leaders consistent across product lines? - What are the monthly, quarterly, and yearly trends? - What external factors influence lifting volumes? --- ## Tools & Technologies - **Power BI** – Visualization & dashboarding - **Power Query** – Data cleaning & transformation - **Microsoft Excel** – Data preparation - **DAX** – Measures & calculations - **Star Schema Modeling** – Data architecture - **Figma** – Dashboard UI design --- ## Methodology ### 1️⃣ Data Extraction & Cleaning (ETL) - Data sourced from National Petroleum Authority (NPA) Website npa.gov.gh - Cleaned and standardized OMC names - Removed duplicates and inconsistencies - Merged monthly datasets into one fact table - Created dimension tables: - OMCs - Products - Depots - Calendar --- ### 2️⃣ Data Modeling - Implemented **Star Schema** - Created one-to-many relationships - Built a **Calendar Table** for time intelligence - Ensured optimized performance and accuracy --- ### 3️⃣ DAX Calculations Key measures: - Total PMS Volume - Total AGO Volume - Market Share (%) - Cumulative Liftings - YoY Growth (%) - Rolling 12-Month Trend --- ### 4️⃣ Dashboard Development - Built: - Market Overview Dashboard - Market Share Dashboard - Visuals: - Line charts (trends) - Bar charts (comparisons) - …