Utilities – Streamlining Operations and Replacing Legacy Systems in Power BI
By consolidating data from various source systems, we created a solution where users could access their reporting in a single tool, enhancing efficiency and simplifying workflows. The solution not only automated their existing reporting but allowed for different reporting capabilities, ultimately providing enhanced analytical capabilities and data-informed decision-making. The Problem Our utilities client was using […]
Read More
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