Research on the Use of OLAP Technologies in Management Tasks

  • Daria Yu. Yashchuk
  • Bella L. Golub
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 754)


The article is dedicated to research of application of OLAP technologies when management. Much attention in the article is paid to creation of the decision-making support system. Such system is set aside for increase of effectiveness of governing, owing to analysis of data collected for a few years. The author demonstrates structure of data warehouse, on which basis analysis of university’s processes is kept. The article is important because the study uses the latest information technologies like MS Excel, Power BI, Business Intelligence Development Studio. Their use will allow management getting a system that will enhance the position in competitive environment.


Decision support system Data warehouse Business Intelligence Information Technology OLAP Database Data mart Power BI 


  1. Alkhafaji, S., Sriram, B.: Conceptualization and integration of information systems in educational business activities. Int. J. Inf. Eng. Electron. Bus. (IJIEEB) 5(2), 28–33 (2013).
  2. Tank, D.M.: Enable better and timelier decision-making using real-time business intelligence system. Int. J. Inf. Eng. Electron. Bus. (IJIEEB) 7(1), 43–48 (2015).
  3. Yashchuk, D.Yu., Golub, B.L.: Sovremennye informacionnye tehnologii v upravlenii vysshimi uchebnymi zavedenijami (Modern information technologies in the management of higher educational institutions), Sbornik trudov mezhdisciplinarnaja nauchnaja konferencija “Mnogofaktornye podhody k formirovaniju komfortnoj sredy” (Proceedings of International Conference on “Multifactor approaches to the formation of a comfortable environment”), Netanya, Israel, 15 November 2017, pp. 36–40 (2017). (in Russian)Google Scholar
  4. Glazunova, O.G., Voloshyna, T.: Hybrid cloud-oriented educational environment for training future it specialists. In: ICTERI, Kyiv, Ukraine, 21–24 June 2016, pp. 157–167 (2016)Google Scholar
  5. Yasenova, I.S.: Matematychna model’ tekhnolohiyi formuvannya navchal’noho planu vidpovidno do kredytno-modul’noyi systemy orhanizatsiyi navchal’noho protsesu (Mathematical model of the technology of formation of the curriculum in accordance with the credit-module system of educational process organization), Avtomatizirovannye sistemy upravlenija i pribory avtomatiki 139, 68–73 (2007). (in Ukrainian)Google Scholar
  6. Golub, B.L., Yashchuk, D.Yu.: Zahal’ni zasady pobudovy systemy pidtrymky pryynyattya rishen’ dlya VNZ (General principles for building a decision support system for higher education institutions), Informatsiyni tekhnolohiyi v ekonomitsi tapryrodokorystuvanni 1(1), 29–36 (2017). (in Ukrainian)
  7. Rahman, A., Khan, M.N.A.: An assessment of data mining based CRM techniques for enhancing profitability. Int. J. Educ. Manage. Eng. (IJEME) 7(2), 30–40 (2017).
  8. Alguliyev, R.M., Nabibayova, G.C.: The method of measuring the integration degree of countries on the basis of international relations. Int. J. Intell. Syst. Appl. (IJISA) 7(11), 10–18 (2015).
  9. Golub, B.L., Trochymeko, V.: Porivnyal`ny`j analiz instrumental`ny`x zasobiv Microsoft dlya analizu dany`x (Comparative analysis of Microsoft tools for data analysis), Visnyk inzhenernoyi akademiyi Ukrayiny, vol. 1, pp. 61–65 (2017). (in Ukrainian)Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2019

Authors and Affiliations

  1. 1.National University of Life and Environmental Sciences of UkraineKyivUkraine

Personalised recommendations