Real-Time Intelligence (RTI) in Microsoft Fabric (Fabric) is revolutionizing how Power BI professionals create high-performance, interactive, real-time reporting solutions.
This hands-on workshop is for those who want to understand the potential of Real-Time Intelligence in Microsoft Fabric. Designed with Power BI professionals in mind, this workshop helps bridge the gap between traditional Power BI development and real-time intelligence by introducing Fabric's RTI capabilities, Kusto Query Language (KQL), and how to seamlessly integrate Power BI with RTI. Additionally, it will showcase how RTI can be used to monitor Power BI Workspaces and govern Microsoft Fabric activities.

This workshop has a blend of hands-on and instructional content. By the end of the workshop, participants will have built a real-time solution powered by Microsoft Fabric’s RTI and Power BI, understood key differences between SQL and KQL, and learned how to integrate real-time telemetry, monitoring, and analytics into their Fabric solutions.

Attendees will:
✅ Get an introduction to RTI
✅ Build a Power BI solution based on sample real-time data
✅ Learn how to optimize query performance for data in motion
✅ Use Activator to set up alerts and take actions on live data
✅ Learn how to implement best practices for security, data modeling, and governance in real-time data solutions
✅ Understand RTI's cost model
✅ Understand latest RTI public preview announced features

Who Should Attend?
✅ Power BI Developers & Analysts
✅ Data Engineers & Architects
✅ Anyone interested in getting started with RTI

Workshop Agenda & Key Topics: (Note: The Workshop will be split into parts and there will hands-on experience at the end of reach section)

1️⃣ Real-Time Intelligence (RTI) Fundamentals
🔹 Introduction to Real-Time Intelligence (RTI) in Microsoft Fabric (Streams, EventHouses, KQL Databases)
🔹 Why Power BI developers should care about RTI
🔹 KQL fundamentals and comparing SQL and KQL – When to use each
🔹 KQL Database Tables vs. Views vs. Functions
🔹Transformation differences between batch pipelines and data in motion
🔹 Real-Time Dashboards vs. Power BI Reports
🔹 Warehouse vs. KQL Database vs. Lakehouse – When to use each?

2️⃣ Connecting Power BI to Real-Time Data
🔹 How to connect Power BI Desktop to Eventhouse and KQL Databases
🔹 Understanding Query Folding between Power BI and KQL Databases
🔹 Dimensional modeling for KQL databases
🔹 Authentication options: Pass-through vs. Service Principals (SPNs)
🔹 Security perspectives of the Eventhouse and KQL database, including row, column, and object security
🔹 Power BI Storage modes: DirectQuery vs. DirectLake

3️⃣ KQL Database optimization for Power BI
🔹 How Power BI handles KQL tables, materialized views, and functions
🔹 Performance tuning for KQL databases and Querysets

4️⃣ Real-Time Monitoring & Governance with Power BI
🔹 Monitoring Power BI Workspaces with RTI & KQL – the easy way
🔹 Leveraging Eventstream & Fabric Monitoring for governance insights

5️⃣ Advanced Topics
🔹KQL Anomaly and forecasting functions (Time Series Analysis)
🔹Parsing JSON – you have never seen it this easy
🔹Graph data and how KQL can do things SQL cannot
🔹Geo-Spatial functions in KQL for both in-query and Power BI visualizations
🔹Cost considerations – How KQL impacts Power BI licensing & Fabric capacities


6️⃣ Real-World Use Cases and Best Practices
🔹Customer success stories of Real-Time Intelligence with Power BI solutions
🔹Reference Architecture for Analytics with Real Time Intelligence

⃣ Hands-On Lab: Building a Real-Time Power BI Dashboard
🔹 Create a KQL database/Eventhouse to stream live sample data
🔹 Practice KQL fundamentals
🔹 Create a real-time dashboard with auto-refreshing visuals
🔹 Understand the collaboration possibilities with Org Apps and RTI
🔹 Build Power BI reports from the KQL database
🔹 Explore governance & security best practices