×

DP-603 Implement Real-Time Analytics with Microsoft Fabric

Duration: 1 Day
Course Code: DP-603
Course Delivery: Virtual (1-Day) GMT/Virtual (1-Day) PST
Level: Beginner

Course Overview

In this learning path, 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

Audience Profile

Students wishing to Implement Real-Time Analytics with Microsoft Fabric

Course Objectives

After completing this course, students will be able to:

• Get started with Real-Time Analytics in Microsoft Fabric
• Use real time eventstreams in Microsoft Fabric
• Query data in a KQL database 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.

Course 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. In this module learn how to use the Real-Time Analytics capabilities of Microsoft Fabric to ingest, query, and process streams of data.

Lessons

Implement Real-Time Analytics with Microsoft Fabric
Introduction
What is Synapse Real-Time Analytics?
Understand KQL database and tables
Write queries with KQL
Exercise: Explore Synapse Real-Time Analytics in Fabric

After completing this module, students will be able to:

Describe Real-Time Analytics in Microsoft Fabric
Create Real-Time Analytics databases and tables
Use KQL to query tables

Module 2: Use real time event streams in Microsoft Fabric+

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

Lessons

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

After completing this module, students will be able to:

• Establish source and destinations in Eventstream
• View the data in-flight in eventstream items
• Capture, transform, and route data using Eventstream

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

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

Lessons

• Introduction
• Get started with KQL queries
• KQL best practices
• Advanced features
• Exercise - query a KQL database in Microsoft Fabric

After completing this module, students will be able to:

• Use basic syntax and of Kusto Query Language (KQL).
• Understand the basics of the Queryset canvas.
• Describe how to execute T-SQL queries in the Queryset canvas.
• Describe how to convert T-SQL queries into KQL queries.

Book this Course

Date Delivery Format Location Price Add to cart
29 May 2024 Virtual (1-Day) PST Online £195.00 £125.00 Book me in
12 June 2024 Virtual (1-Day) GMT Online £195.00 £125.00 Book me in
3 July 2024 Virtual (1-Day) PST Online £195.00 £125.00 Book me in
17 July 2024 Virtual (1-Day) GMT Online £195.00 £125.00 Book me in

If you have any questions or are looking for customised training for you or your team, please contact us

Exam Information