Queensland Government – AI-powered document classification
The Problem Office of the Coordinator-General (OCG) in the Queensland Department of State Development and Infrastructure assesses the impact of significant and complex projects. The assessment process includes consultation which encompasses processing submissions from government agencies, organisations and members of the public, in a variety of document formats. Each submission is required to be […]
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
Aged Care – Data and Analytics Cloud Migration
The Problem A not-for-profit aged care provider caring for 1,000 residents across 12 aged care homes sought our expertise to review their data and analytics platform and address their data-related challenges. Upon assessment, we found that their existing data warehouse had substantially grown over time and was becoming difficult to maintain. The current solution relied on outdated design and structures, limiting the incorporation […]
Read More
Construction – Power BI Operational Framework
The Problem Our construction client had existing pieces of Power BI reporting. However, the client desired wider adoption throughout the business, with a focus on security and best practices. A staggered approach to implementation was requested while reworking their core data systems and existing reporting. This client was striving to obtain confidential contracts. To facilitate […]
Read More
Education – Accommodating Changes to NAPLAN
The Problem Every year in Australia, students in Years 3, 5, 7 and 9 partake in NAPLAN (the National Assessment Program – Literacy and Numeracy) in order to determine whether they are meeting important education outcomes. In 2023, the Australian Curriculum, Assessment and Reporting Authority (ACARA) implemented changes to how they report and measure NAPLAN […]
Read More
State Government – DataOps Framework
The Problem Exposé was engaged to complete a review of this organisation’s development processes and practices for their data team. This review identified extensive manual processes with key dependencies on specific team members to facilitate updates per data product. Symptomatic of the above processes meant the data team required elevated system access to all products within the organisation. This was flagged as a […]
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
Defence Industries – Workforce Planning Tool
The Problem Our Defence Industries Client had previously forecast project resource requirements over the life of their projects. However, the process was manually intensive and did not integrate and utilise a number of relevant data sources. Defence Industries often involve having large-scale projects with extended timeframes. The scale of these projects often has a noticeable impact on the labour market as […]
Read More
RAA – GUA Data Migration to Azure
The Problem RAA uses Google Universal Analytics to track various statistics and interactivity within their website and tools to get insights and ultimately make better-informed decisions within the organisation. Google Universal Analytics, however has since been deprecated and replaced with Google Analytics 4. RAA needed to export all the Google Universal Analytics data related to […]
Read More
State Government – Enterprise Data Model
The Problem This state government client is a statutory body that provides risk management and insurance to government departments and authorities. The client recently implemented a new core insurance system and reporting platform. However, the reporting platform could not fully utilise the data from the new system due to a mismatch of design, terminology, and […]
Read More