kql database
10 TopicsFrom Rain Drops to Playability: Scoring Real-Time Weather Insights for FIFA World Cup 2026⚽
In this blog, I will walk you through how we can support the FIFA World Cup 2026 by organizing teams and players by delivering real-time, actionable weather insights. By predicting critical weather patterns - such as high humidity, extreme heat, and sudden rainfall - teams can proactively adjust their game-day strategies, and organizers can ensure optimal player safety. To bring this vision to life, we will build a comprehensive, real-time weather monitoring dashboard covering all 16 FIFA World Cup stadiums, powered entirely by the real-time analytics capabilities of Microsoft FabricEventhouse vs Lakehouse - When to Use Which in Microsoft Fabric?
Microsoft Fabric offers multiple storage and analytical engines. This blog helps you make the right architectural choice early on and save them massive migration efforts later. In this blog, I’ll walk you through the differences between these two powerhouses, look at real-world challenges, map out concrete scenarios, and give you a definitive comparison framework so you can choose the right tool for the job.Building Real-Time Indian Railways Dashboard in Microsoft Fabric – A step-by-step guide
In this blog, I’ll walk you through how to build a Real-Time Indian Railways Train Running Status Dashboard using Microsoft Fabric. We’ll stream live railway data from a public API into Eventstream, store it in Eventhouse, transform it using KQL, and finally visualize it in a real-time dashboard.Optimizing Real-Time Analytics in Microsoft Fabric RTI with Follower and Read-Optimized Databases
This article discusses about an architectural pattern to achieve better performance when trying to work with traditional relational database schema in Microsoft Fabric Real Time Intelligence (RTI). A common scenario is that you have Fabric as the enterprise data platform that ingests data from a live system running at scale. This article addresses two common requirements: You have streaming ingestion with variety of consumers for the data. You have use cases that demand fast response time even when the query is joining huge tables. The pattern discussed here uses a database shortcut in Fabric RTI, also known as a follower database, and a read-write database. With the database shortcut, each downstream system gets dedicated capacity and SLAs. With a read-write database, data can be denormalized and stored in a read-optimized format to improve real time query performance.Building a Real-Time Weather Dashboard in Microsoft Fabric: Step-by-Step Guide
In this blog, I’ll walk you through how to build a Real-Time Weather Analytics Dashboard in Microsoft Fabric by streaming public weather feeds into Eventstream, storing them in Eventhouse, and finally visualizing them in a Real-Time Dashboard. For this example, I’m using Bengaluru, India and several of its suburban locations.Migrating to Fabric RTI from ADX
Migrating to Microsoft Fabric Real-Time Intelligence (RTI) from Azure Data Explorer (ADX) offers several benefits for organizations looking to enhance their data analytics capabilities. This article outlines how to efficiently migrate from ADX to Fabric RTI. Dive into the future of data analytics with Fabric RTI and see how it can transform your business operations.Real-Time Analysis of Microsoft Form Responses with Microsoft Fabric Real-Time Intelligence
Collecting data using Microsoft Forms is a common practice, and analyzing the responses in real time is incredibly valuable. In the past, many users relied on the Streaming Semantic Model (Dataset) in Power BI to capture and visualize live data. However, with the recent retirement of this feature, it's time to use Microsoft Fabric Real-Time Intelligence as the new solution for live reporting.