Stellar & Trustpower

A data analytics case study

In the highly competitive retail energy business, long-term Stellar customer Trustpower outperforms its rivals on almost every indicator.

Since mid-2014 Trustpower has added almost 30,000 electricity and gas customers, thanks largely to its unique energy-plus-telecommunications product offerings. It was the highest scorer of the ‘big-five’ retailers in the 2015 Consumer NZ survey, and was rated highest for its ability to solve customer problems – leading Trustpower to be named Energy Retailer of the Year at the 2015 Deloitte Energy Excellence Awards.

How does a small regional player continuously outperform industry heavyweights in such a hotly contested and fluid market? By doing it smarter of course, with an industry-leading business strategy underpinned by an industry-leading Business Intelligence solution.

Staff 628
2015 EBITDAF $330m
Website trustpower.co.nz

Stellar and Oracle


The challenge

With some 260,000 customers and terabytes of data scattered across various repositories, Trustpower recognised that decision-makers’ reliance on outdated and unmanaged reporting had to change.

As part of its focus on improving customer service excellence, the company saw the need to improve the reliability and accuracy of its reporting capabilities while continuing to foster the culture of self-service reporting that existed throughout the business.

The solution

In 2010 Stellar was engaged by Trustpower to take the company on a journey of BI improvement that would result in a world-class solution to support their evolving multi-product strategy. In collaboration with key business stakeholders, Stellar prototyped, architected, and led the development of a new BI platform for Trustpower using the Oracle BI toolset. Operational (3rd normal form) and Analytical (star schema) data warehouse repositories, which support everything from real-time operational analysis through to executive KPI dashboards, were built to support the business’ reporting and analytical needs.

A conscious effort was made from the outset to ‘weed and feed’ the investment in BI with strong governance, engagement and support processes. As a result, Trustpower now has a large community of active BI users that are themselves invested in improving and leveraging BI for the good of the company. Today, Stellar continues to evolve and support Trustpower’s BI platform to meet the growing demands of their large user community, allowing them to get on with what they do best: out-smarting the competition!

“Trustpower has long been a data-driven organisation and, with the help of Stellar, we’ve been able to significantly improve our ability to put the right information in front of the right people at the right time.”

Matt van Deventer, Head of Technology, Trustpower

Trustpower’s BI Solution

An enterprise data warehouse and reporting solution using:


Oracle 12c RDBMS / Oracle Data Integrator / Oracle BI Enterprise Edition / Oracle BI Publisher

The benefits

  • Replacement of disparate legacy reporting environment with a world-class data warehouse and reporting solution.
  • Integration of energy and telecommunications billing records for over 260,000 customers into a single repository accessible via BI reporting tools.
  • Recognition throughout Trustpower that BI is a critical business application and a key enabler of strategic change.
  • Adoption of best-practice architecture providing the agility necessary to rapidly meet business needs, including advanced analytics and predictive modelling.

Download Case Study as a PDF