2024
Cloud Infrastructure Volumetric Tracker
Accenture's cloud team tracked server and database volumes manually across multiple spreadsheets. I automated the aggregation with Power Query, reducing quarterly workload by 80%.
01
The problem
The quarterly infrastructure review required manually pulling and aligning data from multiple server and database tracking sheets. It was repetitive work that could eat up a full day every quarter.
02
What I built
An automated Power Query solution that aggregates all source sheets into one clean summary. Updates run in under a minute. The billing summary dashboard connects to the same SharePoint backend, keeping everything in sync without manual intervention.