From Fabric to Finance: Building Enterprise-Grade Planning & Forecasting on Microsoft Fabric

Description

Microsoft Fabric has fundamentally changed how enterprises store, model, and analyze data — but many organizations still struggle to turn that data into real-time operational and financial decisions. In this session, we will explore how to design an enterprise-grade planning and forecasting architecture natively on Microsoft Fabric, using Azure SQL, Power BI, and modern data pipelines to enable real-time write-back, scenario modeling, and governed collaboration across large organizations.

Attendees will learn how to:

• Architect a Fabric-native planning environment that supports concurrent users, auditability, and data integrity
• Design write-enabled analytical models using Azure SQL, Fabric Warehouses, and Power BI
• Implement scenario modeling, forecasting, and what-if analysis directly on enterprise data
• Apply governance, security, and performance best practices for mission-critical workloads
• Avoid common pitfalls that cause Fabric-based planning solutions to fail at scale

Key Takeaways

• Manisha Jha, Microsoft
• Prasanth Tammiraju, Quadrant Technologies
• 10. Use rich KQL queries for fast, direct, adhoc analytics.
• ensure it meets your real-life needs

My Notes

Action Items

• [ ]

Resources & Links

Slides

Fabric RTI and Foundry
Agents in Sustainable
Supply Chain Management
Presented By:
• Manisha Jha, Microsoft
• Prasanth Tammiraju, Quadrant Technologies
February 26th 2026
Our Speakers
Prasanth Tammiraju
(Quadrant)
Manisha Jha
(Microsoft)
Real-Time Intelligence Powers AI
and is Powered by AI
Cosmos DB logo
Real-Time Intelligence
in Microsoft Fabric
Stream
Analyze
Model
Visualize
Decide & Act
Fabric Platform
Copilot
OneLake
Real-Time Hub
Governance
Connectors
Real-Time Intelligence
in Microsoft Fabric
Stream
Analyze
Model
Visualize
Decide & Act
Connectors
Eventhouse
Map
KQL Queryset
Activator
Eventstream
Anomaly Detector
Graph
Graph Queryset
Operations Agent
Digital Twin Builder
Real-Time Dashboard
Actions
Event Schema Set
Connected Factory
Ingest & process
Analyze & transform
Train
Analyze & transform

1. Over 1M/1Hr IloT events, 30K Tags,
   from 40 factories are streamed in real
   time with sub second latency.
2. IloT events are enriched in-motion with
   the asset meta data and asset hierarchy,
   providing clean and curated data for
   consumption.
3. Build, train and score ML models
   in real time, persisting the scored
   data in OneLake.
4. Real time dashboard of all factories with
   ability to easily drill down from all
   factories view to a single asset details.
5. Contextualization data on the lIOT
   devices is collected from OPCUA
   library daily via MQTT.
6. Rich BI reports with detailed views on
   factories production, efficiency and
   maintenance.
7. Enriched data is aggregated with hourly
   and daily views per station and factory.
8. Factory inventory, shift details,
   component cost, etc. is synced to
   OneLake via Data Factory for data
   enrichment and contextualization.
9. Notify on site techs in response to live
   indications from the factory floor.
10. Use rich KQL queries for fast, direct, adhoc analytics.
    IoT Hub
    Eventstream
    Azure IoT
    Operations
    PBI Report
    Eventstream
    Eventhouse
    Asset MD
    Contextualization data
    MQTT
    Eventstream
    ERP
    Activator
    Real-Time
    Dashboard
    Data Factory
    OneLake
    ML Model
    Queryset
    Sound off.
    The mic is all yours.
    Influence the product roadmap.
    Join the Fabric User Panel
    Join the SQL User Panel
    Share your feedback directly with
    our Fabric product group and
    researchers.
    Influence our SQL roadmap and
    ensure it meets your real-life needs
    https://aka.ms/JoinFabricUserPanel
    https://aka.ms/JoinSQLUserPanel
    How was
    the session?
    Complete Session Surveys in
    for your chance to WIN
    PRIZES!