Prepare data

Official references for this objective

• Microsoft — Data Types - Stream Analytics Query | Microsoft Learn

  You can pre-process the data and convert it to string. One option is using Azure functions to pre-process the data and convert such large integers

• Microsoft — Reference Data JOIN - Stream Analytics Query | Microsoft Learn

  Using complex expressions, or inequalities, will internally result in cross joins followed by filters (full scan vs lookup), which can severly impact the overall latency.

• Microsoft — Big Data, Multivariate, Window based Feature Engineering using Microsoft R Server | Microsoft Learn

  the important aspect that needs to be captured for prediction is the multivariate relationship between different sensors, rather than isolated sensors statistics

• Microsoft — Get started with Microsoft Fabric Ep05: Ingest Data with Dataflows Gen2 in Microsoft Fabric | Microsoft Learn

  Microsoft Fabric's Data Factory offers Dataflows (Gen2) for visually creating multi-step data ingestion and transformation using Power Query Online