Power BI Financial Dashboard Optimization
Budget: ₹750 – ₹1,250 INR
This image shows a Power BI Finance Overview dashboard for the Saudi Electricity Company, specifically tracking projects related to "Smart Grid" and "Smart Distribution." The dashboard provides a high-level summary of budget allocation, spending, and contractor performance.
Key Financial Metrics (Left Sidebar)
The dashboard tracks several critical KPIs to monitor budget health:
Budget Ceiling: 178.53M (Interestingly, it notes a goal of 5.42bn, showing a -96.7% variance).
Total Paid: Approximately 3.96M.
Remaining Amount: 3.17bn.
Total Invoiced: 5,001,274K (approx. 5bn).
% Utilized: 5.42bn, which is noted as +241.98% over the 1.58bn goal.
Data Visualizations
Financial Distribution by Category: A donut chart showing contract types. The largest segment is (Blank) at 50% (5.42bn), followed by LUMP-SUM at 37.26% (4.04bn) and UNIT-RATE at 10.25% (1.11bn).
Time-Trended Spend Analysis: A line graph tracking spending over time. There is a notable data anomaly or "placeholder" date showing activity back to the year 1900, likely due to unformatted historical data or default system dates.
Invoiced Amount by Contractor: A horizontal bar chart identifying top contractors. Al-Gihaz Contracting and SGCC appear as leading contributors to the invoiced totals.
Detailed Invoice Table
The bottom section provides a granular look at specific transactions:
Projects: Primarily focused on "Smart Distribution Network Automation."
Major Contractors: Includes Branch of China Electric Power Equipment and Technology Co. Ltd, Al-Gihaz Contracting Co., and Al-Othman Engineering Consultants.
Total Paid (Table Sum): The visible total at the bottom of the table is 3,806,747,535.18.
Observations & Data Integrity
Date Range: The "Date Initiated" slicer is set from 11/2/1900 to 10/2/2025, which suggests some data cleaning may be needed for the historical start dates.
Scaling: The dashboard mixes "M", "K", and "bn" units, which requires careful reading to compare the values accurately.
Key Financial Metrics (Left Sidebar)
The dashboard tracks several critical KPIs to monitor budget health:
Budget Ceiling: 178.53M (Interestingly, it notes a goal of 5.42bn, showing a -96.7% variance).
Total Paid: Approximately 3.96M.
Remaining Amount: 3.17bn.
Total Invoiced: 5,001,274K (approx. 5bn).
% Utilized: 5.42bn, which is noted as +241.98% over the 1.58bn goal.
Data Visualizations
Financial Distribution by Category: A donut chart showing contract types. The largest segment is (Blank) at 50% (5.42bn), followed by LUMP-SUM at 37.26% (4.04bn) and UNIT-RATE at 10.25% (1.11bn).
Time-Trended Spend Analysis: A line graph tracking spending over time. There is a notable data anomaly or "placeholder" date showing activity back to the year 1900, likely due to unformatted historical data or default system dates.
Invoiced Amount by Contractor: A horizontal bar chart identifying top contractors. Al-Gihaz Contracting and SGCC appear as leading contributors to the invoiced totals.
Detailed Invoice Table
The bottom section provides a granular look at specific transactions:
Projects: Primarily focused on "Smart Distribution Network Automation."
Major Contractors: Includes Branch of China Electric Power Equipment and Technology Co. Ltd, Al-Gihaz Contracting Co., and Al-Othman Engineering Consultants.
Total Paid (Table Sum): The visible total at the bottom of the table is 3,806,747,535.18.
Observations & Data Integrity
Date Range: The "Date Initiated" slicer is set from 11/2/1900 to 10/2/2025, which suggests some data cleaning may be needed for the historical start dates.
Scaling: The dashboard mixes "M", "K", and "bn" units, which requires careful reading to compare the values accurately.