Case Studies

Filter by

Empowering Reliability: Harnessing Data Science for New Zealand's Electricity Network

Advanced Analytics Data Quality

The SAIDI, or System Average Interruption Duration Index is a key metric for network reliability performance in the electricity industry. It corresponds to the sum of all customer interruption duration divided by the total number of customers served, offering a comprehensive gauge of service reliability.

Over recent years, Top Energy has experienced higher than expected unplanned SAIDI and reported SAIDI has increased each year. Increasingly challenging weather conditions, which are …

Casting a light on Aotearoa’s darkest assets

Custom Analytics + Software Solutions Data Quality Data Visualisation + Reporting Solutions

Improving the transparency of Three Waters asset data quality across New Zealand.

Data is essential for assessing the condition of Three Waters (wastewater, drinking water and stormwater) pipe networks, planning renewals and scheduling maintenance. Traditionally, pipe asset …

Cleaning millions of meter reading data points to improve reporting capability.

Custom Analytics + Software Solutions Data Quality

Helping Tauranga City Council automate a manual data cleansing process to free up six weeks per year of manual effort and improve both the quality and accessibility of critical business data.

Every year, Tauranga City Council is required to report its water consumption and other metrics to Water NZ. These metrics must be accurate, and therefore …

Automated data gathering and visualisation enhances productivity

Custom Analytics + Software Solutions Data Quality Data Visualisation + Reporting Solutions

Helping Trustpower improve visibility of ISP capacity and performance through automated data collection and interactive data visualisations.

Key ISP KQI and KPI data was manually collated from multiple data sources daily into a spreadsheet. From the spreadsheet, reports were generated with simplistic …

Investigation and planning before a data migration makes moving data easy

Data Quality

Harmonic performed a data quality assessment on the Ministry for Primary Industry’s Climate Change Information System to aid its upgrade and migration.

The Emissions Trading Scheme (ETS) is used by the New Zealand government to meet domestic and international climate change targets. The forestry component of the …

Enduring relationship helps deliver water services to 1.5 million people daily

Advanced Analytics Data Quality Data Science Team Development Data Visualisation + Reporting Solutions

Harmonic builds enduring relationships with our clients to provide ongoing value and expertise. Our lengthy professional relationship with Watercare has allowed us to contribute to several aspects of their business, including; performing data quality assessments and exploratory data analyses, creating custom algorithms and analytical measures; developing and productionising forecasting projects, and; building their in-house data science team.

Watercare supplies around 365 million litres of water to Auckland every day. Water is drawn from 23 sources, treated and supplied to homes and businesses …

Asset Lifecycle Management for Wellington City Council

Custom Analytics + Software Solutions Data Quality

Water analytics allows companies and local bodies to evaluate their data for trends and patterns, enabling quick identification of opportunities to reduce costs, minimise risks and predict asset failure. Additionally, understanding the quality of your asset management data provides confidence to make decisions based on these insights.

WCC wanted to improve "three waters" asset management data to help meet regulatory compliance requirements, including 30-year infrastructure strategies. They also wanted to support cost-effective …

Tackling Data Quality in Government

Data Quality

Taking the first step towards understanding and measuring the impact of data quality with Harmonic’s Data Quality Assessment.

A large government department wanted to assess and monitor the quality of data in two core operational repositories which support numerous critical functions within the …