22-25 April 2026

Real-Time Data Processing in Fabric: Tracking a Cycle Ride

Proposed session for SQLBits 2026

TL; DR

Real-time spatial analytics in Microsoft Fabric: Simulating a live cycle ride using Eventstream, Eventhouse, and KQL. Learn to map GPS data, calculate distances to the nearest off-licence, and automate geo-metadata—all on a live dashboard.

Session Details

We delve into the power of Microsoft Fabric for real-time data processing. Using data generated from a sports watch during a real cycle ride, we will simulate the ride and set up a live dashboard that dynamically visualizes the journey while leveraging KQL, Eventhouse, and Eventstream for analysis and insights.

You’ll discover how to leverage Microsoft Fabric to:

Process real-time GPS data streams and visualize the rider’s location on an interactive map.

Use KQL’s geographical functions to calculate distances to key points of interest, such as the nearest booze shop.

Dynamically identify postcodes and other geographical metadata based on the current location.

Gain insights into integrating spatial analytics into your real-time applications in Fabric.

This hands-on session will demonstrate the complete workflow, from ingesting streaming data into Fabric, applying transformations and spatial functions, to creating real-time dashboards.

3 things you'll get out of this session

* Build live data pipelines using Fabric Eventstream and Eventhouse. * Apply KQL spatial functions to analyze GPS data and geo-metadata. * Create dynamic dashboards to visualize real-time movement and insights.