A process-oriented data warehouse to support decision making process in crop production

Abstract

The data available at the right time and in the right way and the economic calculations that can be produced from them, as well as the presentation of the produced information to managers, are crucial in the decision-making process for the organizations. Wide range of digital solutions has an important role to support the business activities and the decision making in the case of farm management as well. It is important to determine the structure of the data required to base the economic calculations, build a data model and create a multidimensional database, this lays the foundation for the calculation of economic and financial indicators, which can help in making economic decisions. In our article, we present the structure of a process-oriented data warehouse created according to the OLAP (online analytical processing) principle, which is suitable for displaying immediate results and creating analytical queries, as well as for displaying different combinations of variables for making economic decisions.