Building an IoT Sensor Dashboard

The ultimate goal is to launch a large number of companies of Industry 4.0 capable of adapting to the needs of the business and production processes in a way more effective way, thus making a more efficient management of resources.

The key concept of Internet of Things has been introduced by Ashton, 2009 and one important challenge is to provide Solution in order to manage sensor telemetry by real time platform. The conventional business intelligence solutions not allow to manage this kind of devices and the setup of this system is usually complex.

This key concept is crucial for implementing smart cities capabilities on Industry 4.0 (Zanella, 2014) and therefore is important to develop newest solutions for managing telemetry data from sensor devices (Jeschke, 2016). The real-time visualization data, it own transformation and it use of intelligence artificial algorithms can improve and optimize the industrial process.

This white paper describes how to send sensor telemetry connected to Arduino UNO R3. This sensors collect the distance from the nearest pot to the sensor. The data is processed by PaaS architecture from Azure catalog Event Hub, Stream Analytics and Power BI.

Architecture

myCloudDoor is specialist in deploy of managing real time data form different sources by using PaaS resources and server less architecture (figure 1)

Figure 1. Architecture Lambda Azure for managing IoT telemetry

The ultimate goal is to launch a large number of companies of Industry 4.0 capable of adapting to the needs of the business and production processes in a way more effective way, thus making a more efficient management of resources

How to send sensor date

The first step is to setup the sensor by connecting Arduino motherboard

After, we get data from COM 3 port (this method also works in Linux system). We have to user the keys provided by Event hub resources. (figure 2)

Figure 2. Azure Event Hub

After that we can check if event hub is working into overview tab. Additional functionality form event hub allows to collect telemetry into an Azure Blob Storage

At this point we setup the stream Analytics services. We define Event Hub as input and power Bi as output. We creates the next query into 2 seconds screen and aggregate getting the average value in order to reduce the value fluctuation.

SELECT
AVG(CAST(DISTANCE AS BIGINT)) as [Distance],
System.TimeStamp AS Time
INTO OutputPBI
FROM
[InputEH]
GROUP BY
TumblingWindow(second, 2)

For setting up the Power Bi dashboard we carried out the following steps: