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

Felföldi, János and Botos, Szilvia and Bálint, Péter Levente and Dénes, Sulyok and Sándor, Csenki and Takács, Viktor László (2023) A process-oriented data warehouse to support decision making process in crop production. AGRÁRINFORMATIKA / JOURNAL OF AGRICULTURAL INFORMATICS, 14 (1). pp. 33-43. ISSN 2061-862X

Preview

Text document3.pdf - Published Version Available under License Creative Commons Attribution. Download (682kB) | Preview

Abstract

In our article, we present the structure of a process-oriented data warehouse created according to the OLAP (online analytical processing) principlethat enables simple process controlling in crop production with 1 hectare process cost and time.To identify the sequence of operations and parallelism of the processes, we used interval ranking theory, which was implemented in the Power Query M formula language.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-makingprocess 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.

Actions (login required)

Edit Item