The project was commissioned by the Russian branch of an international agriculture company, a global leader in plant protection systems and seed production.
Thousands of agronomists across Russia have been using the company's products for several years. During fieldwork, farmers use tablets to monitor and record soil conditions in their fields and to schedule inspections for each plot. Within the same application, they can view maps of precipitation and crop rotation, as well as potential risks to crops (such as drought or signs of parasites).
For easier analysis, all this data needs to be processed, compiled, and visualized in the most comprehensible and accessible manner.
ICL Services team was brought in specifically to tackle the task of compiling and visualizing diverse data from various perspectives.
Key Challenges
- Create a visualization of current and historical data to enable agronomists to independently analyze situations and plan work schedules for the fields.
- Merge diverse field data onto a single dashboard for a more comprehensive analysis
- Establish a role-based access model for the dashboards, allowing each user to view only the fields they have access to
Implemented our solution
The project started in June 2023.
Having agreed on the general task structure with the client, the ICL Services team initiated the construction of a data model for developing the dashboards. The team established a role-based access model to data and dashboards on the QlikSense platform. This was needed for both agronomists (e.g. to ensure that an employee only sees the fields they are responsible for when opening the app, not the entire list of plots) and management to monitor employee performance.
The data was compiled into a user-friendly dashboard format: e.g. there is now the function to monitor crop yields in various regions over a chosen period, with the option to compare figures from different years. Another slice of data implemented contained information about the materials used: seeds, fertilizers, and plant protection, as well as the resource of machinery utilized.
Furthermore, ICL Services prepared a forecast map matrix based on the analysis of historical data by setting the required initial parameters. As a result, the users can now identify which areas are most likely to be at risk in the near future (e.g. a combination of high humidity, fog, and lack of sunlight increases the risk factors for fungus).
In conclusion, the ICL Services team held a series of training sessions for the client's development engineers to further administer the dashboards. The project lased only 2 months.
Products and technologies
- Qlik Sense
- API
- Json, XML markup
Results
- Dashboards for field situation analysis were designed and implemented.
- User access rights differentiation was implemented.
- Statistics were gathered, based on which the forecast map was prepared.
- The client's professionals were trained.