demo.fabric/mfg-scada-lakehouse
Reference Architecture · Manufacturing
Multi-Plant SCADA Telemetry & SAP Ingestion via OneLake
Business Challenge: Operational sensor telemetry was trapped in plant historians while financial production orders resided in SAP, making true line OEE and scrap cost analysis delayed by weeks.
Data Sources: Siemens SCADA, Wonderware Historians, SAP S/4HANA (PP/MM), Maintenance Work Orders.
Architecture Approach: Fabric Data Factory streaming ingestion into OneLake Bronze Delta tables. PySpark notebook cleanses telemetry and joins against Gold ERP dimension tables with Direct Lake Power BI scorecards.
Demonstrated Scenario Outcomes: Sub-minute equipment downtime classification and automated daily scrap variance tracking across production lines.
Microsoft Fabric
Delta Lake
PySpark
Direct Lake
demo.fabric/omnichannel-retail-lakehouse
Reference Architecture · Retail & FMCG
Automated Omnichannel POS & Inventory Margin Intelligence
Business Challenge: Managing 140+ physical retail stores alongside 3 e-commerce channels caused severe stockouts on fast-moving SKUs and blind spots on true promotional margins.
Data Sources: Oracle Retail POS, Shopify Plus APIs, Manhattan Associates WMS, SAP Finance.
Architecture Approach: Incremental CDC ingestion through Dataflows Gen2 into Fabric Lakehouse. Curated semantic star-schema model with Direct Lake sub-second response times.
Demonstrated Scenario Outcomes: Real-time store stockout risk notifications and unified gross margin reporting across 18,000 active SKUs.
Fabric Data Factory
Dataflows Gen2
Star Schema
Direct Lake
demo.fabric/logistics-fleet-portal
Reference Architecture · Logistics
Fleet Telematics & On-Time In-Full (OTIF) Delivery Portal
Business Challenge: Tracking multi-carrier freight movements, GPS telematics events, and demurrage penalties across cross-border transport routes was entirely manual.
Data Sources: Geotab Telematics, Oracle Transportation Management (OTM), Fuel Gateways, Carrier EDI feeds.
Architecture Approach: Automated event ingestion into Fabric Lakehouse. Operational custom application built with React and Fabric REST APIs for route-level exception drill-down.
Demonstrated Scenario Outcomes: Live OTIF compliance tracking, route dwell time benchmarking, and proactive demurrage penalty warnings.
Custom React App
Fabric REST APIs
OTIF Analytics
demo.fabric/financial-risk-treasury
Reference Architecture · Financial Services
Multi-Entity Treasury Liquidity & Regulatory Reporting
Business Challenge: Consolidating 28 legal entity ledgers with multi-currency conversions and complex regulatory capital adequacy reporting was taking 14 days per month.
Data Sources: Finacle Core Banking, Calypso Treasury, Oracle Financials Cloud, Bloomberg Market Feeds.
Architecture Approach: Fabric SQL Warehouse dimensional modeling with automated daily currency rate conversion, Kimball star-schemas, and row-level security for regional compliance.
Demonstrated Scenario Outcomes: Automated daily liquidity ratio calculations and instant consolidated balance sheet visibility.
Fabric Warehouse
T-SQL Stored Procs
Row-Level Security
demo.fabric/real-estate-portfolio-yield
Reference Architecture · Real Estate
Commercial & Residential Portfolio Yield Optimization
Business Challenge: Tracking lease expiries, rental collection milestones, and tenant arrears across 16 mixed-use developments required manual spreadsheet compilation.
Data Sources: Yardi Voyager, Salesforce Real Estate, On-prem SQL Property Ledgers.
Architecture Approach: OneLake shortcut integration with Delta Lake tables. Power BI executive scorecards with role-based access filtering by property manager.
Demonstrated Scenario Outcomes: Automated 90-day lease expiry alerts and tenant collection rate benchmarking.
OneLake Shortcuts
Power BI RLS
Yield Modeling