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.​

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.​

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.