Unified Data Platform on Microsoft Fabric

Prior to engaging Saints & Masters, the hospitality group lacked a unified reporting layer, relying on fragmented data sources and manual processing across properties. This created several compounding operational and governance risks:

• •Disparate Data Sources: Monthly Trial Balance Excels from Sun Systems and daily ORS TXT files were managed in silos with no integration, making consolidated reporting impossible without significant manual effort.
• •No Unified Reporting: Fragmented data across SharePoint folders made it impossible to produce consistent, validated analytics — leaving leadership without a single source of truth for decision-making.
• •Scalability Concerns: Growing data volumes across properties demanded a platform capable of handling increasing load without redesign, but the existing file-based approach had no path to scale.

Delivery

Saints & Masters designed and deployed a Medallion Architecture on Microsoft Fabric with full data lineage and audit controls, structured across four key workstreams:

• •ADF Ingestion & Orchestration: Automated pipelines for daily ORS TXT file ingestion and monthly Trial Balance Excel loads from SharePoint via Azure connectors.
• •Bronze Layer – Raw Zone: All ingested files loaded into Microsoft Fabric Lakehouse as raw, unmodified data preserving source fidelity.
• •Silver Layer – Cleansed Zone: SQL views and Fabric pipelines apply transformations, null checks, type enforcement, referential integrity, and FX rate enrichment.
• •Control Table & Audit Trail: Implemented control tables to manage data lineage, audit history, and duplicate handling across the entire pipeline.

Results

The Microsoft Fabric implementation delivered measurable improvements across data governance, reporting, and operational scalability:

• •2 Source Systems Unified: Transition from siloed Sun Systems and Oracle ORS data to a single lakehouse with a standardised Medallion Architecture spanning all properties.
• •100% Automated Ingestion: Move from manual file handling and SharePoint folder management to fully automated ADF pipelines for both daily and monthly data loads.
• •Unified Power BI Reporting: Transformed and enriched data flows into Power BI dashboards — providing a single source of truth across all properties for financial and operational decision-making.
• •Audit-Ready Data Lineage: Control tables track every data movement, ensuring full traceability, compliance, and governance across the pipeline.
• •Scalable & Future-Ready: Medallion architecture enables seamless onboarding of new data sources and properties without platform redesign.