The Challenge: An enterprise team was manually copying, pasting, and merging fragmented financial CSV files every week to track operational runway. This manual process led to syntax errors, broken formulas, and a total lack of forward-looking cash flow visibility for executives.

The Solution: I engineered an end-to-end automated reporting dashboard natively inside Microsoft Excel. Using Power Query, I built an automated ETL data pipeline that instantly ingests, cleanses, and structures raw transaction files with a single click.

Key Features Implemented: • Dynamic Executive KPI Cards tracking Total Revenue, OPEX, and Receivable Days. • Interactive Slicer components allowing stakeholders to drill down by Year and Business Sector. • High-contrast risk trend lines indicating next-month financial boundaries. • 100% gridless, custom application UI layout for maximum visual clarity.

The Result: Eliminated 5+ hours of manual data preparation per week, providing the finance director with real-time, zero-touch risk indicator metrics.