One51 Success Stories
Empowering Ausgrid through a successful mass data migration
Client Profile
As the largest electricity distributor on Australia’s east coast (by population served), Ausgrid is pivotal to keeping energy flowing to homes and businesses across Sydney, the Central Coast, and the Hunter region.
Co-owned by the NSW Government and private investors, the company owns and maintains infrastructure that distributes energy to 1.8 million customers.
More than 600 billion records in various formats
To put it into perspective, Ausgrid captures readings from millions of energy meters as well as network sensors; some of which provide readings every 5 minutes – resulting in billions of records for analysis. These readings are associated with complex geographical, weather and asset data that is stored in different formats.
Lacking in consistency
Difficult to configure and adapt
Poorly equipped to support data governance
"Our partnership with One51 was crucial to the success of this milestone, enabling a smooth migration and immediate improvements in performance and usability."
Lachlan Hope
Data Services and Platforms Manager for Ausgrid
Migrating to Azure Databricks using a rapid ELT framework
Working with Ausgrid’s internal data team, One51’s data specialists set about retrieving data from over 50 sources, migrating into the new D2I (data-to-intelligence) platform.
Azure Databricks was selected by Ausgrid due to its ability to scale and integrated storage, compute, governance and AI capabilities. It meant everyday users could be set up to receive all the insights and reports they needed, while citizen developers would have the ability to create new insights, ingest new data, and develop AI models.
Seamless launch with immediate benefits realised
Following go-live, there was not a single escalation. Users saw immediate improvements in performance, efficiency, and usability.
Ultimately, Ausgrid was able to turn off and remove the legacy Synapse-based system – eliminating all costs associated with running and maintaining it.
Lachlan Hope, Data Services and Platforms Manager for Ausgrid, says ‘We managed to successfully migrate all data and processing capability from our old platform through our data program, with minimal disruption to our end users. This is a major milestone in transforming the data and capabilities we provide our business users and optimizing both performance and cost in our platform. Our partnership with the team from One51 was crucial to the success of this milestone’
