In this video post you see how you can build a Streamsheet that receives data from Shopify via Apache Kafka The resulting Streamsheet generates aggregations and charts to serve as a real-time dashboard for a Shopify online shop.
A Simulated Wind Power Plant
as MQTT Publisher
In the following 8 minute video you can see how to set up a Streamsheet that simulates a wind mill power plant and and publishes its data in real-time to a MQTT broker.
There is not input stream for this Streamsheet. Instead the Streamsheet uses the continuous calculation mode and random number functions to simulate varying wind speeds and gusts.
In the second half of the video it is shown how you can animate the wind mill by dynamically linking drawing objects with the output cells of the Streamsheet.
In a later post, I will show how you can use the MQTT stream of this Streamsheet as an input source for a digital twin and an energy dashboard , both implemented via Streamsheets.
Did you like this blog post? Share it now
More Articles Like This
In this video post you learn how you can build a cloud-based Streamsheet that serves as a gateway between Shopify webhooks (executed by a Shopify Online Store) and Apache Kafka (hosted on Confluent Cloud).
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.