Azure Fabric by Bravas Technology
Enterprise ETL pipelines, structured SQL warehouse tables, and analytics-ready SafetyCulture data built natively in Microsoft Fabric.
Features
Lakehouse Medallion Model
SafetyCulture API data is landed into Bronze storage within Fabric Lakehouse, transformed into curated Silver datasets, and structured into Gold analytical tables. This layered approach ensures data quality, schema enforcement, and controlled promotion to reporting. The Medallion architecture supports scalable enterprise analytics
Dataflow & Notebook Transformations
Fabric Dataflows Gen2 and Spark notebooks handle schema mapping, JSON flattening, and business rule application. Incremental ingestion logic ensures efficient refresh cycles. Batch traceability supports monitoring and troubleshooting.
Semantic Model Optimisation
Gold-layer tables are structured for Power BI semantic modelling with clearly defined relationships and KPIs. This enables consistent metric definitions across executive dashboards. Data governance ensures secure access to reporting datasets.
Incremental Load Strategy
Watermark-based ingestion reduces unnecessary compute consumption and improves performance. Each batch execution is timestamped and traceable across layers. This supports reliable enterprise refresh processes.
BI Visualisations & Dashboards
Interactive Power BI dashboards are built directly on top of Gold datasets. Reporting models support executive, operational, and compliance analytics. Reusable semantic layers enable scalable self-service BI.
Description
Bravas delivers a scalable, production-ready integration from SafetyCulture into Microsoft Fabric.
SafetyCulture data is extracted via REST API, landed into Fabric Lakehouse Bronze storage, transformed into curated Silver datasets, and promoted into structured Gold warehouse tables and semantic models within Fabric.
The solution supports:
• Full and incremental endpoint ingestion
• Watermark-based updates
• Batch-level traceability
• Lakehouse-based Bronze, Silver, and Gold layering
• Structured SQL transformations
• Relational modelling for inspections, actions, users, groups, sites, and activity logs
• Business-ready marts and Power BI-ready datasets
• Watermark-based updates
• Batch-level traceability
• Lakehouse-based Bronze, Silver, and Gold layering
• Structured SQL transformations
• Relational modelling for inspections, actions, users, groups, sites, and activity logs
• Business-ready marts and Power BI-ready datasets
Microsoft Fabric serves as the unified data and analytics layer, optimised for governed reporting and enterprise-scale BI.
Testimonials
Tyler Mason
CTO at El Jannah
The Bravas team delivered an excellent end-to-end data solution for El Jannah, integrating SafetyCulture, Employment Hero, Deputy, and Sonder data into our Azure environment. Their structured approach and technical expertise gave us a reliable, scalable data foundation for reporting and operational insights. The implementation was professional, well-managed, and aligned to our broader data strategy.
Pricing
* The pricing here is for display purposes only. You should contact the partner for the most up to date and correct pricing information. We do not take any responsibility for this pricing information, which is provided by our partners. Pricing last updated: 24 Feb, 2026 12:00AM
FAQ
Synapse Workspace, Dedicated SQL Pool or Serverless SQL, and ADLS Gen2.
Azure Monitor recommended for observability.
Charged for SQL compute, storage, and pipeline execution.
