Microsoft partner Ignia worked with Western Power to implement the Microsoft solution, with the electricity supplier required to efficiently track and analyse outages in an electricity supply network spread across 250,000 square kilometres, servicing over 2 million customers.
Prior to the Microsoft deployment, Western Power had huge volumes of data available, but collation and analysis was becoming increasingly difficult - identifying regional outage trends and geographical ‘hotspots’ was a manual, time-consuming process, impacting the utility’s service to customers and reducing the efficiency of customer communications.
With the new deployment, the Customer Service Outage Dashboard provides graphical analysis of outages and at-a-glance KPIs and metrics. Staff can now easily explore and investigate outage data and the solution facilitates the identification of outage ‘hotspots’ and the associated underlying trends.
Gino Giudice, Head of Customer Service at Western Power, wanted to introduce more advanced reporting capabilities to the business and to use the data captured by affiliated systems more effectively.
“While we were able to manually collate the required reports, there was certainly room for improvement around this process and opportunities to provide ‘next-level’, proactive service to our customers.”
“The project was certainly challenging,” said John Rampono, Lead Architect at Ignia.
“We were working with a large and complex data set. The solution had to analyse event data generated each minute by millions of electricity meters from around the State. This was solved by leveraging the Azure Cloud infrastructure. Azure table storage combined with Azure SQL and Power BI provided the scalability to deal with the data load.”