/MCW-Internet-of-Things

MCW Internet of Things

Primary LanguageC#MIT LicenseMIT

Internet of Things

Fabrikam provides services and smart meters for enterprise energy (electrical power) management. Their “You-Left-The-Light-On” service enables the enterprise to understand their energy consumption. Fabrikam would like to become an authorized energy management solution provider. According to their Director of Analytics, Sam George, "We are investigating a move to the cloud to help our customers not only to meet data collection and reporting requirements, but also become the number one energy management solution provider." They are intending to enable their enterprise customers with a web-based dashboard where they can see historical trends of power consumption.

Target audience

  • Application developer
  • IoT

Abstract

Workshop

This workshop will guide you through an implementation of an end-to-end IoT solution simulating high velocity data emitted from smart meters and analyzed in Azure. You will design a lambda architecture, filtering a subset of the telemetry data for real-time visualization on the hot path, and storing all the data in long-term storage for the cold path.

At the end of this workshop, you will be better able to construct an IoT solution implementing device registration with the IoT Hub Device Provisioning Service and visualizing hot data with Power BI.

Hands-on labs

Lab1 : Pirmary IoT Solution with hot path and cold path analytics

Duration: 5 hours

Internet of Things hands-on lab step-by-step

In this hands-on lab, you will construct an end-to-end IoT solution simulating high velocity data emitted from smart meters and analyzed in Azure. You will design a lambda architecture, filtering a subset of the telemetry data for real-time visualization on the hot path, and storing all the data in long-term storage for the cold path.

Diagram of the preferred solution. From a high-level, the commerce solution uses an API App to host the Payments web service with which the Vending Machine interacts to conduct purchase transactions. The Payment Web API invokes a 3rd party payment gateway as needed for authorizing and capturing credit card payments, and logs the purchase transaction to SQL DB. The data for these purchase transactions is stored using an In-Memory table with a Columnar Index, which will support the write-heavy workload while still allowing analytics to operate, such as queries coming from Power BI Desktop.

Lab2 : Create Azure Time Series Insights and Visualize Device Data

Duration: 60 minutes

Time Series Insights Lab

The Solution diagram is described in the text following this diagram.

Lab3 : Capture Device Events and Send Notifications

Duration: 40 minutes

Azure IoTHub with Event Grid Lab

The Solution diagram is described in the text following this diagram.

Lab4 : Save the Sensor Data using Serverless Archiecture and CosmosDB

Duration: 100 minutes

Azure Serverless Architecture

The Solution diagram is described in the text following this diagram.

Azure services and related products

  • Azure App Services
  • Azure Blob Storage
  • Azure Data Factory
  • Azure Databricks
  • Azure SQL Database
  • Azure Stream Analytics
  • IoT Hub
  • Azure Functions
  • Azure Logic App
  • Time Series Insights
  • Power BI Desktop
  • Visual Studio 2017

Azure solution

Internet of Things

Related references

MCW