Designing and implementing metadata-driven architecture

Case study with our client in the state government

Our client is a state government department that is aiming to modernise its Operational Management System (OMS) by decoupling reporting from core transactional processes. Previously, reporting was tightly coupled with the operational relational database, resulting in inefficiencies, duplicated effort, and limited scalability.

Challenge: Decoupling reporting and processing to streamline operations

Our client is a state government department that is aiming to modernise its Operational Management System (OMS) by decoupling reporting from core transactional processes. ​

Previously, reporting was tightly coupled with the operational relational database, resulting in inefficiencies, duplicated effort, and limited scalability.​

The Operational Information Systems (OIS) team identified an opportunity to shift analytics to a dedicated Microsoft Fabric lakehouse, decoupling day-to-day operational processing from reporting and analytics workloads. This would streamline data access, improve performance, and reduce ad hoc reporting by enabling enriched insights through reusable Power BI dashboards, ultimately freeing up the team to focus on higher-value work.​

Solution: Design and implementation of a Microsoft Fabric lakehouse platform

DataDivers co-architected a Microsoft Fabric lakehouse platform with the Department, using medallion architecture and star schema modelling to align with OIS requirements. ​

We applied our Open Water Fabric framework to enable this metadata-driven solution for the Department. This solution was one of the first of its kind, automating ingestion and transformation logic to enable repeatable reporting.​

As an early adopter of Microsoft Fabric, we took the lead in designing and implementing the metadata-driven architecture, while Microsoft supported the initiative with technical guidance and stayed closely engaged throughout the project’s delivery. The solution integrated with Power BI and existing intranet workflows, enabling decentralised, team-owned reporting with ease of access.​

Value delivered: Streamlined access to trusted data

Implementing a Microsoft Fabric lakehouse platform with our Open Water Fabric approach enabled:​

  • Reduced dependency on ad hoc reporting by enabling repeatable, metadata-driven processes.​
  • Empowered teams to self-serve insights via secure Power BI apps embedded in the intranet.​
  • Improved cross-departmental trust in data as Fabric became a recognised source of truth.​
  • Accelerated reporting and modelling speed, freeing OIS staff to focus on higher-value work.​
  • Upskilled internal team members, with staff actively pursuing Fabric certifications.

DataDivers

DataDivers’s domain in Rmkble is the deep ocean of data, analytics, and AI. Their expertise spans data and AI strategy, building data and AI platforms and hubs, advanced AI and ML driven analytics and data science, and creating a data first culture.

Learn more

Real stories. Real outcomes.

Customer stories from some of the many terrains traversed by Rmkble consultants.
Get in touch

Let's create positive change for your organisation

If you’re ready to discuss your goals, reach out to us via the form and one of our team members will be in contact with you.

Alternatively, drop us a query or an expression of interest at: operations@rmkble.com.au.

Thanks for reaching out! We've got your submission and one of our team members will be in touch soon.
Oops! Something went wrong while submitting the form. Please try again or email to basecamp_support@journeyone.com.au.