IOT

Stream SmartThings data to Cosmos DB and PowerBI Part 3 – Reporting

Stream SmartThings data to Cosmos DB and PowerBI Part 3 – Reporting

So far we’ve sent our SmartThings data to event hub, collected this data using Stream Analytics and then stored it in Cosmos DB. In this part were finally going to use that data to create some reports in PowerBI that show SmartThings sensor data over time. We’re going to focus on the example I started with, showing temperature change over time. This will give you the information you need to go on and report on whatever data you want to.
Stream SmartThings data to Cosmos DB and PowerBI - Part 1

Stream SmartThings data to Cosmos DB and PowerBI - Part 1

I’ve recently added a whole load of home automation functionality using Samsung’s SmartThings platform. Part of this is a number of sensors to trigger automation based on motion, temperature, open/close etc. The SmarTthings platform is able to respond to events from these sensors to undertake tasks, and this works fine. What the platform doesn’t really do however is collect this data to give you historical information. For example, I wanted to collect temperature values from various sensors around the house over time to give me a sense of temperature fluctuations throughout the day and the effectiveness of my heating.