Estimating Operations’ Efficiencies, through Business Intelligence, as an Input for the Assignation of Machines in Agricultural Processes

New Technologies and constant dynamism are key factors to be successful in a specific market. The ability to reinvent themselves in terms of processes and organization, analyzing what could be improved, requires to be a fundamental pillar of the company. Fortunately, 3a S.r.l is aware of this situation, and this is precisely what gave support to the current master thesis. Starting from an introduction of the environment in which 3a is immersed in, where the context is presented, until the process of designing an application for a better assignation of resources; this work follows a logical line that allows understanding step by step how the objectives were reached. First, an explanation of the framework is given, in a way such that it is possible to recognize the main core of the company, going through its products, its location, its productive process, and the way in which data is entered and handled into the platforms it offers to its clients. Next, the context of the problem is illustrated. In this case, it deals with efficiency estimation for the operations carried out within the Farms of the company’s client in Chile, estimating, throughout Business Intelligence, the ratio between quantity processed and duration. In doing so, a data model was created, extracting what was needed from a testing DB and submitting it to an ETL process. The results obtained have been statistically validated and measures regarding them have been discussed with people in charge. Finally, what was obtained previously regarding efficiencies has been used to create an algorithm (using Visual Basic), that allows a comparison between the current criteria of assignation of resources and a proposed one that follows a logic of a Greedy algorithm. This, with the objective of analyzing if the current one could be improved, subject to some assumptions, and also to evaluate what the behavior of the operations has been throughout the years.