Duration
1 day
Overview
Microsoft Fabric provides an end-to-end platform for data solutions, including real-time data analytics. Synapse Real-Time Analytics in Fabric uses a KQL Database to provide table storage and Kusto Query Language (KQL) which is a powerful tool for analyzing data. This structure provides an efficient way to find insights and patterns from textual or structured data. Moreover, KQL is optimized for data that includes a time series component, such as real-time data from log files or streaming services. With Real-Time Analytics, you can focus and scale up your analytics solution while democratizing data for the needs of your entire data organization.
In Fabric, you only need a source and a Kusto database to start streaming data in and out of Fabric and writing your queries using KQL. Microsoft Fabric also provides KQL Querysets that can be shared within the tenant and Power BI using what's known as quick create.
Outline
- What is Synapse Real-Time Analytics?
- Understand Real-Time Analytics in Microsoft Fabric
- Kusto Query Language (KQL)
- Understand KQL database and tables
- Real-Time Analytics core components
- KQL Database objects
- Write queries with KQL
- Create and load tables in KQL
- Retrieve data from a table
- Filter with the where clause
- Sort query results
- Summarize and aggregate
- Exercise: Explore Synapse Real-Time Analytics in Fabric
Summary
Real-Time Analytics is a fully managed big data analytics platform optimized for streaming, time-series data. It contains a dedicated query language and engine with exceptional performance for searching structured, semi-structured, and unstructured data with high performance. Real-Time Analytics is fully integrated with the entire suite of Fabric products, for both data loading and advanced visualization scenarios.
KQL database and the Kusto Query Language (KQL) are powerful features to help you explore your streaming data within Fabric. Kusto provides a structure that is similar to SQL with the use of databases, tables, and columns with the extended capabilities to balance large data for better performance within your queries.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.