Implementing Real Time Intelligence with Microsoft Fabric – Applied Skills Workshop

Overview

In this workshop, the student is exposed to various ways to:

• Source streaming data sources into Microsoft Fabric.
• Use real time Eventstream in Microsoft Fabric.
• Query data in a KQL database in Microsoft Fabric.
• Create real time dashboards in Microsoft Fabric.

Prerequisites

The student should be able to:

• Log in to the Azure portal.
• Explain and create resource groups.
• Understand the concept of streaming data.

Outline

Module 1: Get started with Real-Time Analytics in Microsoft Fabric

Analysis of real-time data streams is a critical capability for any modern data analytics solution. You can use the Real-Time Analytics capabilities of Microsoft Fabric to ingest, query, and process streams of data.

• Introduction
• What is Synapse Real-Time Analytics?
• Understand KQL database and tables
• Write queries with KQL
• Exercise: Explore Synapse Real-Time Analytics in Fabric
• Knowledge check
• Summary

Module 2: Use real time eventstreams in Microsoft Fabric

This module is an introduction to the Microsoft Fabric Eventstream within Real-Time Analytics (RTA)

• Introduction
• Main components of Eventstream
• Setting up Eventstream
• Routing eventstream data
• Exercise – Load data into a KQL database using Microsoft Fabric Eventstream
• Knowledge check
• Summary

Module 3: Query data in a KQL database in Microsoft Fabric

This tutorial provides a brief introduction to KQL (Kusto Query Language) queries using Querysets and the major differences between KQL and T-SQL when using Querysets.

• Introduction
• Get started with KQL queries
• KQL best practices
• Advanced features
• Exercise – query a KQL database in Microsoft Fabric
• Knowledge check
• Summary