Power BI Financial Dashboard Optimization

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. Rate: INR 750–1250/hr Skills: Excel, Statistics, Business Analysis, Financial Analysis, Business Intelligence, Data Analytics, Data Visualization, Power BI