You'd rather watch the story as a video than reading it? Then check out this video!
Smart Warehouse as a Service – The story of a successful collaboration between SGS, Swisscom and Microsoft
According to the Food and Agriculture Organization (FAO) of the United Nations, cereals (including rice) contribute 55-70 percent of the total calories in the diets of developing countries, and corn and wheat alone make up close to two-thirds of the world’s food energy intake. However, around 14% of the world’s food is lost after harvesting and before reaching the retail level. One of the main reasons for this are poor storage condition due to poor temperature management and lack of control of relative humidity, thus leading to shriveling, wilting, and deterioration of perishable foods. Another reason lies in the mode of transportation.
SGS, as the world leader for inspection, testing, verification and certification aims to provide monitoring and operation grain stores worldwide as well as grain transport on cargo vessels.
Temperature and moisture are determining factors in accelerating or delaying the biochemical transformation that are the origin of degradation of grain in storage. They have a direct influence on the speed of development of insects and micro-organisms - molds, yeasts and bacteria - and on the premature or unseasonal grain germination. The temperature depends not only on climatic conditions, but also on the biochemical changes that are produced inside a grain mass, provoking undesirable natural heating of the stored products.
Moisture content of the stored grain depends on the Relative Air Humidity (RAH). During storage, moisture within the product reaches an equilibrium with the air within and between the product particles and produces a relative humidity level that may be suitable for the growth and development of deteriorative organisms.
If the affected area is not treated and immediately isolated, the grains will be affected. The longer it takes to act, the greater the degradation of quality and losses will be.
SGS developed independent services to help reduce these risks and operate grain warehouses in a more sustainable manner. Initially, an SGS employee would travel to a location, test the grain and fill out documentation. Due to limited resources, this only happened every other day in selected warehouses. It is not easy to consolidate these documentations in a central location, get insights in near real-time, and share that information with end customers.
In order solve this problem, several questions must be addressed, including:
- What needs to be measured and how?
- How are the collected data from the warehouses in remote locations transmitted to a central location? And how do you get insights from the collected data?
- What are the costs of the project to the benefits of monitoring a low margin product?
Successful partnership as key factor
The above shown figure is the new IoT solution SGS has developed based on Smart Sensing Devices together with Swisscom and Microsoft.
Based on this foundation, SGS will start Smart Warehouse as a service as a first project to detect fluctuations in temperature and moisture of the cargo inside the stock pile at different levels, and control the storage conditions by monitoring the relative humidity, temperature and carbon dioxide levels.
Microsoft Azure, a strong and trusted cloud platform, and Swisscom's reliable connectivity platform and End-to-end Azure cloud service were chosen to master these challenges. The project was first launched in Hungary in 2019.
Smart Warehouse as a Service - the success story
With the need of SGS, the innovation power of Microsoft Azure, and the expertise and connectivity capabilities of Swisscom, we translated the business case into connected and innovated hardware. Here's how:
The grain warehouses were equipped with different sensors to monitor both grain and air. The attached cable with multiple sensors along its way is inserted into the piles of grain. Running on a battery, the sensors measure humidity, temperature and CO2 values in the warehouse as well as moisture and temperature values of the grain on top, middle and bottom areas of the pile.
2. Every six hours, two historical and one current measurement are transmitted over Swisscom global LoRaWan. A low-power wide-area network which spans the warehouses in the area, is highly stable, inexpensive and uses very little electricity.
3. Considering that the warehouses are in areas with limited connectivity, the devices in the warehouses send their data first to a Swisscom Managed Lora Edge Gateway, which then sends the data to Microsoft Azure.
4. Azure IoT Hub represents the heart of an IoT solution in Azure. It is used for reliable and secure communication between devices and cloud. To integrate it in our lifecycle management and business process, Swisscom has developed a custom-made additional device provisioning service. Currently mobile integrations with on-site device provisioning in implementation and service will be available in Q4, 2020.
5. Azure Stream Analytics was used for real time message processing, data enrichment, and payload decoding, gaining insights from IoT streaming data and triggering actions.
Azure Data Lake was used for storage and future archiving and data analytics purposes.
Azure Analytics Services was used to serve the data in the models needed.
6. Swisscom's Public Cloud Managed Service team takes care of the smooth operation of the solution and sends alarms to the operators according to the defined criteria.
Additional Microsoft products that were used:
Azure SQL Database for storing project data like device repository, warehouse, customer and payload data;
Power BI is used for dashboards;
Azure Logic App and Azure Functions for automation;
Azure Event Hub for streaming data;
Log Analytics for monitoring and alerting
One year into the project, SGS was able to provide 24/7 real-time dashboard and data-driven monitoring and therefore real-time situation detection for customers. Predictive analytics and maintenance further enable customers to stop fermentation before it occurs, leading to increased quality and minimal loss of grain. In addition, travel time and manual documenting are being saved every day.
Thinking ahead - The future story
The solution is now seamlessly integrated with the SGS IoT cloud platform, offering state of the art Data Dashboards and Reports, all while being easily configurable to customer needs.
Smart Warehouse as a Service advanced analytic systems allows fast responses, helping to prevent contamination. In addition to limited food waste, it significantly reduces onsite inspection times and operating costs. The optimized outputs in combination with notable cost reductions of the solution gives SGS a strong competitive edge in the market: it allows for a fast time-to-market, more value to the customer and add-on sales opportunities like 24/7 monitoring, intelligent predictive and subscription-based inspection services, plus increased productivity.
SGS will extend applications of the solution from static warehouses to cargo ships transporting grain and other commodities. The solution will be expanded
1) for granular goods e.g. cement
2) with other sensors and different types of data processing for other industries and use cases such as Gas Leakage detection in the production process and Good Tracing in the supply chain and
3) in its remote monitoring
as a basis for IoT in general.
Furthermore, a big future opportunity lays in the cross divisional use of the collected grain data. For instance, a high interest in the data can be expected from insurance companies to draft policies. Constant solution development allows us also to investigate new emerging technologies around 5G usage and Azure edge technologies.
Create opportunities with Microsoft Azure – the Swisscom story
The Journey to the cloud with Swisscom accompanies customers from an initial idea to a working prototype all the way to a fully managed Azure cloud and helps the customers to make use of all the opportunities of Microsoft Azure. The Swisscom story brings together traditional telco services such as connectivity and device management with a deep know how of Microsoft Azure, including analytics and predictions.
The standardization achieved with the SGS case now allows us to apply the solution to 26 more cases identified – with many more to come, as our IoT journey continues.
At the moment Swisscom and SGS are working on another indoor and outdoor air quality monitoring project to serve their customers better with building management services.
Read more on the topic:
Author: Abduxukur Abdurixit, Cloud Solution Architect at Swisscom