Utilities – Metadata–driven ETL Solution

The Problem A utilities provider approached exposé to assist as they transitioned out of an on-premise call centre system (Genesys) and into a new cloud-based system (Genesys Cloud). The on-premises system was used as the primary data source for several reports that the business utilises. Extraction and transformation of the data were manual and laborious and required numerous hours to complete.​ Exposé was […]

Read More

Utilities – Journey towards a modern data ecosystem

The Problem This client is a utilities provider in South Australia and has physical assets all around the state. It’s a large organisation with lots of data spread across many capability areas. It’s a complex technology landscape where the data is stored across a multitude of on-prem and cloud-based systems.​ The status quo reporting and analytics included many manual processes, which […]

Read More

Utilities – Ensuring Data Security after Organisational Structure Changes

The Problem Our client, a prominent utility provider, encountered a challenge stemming from an internal organisational restructuring, which resulted in changes to the hierarchical structure in their data warehouse. This change would significantly impact the functionality of the Row Level Security within their financial Power BI reporting.​ Given the routine reliance on this reporting system by numerous […]

Read More

Oil & Gas – Snowflake Implementation

The Problem Our Oil & Gas client implemented Snowflake as their preferred data warehousing platform in conjunction with Matillion as their ETL toolset in an AWS environment. They had a number of concerns relating to performance, scalability and cost. Generally, they accepted the way things worked as just “the way things work”. There were ongoing […]

Read More

Capacity Planning Tool – our utility case study

  Problem: One of our major utility customers identified that their current process for planning resources to meet the demand was not sustainable. Daily, there would be hundreds of customer calls requiring a myriad of different services, planned maintenance work as well as corporate demand. These calls often required crews of different levels of skills […]

Read More

Utilities Financial Performance Reporting Solution

A reporting solution that synergised Power BI, Power Apps and Azure for performance insights and commentary capability. The Problem Our utilities client created an initiative to enable their Finance team to be a “value-add” department. They wanted the Finance team to be experts in business performance and provide insights based on analysis. The client wanted […]

Read More

Data Analysis with Power BI – our Utility case study

The art of balancing demand and supply. See how our developed Capacity Planning Tool will enable better decision-making and planning around resource availability and utilisation for customer-related work in the field. The Problem  One of our major utility customers identified that their current process for planning resources to meet the demand was not sustainable. Daily, […]

Read More

Cyber Security Program Tracking Reporting – our large Australian utility case study

Providing a centralised reporting solution for Board, Management, Operational and Regulatory audiences to measure regulatory Cyber Security framework outcomes. The Problem  The Cyber Security team within one of our largest utility customers are responsible for providing governance, oversight and consultation for all aspects of cyber security across the enterprise. This comprises the investment strategies, roadmaps […]

Read More

Global cyber security capability maturity monitoring and analysis – our large Australian utility case study

See how we designed and developed global cyber security capability maturity monitoring and analysis for effective benchmarking and future planning activities for this large Australian utility. The Problem  One of SA’s leading utilities customer are required to complete an annual self-assessment questionnaire rating themselves against a number of key objectives and capabilities relating to Cyber […]

Read More

Customer Field Services Insights – our water utility case study

Our solution improved the customer experience through informed data-driven decisions. The Problem:  The Customer Field Services (CFS) branch within one of our large water utility customers had many different stakeholders with a diverse range of reporting requirements to assist with regulatory metrics as well as improving the customer experience with regard to responding to water […]

Read More

Smart Wastewater network – our SA Water case study

This solution enables greater customer service through better management of the wastewater assets through an industry-leading smart wastewater network management solution. It incorporates a leading edge architecture built on the Azure platform using key technologies including Databricks, IoT, Stream Analytics, App Service, and more. Read our case study here: Smart Wastewater network – our SA Water […]

Read More

Networks Asset Data Mart – our Energy Infrastructure Provider case study

Exposé designed and developed a solution that saw an increasingly temperamental Networks Asset Analytical solution move to the Exposé developed Enterprise Analytics Platform. The solution now: • Allows staff to focus on business-critical tasks by utilising the data created by the system.• Reduces support costs due to the improved system stability.• Utilises the IT resources […]

Read More