From IoT data to meaningful data

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

Cyber model VALUE OF IOT DEPLOYMENTS Analytics

Slide 4

Slide 4 text

How IoT Data can be meaningful? Accessible To business databases To data engineers/scientists To business applications Enriched With context data With reference data Realtime

Slide 5

Slide 5 text

The nature of IoT Data JSON Documents Metadata Unstructured bin DeviceId 14f8gq51gq Customer ContosoCity LocationGps 43.5887 1.4522 DeviceType AirQualityv2 Building Main BuildingType School { "TimeStamp": "2020- 0812T13:58:07.5203217Z", "Co": 20.6515621746199, "Co2": 48.47952265338019, "Ppm10": 257.44680750414, "Ozone": 163.747165663515, "EventProcessedUtcTime": " 2020-08- 12T13:58:13.2928373Z", "PartitionId": 3, "EventEnqueuedUtcTime": "2 020-08-12T13:58:08.08500Z" Weather Sunny Wind (km/h) 28

Slide 6

Slide 6 text

Enrich IoT Data

Slide 7

Slide 7 text

An IoT Architecture Azure IoT Hub ? Where to store our data ? Where to process our data ? Power BI

Slide 8

Slide 8 text

Store processed data Enrich data before storing it Azure IoT Hub Azure Data Lake Gen 2 Azure Stream Analytics Azure Synapse Analytics Azure SQL Datawarehouse Azure SQL Power BI Store raw data

Slide 9

Slide 9 text

Azure IoT Hub Azure Stream Analytics X events / second 1 line / device / hour

Slide 10

Slide 10 text

Using IoT as an operational Data Source Azure IoT Hub Azure Data Lake Gen 2 Azure Stream Analytics Azure Synapse Analytics Azure SQL Datawarehouse Azure SQL Power BI Azure Data Factory Synapse Analytics

Slide 11

Slide 11 text

Enriching data with Stream Analytics and Synapse DEMO

Slide 12

Slide 12 text

Make IoT Data accessible

Slide 13

Slide 13 text

Who needs to access IoT data ? Who? Type of data Tools of trade Data / Business analysts Aggregated data Power BI SQL Databases Time Series Insights … Developers Raw data Event stream Aggregated data IoT Hub / Event Hub Logic App (Webhook) Synapse (SQL) / Azure Data Lake Time Series Insights … Data Scientists Raw data Synapse (SQL) Azure Data Lake Notebooks … End users Aggregated data Enriched data Power BI Teams Business applications …

Slide 14

Slide 14 text

IoT empowers immediate action

Slide 15

Slide 15 text

IoT Data exploration with Time series insights, Power BI, CosmosDB and Logic Apps DEMO

Slide 16

Slide 16 text

Using IoT as an operational Data Source Azure IoT Hub Teams Business services Azure Data Lake Gen 2 Azure Stream Analytics Event Hubs Logic App Azure Synapse Analytics Azure SQL Datawarehouse Azure SQL Time Series Insights Power BI Azure Data Factory Synapse Analytics

Slide 17

Slide 17 text

No content