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
Higher Education – Student Attrition
The Problem An education provider based in South Australia receives government funds that are measured upon when students complete identified courses. They had identified that there were critical points within the student engagement with the organisation where there was a high attrition rate. This ultimately resulted in missed revenue opportunities for the organisation. The […]
Read More
Winemaking – Supply Analytics
The Problem This client previously undertook a project to enhance how they use their data and subsequently committed to a company-wide transformation of their data models and reporting systems, beginning with Supply. With a focus on building complex data models to drive Inventory at Risk analysis and Sustainability reporting, the intent was to replace […]
Read More
Software Provider – From Foundation to Reporting
The Problem This client provides comprehensive software solutions and business automation tools to small business owners. This client has a customisable solution used internally across the organisation, where management reports are generated on a frequent and ad-hoc basis. These reports ensure client data reconciles across multiple data sources, such as Salesforce and Zuora. As a […]
Read More
Insurance – Business Intelligence & Data Warehouse Disaster Recovery Plan
The Problem This insurance client provides quality motor, home and travel services to the people of South Australia and Broken Hill. As they move from an on-premises business intelligence infrastructure using Microsoft data platforms towards a hybrid architecture in the cloud on Azure, they are reviewing its disaster recovery and business continuity plan to […]
Read More