Success Stories Connecting GIS to asset data to transform network decision-making
Connecting GIS to asset data to transform network decision-making
Network decisions on incomplete data. A model that could only run once a year.
Ausgrid's network data sits across two critical systems - a Geographic Information System capturing the physical, spatial location and detail of assets, and an asset management system used for financial and planning purposes across the entire organisation. Both systems hold complementary but different views of the same physical assets. GIS has location-based detail but lacks the full attribute depth of the asset management system. The asset system has hundreds of attributes but lacks detailed spatial data. Maintenance and replacement decisions depend on both. Without a unified view, generating accurate, timely insights was extremely difficult. An earlier solution built in 2020 attempted to bridge this gap but struggled to scale, lacked transparency, and relied heavily on manual processes - meaning the model could only be recalculated once annually, requiring months of preparation.
A daily model. Transparent. Trusted. Scalable.
One51 rebuilt the generated assets model on Microsoft Fabric, designing a solution that connects GIS and asset management data in a governed, transparent and automated way. Working closely with Ausgrid's data and network teams, we rebuilt the calculation logic, validated it against known outputs, and deployed it on a daily recalculation schedule. The result is a model that was previously run once a year that now runs every single day - in under 25 minutes.
-
Daily
Generated assets model now recalculates automatically
-
<25 min
Full recalculation time - down from months of manual effort annually
-
Trusted
Asset data now transparent, governed and available every day
Having a trusted, integrated view of our network data is critical to how we plan, prioritise and deliver for our customers. The generated assets model has significantly improved the accuracy, transparency and timeliness of our decision-making. Partnering with One51 has been instrumental in helping us unlock the full value of our data.
Lachlan Hope
Data Services and Platforms Manager, Ausgrid
Is your data ready for AI?
Book a free Discovery Session.