A rippling effect from data-driven insights

At a glance

Unitywater serves the Moreton Bay, Sunshine Coast and Noosa regions of South East Queensland by providing water supply and sewage treatment utility services.

As a large distributor and retailer, optimising pricing models and leveraging innovative data visualisations are essential components to Unitywater's long-term growth and sustainability.

Strategenics was called on to develop an insightful solution that the Unitywater team could rely on for years to come.

Services provided

  • Business analysis
  • Data modelling
  • Data visualisation
  • "What-if" scenario analysis
  • Cloud hosting

Technology used

Solutions and products involved

  • Amazon_Relational Database Service

    Amazon Relational Database Service (RDS)

  • Amazon_Elastic Compute Cloud_EC2

    Amazon Elastic Compute Cloud (EC2)

  • Amazon_Simple Storage Service_S3 (2)

    Amazon Simple Storage Service (S3)

The challenge

Future-proofing a diluted pricing model

For a company providing essential water and sewage services to more than 16% of Queensland's population, being able to provide consistent and equitable pricing across various segments of the community is crucial for Unitywater.

Unitywater was ready to undertake a more sophisticated water pricing strategy. More importantly, the required pricing approach needed to be an adaptable model that could inform the determination of pricing policies in a fast-growing region like South East Queensland for the next three financial years.

hand pouring glass of water
Image credit and copyright: Unitywater
Image credit and copyright: Unitywater

The solution

Tapping into transformative data visualisations

Our team developed an SQL database to store, collate and transform the base data sets. We then built an extensive visualisation tool based on Unitywater's existing research models to demonstrate the flexibility, capability and usability of dynamic data dashboards.

We performed distinct goal-seeking activities to determine the feasibility of defined price fluctuation scenarios, and provided guidance on identifying sensitivities in price control triggers based on modelling outcomes.

By also establishing a managed service, we were able to deliver a secure and private environment of internal capabilities to view, construct and manipulate additional analytics and visualisation models.

The outcome

Optimising for success yet remaining fluid

With our help, Unitywater was able to achieve:

  • a flexible, multi-input visualisation tool to aid the exploration of priorities for the next modelling rounds.
  • a comprehensive pricing model that was accomplished in a tight turnaround schedule.
  • the ability to reveal incompatibilities between certain modelling inputs, the data and the desired outcome.
Image credit and copyright: Unitywater
Image credit and copyright: Unitywater

We've helped hundreds of organisations exceed their digital transformation ambitions

Let's talk about your next project

No matter what stage your project is in, or what in-house expertise you currently have, we'll help develop a plan that works for you and your team.

Book a meeting to chat with one of our consultants. Alternatively, click here to leave us a message about your project.