Opi mitä tarkoittaa Microsoft Fabric Real-Time Intelligence
Tavoite
Tällä Microsoft Applied Skills koulutuksella on tavoitteena saada yleiskäsitys Microsoft Fabricista keskittyen sen Real-Time Intelligence -konseptiin. Kurssin lopussa suoritetaan Applied Skills Assessment, jolla voi osoittaa osaamisensa.
Kenelle
Kurssi on suunnattu Data-ammattilaisille, jotka mm. mallintavat ja analysoivat dataa, kuten Data Analyst, Data Engineer, Data Scientist.
Koulutuksen sisältö
Prepare a Real-Time Intelligence environment
- Create a KQL database
- Create lookup tables
- Enable data mirroring in OneLake
- Create an Eventhouse and add a KQL database
Create and load data from external sources
- Load data from a storage account
- Create an external table
- Validate that data sources are loaded correctly by using a row count, a filtered count, and a group by count
Load and process streaming data by using Eventstreams
- Connect a streaming dataset to an Eventstream
- Load data directly
- Configure event processing
- Load data by using windowing
- Send data to a KQL database
Explore the data
- Convert SQL to KQL
- Query data for min/max, median, and summary statistics
- Visualize data by using the render operator, including bar, line, column, and scatter charts
- Perform row-based calculations
- Create relationships between tables
- Process free text data by using the parse operator
Manipulate data
- Change data types by using a table variable
- Group or aggregate data by using the top-nested operator
- Perform data cleansing processes on the data, including time-series
- Create an update policy
- Create a materialized view
- Create a user-defined stored function
Avainsanat
Microsoft Fabric, Fabric Real-Time, Fabric Data Activator