Build a functional condition monitoring dashboard with Streamsheets in 30 minutes.
Condition Monitoring with Streamsheets and MongoDB
This blog post introduces the basic operation of Streamsheets. Using the example of a smart WiFi switch with an integrated power consumption meter (Shelly 2.5), we set up a complete Streamsheet use case within 10 minutes.
Streamsheets is a great tool to visualize and analyze real-time data that comes from event streaming platforms like MQTT or Kafka. In a previous post we showed how you can create real-time dashboards to display the current data of now (or just a few seconds or minutes ago).
But how do you persistently store your data or your analysis results for a longer time using Streamsheets? In the following video, I demonstrate how you can feed a database like MongoDB with data from Streamsheets, just using one easy-to-use function called MONGO.STORE().
Once the data is sent to MongoDB, it is not only permanently saved, it can of course also be queried in any way using Streamsheets (which we will show in a future post) or any other query tool that supports MongoDB.
The following video is also the first video of a new and more professional presentation format that I call “Streamsheet TV”. I suggest that you view this video in full-screen mode.
Did you like this blog post? Share it now
More Articles Like This
Get an indepth overview of Mosquitto 2.0 in this webinar by the lead developer, Roger Light.
Streamsheets and Apache Kafka – Interactively build real-time Dashboards and Streaming Apps just using your Spreadsheet Skills
Curious about what you can do with Streamsheets and Apache Kafka? Find out in this joint webinar by Cedalo and Confluent.