Managing public service infrastructure is a serious business. Outages are more than just an inconvenience – they can disrupt commercial operations, and affect people’s lives. Every day, Western Power has to efficiently track and analyse outages in an electricity supply network spread across 250,000 square kilometres, servicing over 2 million customers.
Although the company had huge volumes of data available, collation and analysis was becoming increasingly difficult. Identifying regional outage trends and geographical ‘hotspots’ was a manual, time-consuming process, impacting Western Power’s service to customers and reducing the efficiency of customer communications.
Working with Ignia, Western Power implemented a solution to automatically collate, analyse and visualise the massive volumes of event data collected from millions of electricity meters every day.
The result was the Customer Service Outage Dashboard – providing graphical analysis of outages and at-a-glance KPIs and metrics. Staff can now easily explore and investigate outage data; the solution facilitates the identification of outage “hotspots” and the associated underlying trends.
Hosted in Microsoft Azure and delivered by the Power BI platform, the solution gives Western Power a cost-effective, scalable, and accessible source of outage information, providing a solid foundation for more efficient and proactive customer service.
Gino Giudice, Head of Customer Service at Western Power, was keen 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,” explained Mr Giudice.
Mr Giudice tasked the Ignia team with creating a highly visual, interactive solution, able to display outage areas and trends, to enable Western Power teams to conveniently investigate the locations and underlying causes of repeated service interruptions.
Armed with the high-level business needs, the project team applied an Agile delivery methodology to rapidly identify and deliver the most appropriate solution by incrementally refining the detailed requirements and aligning the architecture and technologies to suit.
Along the way, the team considered several potential designs for Western Power before deciding to implement a fully cloud-based Power BI solution, hosted in Microsoft Azure.
A key design element was scalability. The solution needed to accommodate huge amounts of data being generated daily by the electricity distribution network, and then to rapidly process and visualise the relevant information.
“The project was certainly challenging,” recalls 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.”
Storage cost was also an important consideration, and a significant input to the final product design. Hosting the solution in Azure proved a more cost-effective way to capture and store the large volumes of data involved, compared with commissioning and supporting new infrastructure on-premises.
With supply data flowing into Azure and automatically populating dashboards and maps, Western Power staff can now easily explore and analyse service interruptions, gauge the direct impact on customers and act quickly to rectify.
The Western Power customer service team now spend less time manually collating data into reports, and instead focus more on business activities, which ultimately leads to improved customer service. Accessible information provides capability for more efficient and increasingly proactive communication, both to external customers and also across the Western Power leadership team.
Leveraging Microsoft Azure also directly translated into reduced storage cost, a critical factor given the volumes of data involved. Rather than commission new infrastructure, with the associated licensing and ongoing management overheads, an Azure solution provided Western Power with a scalable storage environment of guaranteed availability.
The final outcome is best summarised by Mr Giudice: “Western Power now has a modern, intuitive capability without the prohibitive price tag. The entire solution enables us to better understand the customer experience and therefore help our customers in a more proactive way.”