Toggle dark/light theme
← Back to catalog
Architecture diagram
Expand

Real-Time Manufacturing

Overview

Monitor manufacturing operations in real-time, combine data from quality test benches and IoT senors with masterdata from your SAP ERP system. Ask an AI agent questions on the data and do advanced analytics with Power BI reports on the history of data.

Class
Community
Type
Demo
Difficulty
Intermediate
Deploy Time
~8 min
Complete Time
~10 min

Workloads

Real-Time IntelligencePower BIData EngineeringData Science

Fabric Items Deployed

  • Notebook
  • Eventhouse
  • Eventstream
  • KQL Database
  • Real-Time Dashboard
  • KQL Queryset
  • Semantic Model
  • Report
  • Activator
  • Data Agent
  • Lakehouse
  • Data Pipeline

Scenarios

Streaming

This jumpstart deploys an end-to-end demo that showcases a modern manufacturing scenario: streaming machine telemetry, ingesting SAP master data, building a Lakehouse + Eventhouse, and surfacing insights through Power BI reports, a real-time KQL dashboard, and an AI Data Agent.

✨ What's Inside

  • πŸ“‘ Eventstream β€” ingests live MQTT machine telemetry into the Eventhouse
  • πŸ”₯ Eventhouse / KQL Database β€” stores and queries high-volume sensor data in real time
  • 🏞️ Lakehouse β€” holds SAP master data (customers, suppliers, plants, equipment, products) and curated production quality data
  • πŸ““ Notebooks β€” simulate machine data, ingest SAP data, process master data, and run Spark Structured Streaming
  • πŸͺˆ Data Pipeline β€” orchestrates the end-to-end flow
  • πŸ“Š Reporting β€” Power BI report, Semantic Model, and an MQTT Real-Time Dashboard
  • πŸ€– AI Data Agent β€” natural-language Q&A over the manufacturing data

πŸ› οΈ Post-Deployment Setup

After installing the jumpstart, run the PostDeploymentNotebook. It wires everything together β€” loading sample data, configuring connections, and getting the demo ready to use.

πŸŽ‰ Have Fun

Once the PostDeploymentNotebook has been running for about 5 minutes, you can already see streaming data visualized in the Real-Time Dashboard (Reporting Folder).

RealtimeDashboard
RealtimeDashboard

You see the core KPIs updating in real-time. Explore the other pages of this dashboard to drill down on sensor data timeseries and to see the most recent records arriving.

Once the PostDeploymentNotebook has been running for about 10 minutes, you can also go to the Power BI report ManufacturingOperationsReport and dive deeper on how KPIs have been trending over time, and how they differ by dimensions like sites, time, shifts and machines.

ManufacturingOperationsReport
ManufacturingOperationsReport

Lastly, open the πŸ€– TalkToManufacturingData Data Agent and ask natural-language questions like "What is the latest sensor data for the compressor motor in the shangai industrial site?" or "Which site had the lowest quality in the last 4 weeks?":

TalkToManufacturingData
TalkToManufacturingData

Explore the Notebooks, Eventhouse KQL queries, and Pipelines to see how the entire solution fits together. πŸ”

πŸ“ Folder Organization

Folder Purpose
AI/ πŸ€– Data Agent definition
Develop/ πŸ““ Notebooks (simulation, ingestion, streaming, master data)
Eventhouse/ πŸ”₯ KQL Eventhouse for real-time telemetry
Eventstream/ πŸ“‘ MQTT and machine-data Eventstreams
Lakehouse/ 🏞️ Manufacturing Lakehouse
Pipeline_orchestration.DataPipeline/ πŸͺˆ Orchestration pipeline
PostDeploymentNotebook.Notebook/ πŸ› οΈ One-click setup after deployment
Reporting/ πŸ“Š Power BI Report, Semantic Model, KQL Dashboard
deploy.py 🚒 fabric-cicd deployment script
parameter.yml πŸŽ›οΈ Environment-specific parameter overrides