Providing software support for economic analysis
DOI:
https://doi.org/10.15587/2706-5448.2023.289918Keywords:
software, , web application, financial analysis, automated system, databaseAbstract
Today, modern software and hardware of information technologies are used to automate production processes, starting from modeling of technical developments and automated computer systems. This study is aimed at describing the process of implementing software support for economic analysis of the enterprise, which will calculate the main economic indicators and informatively display the calculated data. The object of the study is an automated system for calculating and maintaining the main economic indicators of the enterprise. The subject of research is methods of database design and development, data visualization and web applications. A review of literature sources allowed to conclude that most often to assess the economic performance of the enterprise, standard technologies are used, which the authors adapt to specific economic problems. In addition, the analysis of modern research has not identified a single software product that would collect, accumulate, analyze information and calculate the main indicators of economic activity of the enterprise, as well as monitor changes in such indicators in the dynamics. Automation of calculation of economic indicators, statistical analysis and visualization of data gives the chance to carry out effective management of the enterprise in modern economic conditions. The developed system allows to analyze the use of fixed assets; working capital analysis; analysis of the use of labor resources; profitability analysis; analysis of financial stability of enterprises. The paper shows the process of developing a functional model of a web application for the automated calculation of key economic indicators, and presents the advantages and disadvantages of working with the PostgreSQL database management system. The structure of the developed database, which consists of four tables, is given. An example of the work of the developed web application is presented.
References
- Andrieieva, H. I. (2014). Formation system of economic indicators as the basis of analysis of business enterprise. Efektyvna ekonomika, 3. Available at: http://www.economy.nayka.com.ua/?op=1&z=2872
- Shurpenkova, R. K. (2014). Іnformation technology for economic analysis for enterprise. Sotsialno-ekonomichni problemy suchasnoho periodu Ukrainy. Problemy intehratsii Ukrainy u svitovyi finansovyi prostir, 1 (105). Available at: http://ird.gov.ua/sep/sep20141(105)/sep20141(105)_433_ShurpenkovaRK.pdf
- Skopen, M. M., Lobanova, V. A. (2011). Automation of enterprise’s financial results analysis and financial sustainability audit on the platform of databases management system «Access». Ekonomichnyi chasopys – XXI, 7-8. Available at: http://dspace.nbuv.gov.ua/bitstream/handle/123456789/47821/17-Skopen.pdf?sequence=1
- Handayani, T., Aprilia, R. T., Widaningsih, O., Kesuma, F. N., Jumansyah, R. (2021). Information Technology on Economic Growth and Stability. FIRM Journal of Management Studies, 6 (2), 153. doi: https://doi.org/10.33021/firm.v6i2.1560
- Li, C. (2013). The Contribution of Information Technology to Economic Growth. Applied Mechanics and Materials, 411-414, 2533–2536. doi: https://doi.org/10.4028/www.scientific.net/amm.411-414.2533
- Philip V, M. (2021). Analysis of the contribution of information technology in investments. International Journal of Advanced Research, 9 (2), 492–497. doi: https://doi.org/10.21474/ijar01/12474
- Hrabovskyi, Y., Kots, H., Szymczyk, K. (2022). Justification of the innovative strategy of information technology implementation for the implementation of multimedia publishing business projects. Proceedings on Engineering Sciences, 4 (4), 467–480. doi: https://doi.org/10.24874/pes04.04.008
- Mazaraki, A. A., Boiko, M. H., Bosovska, M. V., Kulyk, M. V. (2020). Multi-agent information service system of managing integration processes of enterprises. Naukovyi Visnyk Natsionalnoho Hirnychoho Universytetu, 3, 103–108. doi: https://doi.org/10.33271/nvngu/2020-3/103
- Hlibko, S., Vnukova, N., Davydenko, D., Podrez-Riapolova (2021). Usage of E-Technologies for Development Financial and Economic Potential of United Territorial Communities. IEEE 8th International Conference on Problems of Infocommunications, Science and Technology, PIC S and T 2021 – Proceedings, 93–97. doi: https://doi.org/10.1109/picst54195.2021.9772240
- UML-diahrama. Vydy diahram UML (2021). Available at: https://ukrpublic.com/aktualne/uml-diagrama-vidi-diagram-uml.html
- PostgreSQL: The World's Most Advanced Open Source Relational Database. Available at: https://www.postgresql.org
- Understanding Object-Relational Mapping: Pros, Cons, and Types. Available at: https://www.altexsoft.com/blog/object-relational-mapping/
- Voloshyn, O. Deep Dive Into Using Patterns With Selenium: ohliad 8 shabloniv, shcho stanut u pryhodi. Available at: https://www.globallogic.com/ua/insights/blogs/dive-into-the-selenium-patterns/
- Active Record Basics. Available at: https://guides.rubyonrails.org/active_record_basics.html
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Ольга Володимирівна Старкова, Дмитро Олександрович Бондаренко, Євген Миколайович Грабовський
This work is licensed under a Creative Commons Attribution 4.0 International License.
The consolidation and conditions for the transfer of copyright (identification of authorship) is carried out in the License Agreement. In particular, the authors reserve the right to the authorship of their manuscript and transfer the first publication of this work to the journal under the terms of the Creative Commons CC BY license. At the same time, they have the right to conclude on their own additional agreements concerning the non-exclusive distribution of the work in the form in which it was published by this journal, but provided that the link to the first publication of the article in this journal is preserved.
