Case Study

Central dashboard at control tower to track active ingredients used in farms

Client: Global provider of agricultural science and technology

Our Expertise: Business Intelligence

Technology Used: Tableau, C# to load API responses SQL server

PROBLEM STATEMENT

Understanding the biological activity of an active ingredient used in the farms is integral to determining its viability and efficacy. It is necessary to track the various combinations used as it has a directly proportional relationship between dosage concentration and beneficial effects. Our client, was looking for a technological solution on centralized tracking of Active ingredients used in farms, their combinations, timeline, and status.

SOLUTION

We developed a custom solution using C# to call the APIs to get the data related to re-entry restrictions, to comply with US Agricultural Laws and Regulations.
It was responsible to store the collected data into the central SQL database post data cleaning and other data transformations.
As the client was already using Tableau as a data visualization tool, we recommended using the same and developed the dashboard.
Active ingredients dashboard displayed which products were used with the percentages of Ingredients applied and the permissible limits.