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.
Analytics, Dashboards and Predictive Maintenance with Streamsheets
In a previous blog posts I demonstrated how to set up a Streamsheet that controls a industrial machinery. I you haven’t read this previous post you might consider reading it before continuing with this new post.
In this blog post I will extend the Streamsheet application to serve as an analytical dashboard for the industrial machinery introduced in the previous blog post. The following screenshot gives a quick graphical impression of the dashboard.
The dashboard continuously reads the current position of the pushers to find out if all 4 pushers are extending the full way or if they stop earlier. If they average value of the pusher extensions gets below the standard value of (in this case) 10, some maintenance is needed for this machinery.
The dashboard uses time charts to show the pusher signal and the actual position of the pusher in real-time. It also shows the history of the readings in a table view.
In the following 5 minute video I will show how to build the dashboard. I suggest that you view this video in full screen mode.
Video: Analyzing the accuracy of a industrial process with 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.