- Home
- IT Courses
- MS-DP603T00: Implement Real-Time Intelligence with Microsoft Fabric
MS-DP603T00: Implement Real-Time Intelligence with Microsoft Fabric
Course Code: MS-DP603T00
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.
This course is primarily designed for data professionals. This includes individuals who are involved in data engineering and data analytics, particularly those who handle real-time data.
The student should be able to:
- Log in to the Azure portal.
- Explain and create resource groups.
- Understand the concept of streaming data.
After completing this course, delegates will be able 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.
There is no Associated Certification & Exam for this course, however, there is a learning path for this course. (Assessment Link)
Modules
Analysis of real-time data streams is a critical capability for any modern data analytics solution. You can use the Real-Time Intelligence capabilities of Microsoft Fabric to ingest, query, and process streams of data.
Lessons
- Introduction.
- Describe Microsoft Fabric Real-Time Intelligence.
- Understand KQL database and tables.
- Describe Microsoft Fabric Real-Time hub.
- Write queries with KQL.
- Exercise: Explore Synapse Real-Time Analytics in Fabric.
- Knowledge check.
- Summary.
By the end of this module, you'll be able to:
- Describe Real-Time Intelligence in Microsoft Fabric.
- Create event house databases and tables using KQL database.
- Describe Real-Time hub in Microsoft Fabric.
- Use KQL to query tables and create querysets.
This module is an introduction to the Microsoft Fabric Eventstream within Real-Time Intelligence (RTI)
Lessons
- Introduction.
- Main components of Eventstream.
- Setting up event stream.
- Routing event stream data.
- Exercise - Load data into a KQL database using Microsoft Fabric event stream.
- Knowledge check.
- Summary.
By the end of this module, you'll be able to:
- Establish sources and destinations in event stream.
- View the data in-flight in event stream items.
- Capture, transform, and route data using Eventstream.
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.
Lessons
- Introduction.
- Get started with KQL queries.
- KQL best practices.
- Advanced features.
- Exercise - query a KQL database in Microsoft Fabric.
- Knowledge check.
- Summary.
After completing this module, you'll be able to:
- Use basic syntax and 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.
In this module, you’ll explore the user-friendly Real-Time Dashboard in Microsoft Fabric. This dashboard offers an auto-refresh feature for data, supports parameterization, and allows for a multi-page dashboarding experience without requiring any coding. It also integrates with Copilot to manage underlying query sets. This creates a seamless and efficient user experience.
Lessons
- Introduction.
- Get started with real-time dashboards.
- Advance features.
- Real-time Dashboards best practises.
- Exercise – create a Real-time Dashboard.
- Knowledge check.
- Summary.
After completing this module, you’ll be able to:
- Create a Real-Time Dashboard in Microsoft Fabric.
- Understand some of its advanced features.
- Apply some best practices for effective use.
- Have hands-on experience in a lab exercise.
Use Data Activator in Microsoft Fabric to easily monitor and take action on your data.
Lessons
- Introduction.
- Understand Data Activator.
- Get started with Data Activator.
- Understanding triggers, conditions, and action.
- Get data from Power BI Reports and Event Streams with Data Activator.
- Assign data in Data Activator.
- Create triggers in Data Activator.
- Exercise - Use Data Activator in Fabric.
- Knowledge check.
- Summary.
After completing this module, you’ll be able to:
- Understand Data Activator.
- Understand triggers, conditions, and actions in Data Activator.
- Get data from Power BI Reports and EventStreams with Data Activator.
- Assign data and create triggers in Data Activator.
- Interact with Real-Time Intelligence.