Microsoft Fabric Lakehouse platform architecture

The Department of Fire & Emergency Services (DFES) aimed 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 an Open Water Fabric lakehouse platform with DFES, using medallion architecture and star schema modelling to align with OIS requirements. OpenWater Fabric is a metadata-driven solution, one of the first of its kind, which automated ingestion and transformation logic, enabling 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.

• 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
• Up-skilled internal team members, with staff actively pursuing Fabric certifications