Published March 31, 2016 © GPL3+

Temperature and Humidity from Pi to Power BI

In this POC (proof of concept) we will collect humidity and temperature information and perform analytics using Power BI.

IntermediateShowcase (no instructions)2 hours5,131

Temperature and Humidity from Pi to Power BI

Things used in this project

Hardware components

Raspberry Pi 2 Model B

DHT11 Temperature & Humidity Sensor (4 pins)

Software apps and online services

Microsoft Azure

Story

In this POC (proof of concept) we will collect humidity and temperature information and perform analytics as well as archiving on the data post collection. It was the goal of the ProArch team to take numerous other projects and stitch them together to perform a full working POC for what a functioning IoT solution loos like from sensor collection all the way to archive with the data.

For the POC, the ProArch team decided to use the following components:

• Raspberry Pi 2 Model B (Default Raspbian Installation)

• Adafruit DHT11 Humidity and Temperature sensor

• Azure Service Bus

• Azure Stream Analytics

• Azure Table Storage

• Power BI

Code

Python send to Azure

#!/usr/bin/python

from azure.servicebus import ServiceBusService
import datetime
from datetime import datetime
import random
import sys
import Adafruit_DHT
import time


key_name ="RootManageSharedAccessKey"
key_value="-yourkeyhere-"
sbs = ServiceBusService("proarchiottest", shared_access_key_name=key_name, shared_access_key_value=key_value)
sbs.create_event_hub('proarchiot2')
print 'Press Ctrl-C to quit.'
while True:
	humidity, temperature = Adafruit_DHT.read_retry(11, 4)
	temp = {"Temperature":float(temperature * 9/5.0 + 32),'Humidity':float(humidity)}
	print(temp)
	sbs.send_event('proarchiot2', {'DeviceID':'UAV1','Temperature':float(temperature * 9/5.0 + 32),'Humidity':float(humidity)})
	time.sleep(5)