This course is designed to equip professionals with the essential skills needed to implement real-time analytics using Microsoft Fabric. Participants will gain hands-on experience with Microsoft Fabric's Real-Time Intelligence capabilities, learning how to ingest, query, and process data streams efficiently. The curriculum covers key aspects such as writing KQL queries, setting up event streams, and creating real-time dashboards, making it invaluable for those looking to enhance their data analytics proficiency.
By completing this course, individuals will be able to create and manage real-time data solutions, leveraging advanced features of Microsoft Fabric. The practical exercises included will ensure that learners can apply their knowledge in real-world scenarios, thereby improving their ability to monitor, analyze, and act on data in real-time.
Audience Profile
This course is ideal for data professionals, business analysts, and IT specialists who are responsible for managing and analyzing data streams. It is also suitable for individuals in roles such as data engineers and developers who want to expand their skills in real-time data processing and dashboard creation using 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 data warehouses in Microsoft Fabric
- Describe Microsoft Fabric Real-Time Intelligence?
- Understand KQL database and tables
- Describe Microsoft Fabric Real-Time hub
- Write queries with KQL
- Exercise: Explore Real-Time Intelligence in Fabric
Module 2: Use real time eventstreams in Microsoft Fabric
- Main components of event streams
- Setting up event stream
- Routing event stream data
- Exercise - Load data into a KQL database using Microsoft Fabric event stream
Module 3: Use real time eventstreams in Microsoft Fabric
- Get started with KQL queries
- KQL best practices
- Advanced features
- Exercise - query a KQL database in Microsoft Fabric
Module 4: Create Real-Time Dashboards with Microsoft Fabric
- Get started with Real-Time Dashboards
- Advanced features
- Real-Time Dashboards best practices
- Exercise - create a Real-Time Dashboard
Module 5: Get started with Data Activator in Microsoft Fabric
- Understand Data Activator
- Get started with Data Activator
- Understand triggers, conditions and actions in Data Activator
- Get data from Power BI Reports and EventStreams with Data Activator
- Assign data in Data Activator
- Create triggers in Data Activator
- Exercise – Use Data Activator in Fabric
