winny8401/ghana-energy-performance-PowerBi-dashboard

An interactive Power BI dashboard that explores Ghana's energy performance through 2022, with a focus on electricity generation, transmission, consumption, tariffs, access, capacity, and system losses. Ghana Energy Performance Dashboard An interactive Power BI dashboard that explores Ghana's energy performance through 2022, with a focus on electricity generation, transmission, consumption, tariffs, access, capacity, and system losses. Project Overview This project turns energy data into a clear four-page analytical dashboard designed to make Ghana's electricity sector easier to understand at a glance. The report brings together generation trends, energy sources, imports and exports, transmission performance, customer consumption, electricity access, tariffs, and distribution losses. Dashboard Pages 1. Overview Provides a high-level snapshot of Ghana's energy sector, including: Total electricity generation Total energy consumption by sector Installed capacity Capacity margin Average electricity tariff Electricity access rate Generation growth over time Import and export trends Transmission and distribution losses Registered electricity customer categories 2. Generation Examines how electricity is produced and how the generation mix changes over time: Hydro, thermal, and other renewable generation Share of hydro and thermal power Renewable energy share Thermal generation compared with crude oil prices Electricity imports and exports Electricity tariff trends 3. Transmission Focuses on the performance and capacity of the transmission system: Installed capacity versus dependable capacity Dependable capacity compared with system peak load Electricity transmitted versus transmission losses Transmission loss trends over time 4. Consumption Explores electricity use and distribution performance: Energy purchased and sold Distribution losses Consumption by agriculture, industry, residential, service, and transport sectors Utility loss comparison ECG loss trends Domestic peak demand Registered residential, non-residential, and special load tariff customers Key Data Areas The Power BI model includes data relating to: Electricity gener …