Subject. The article deals with underpinning the possibility of using modern BI-analytics systems to create fundamentally new tools enabling to find optimal ways of demographic and socio-economic development of municipalities in Russia, considering their regional specifics. Objectives.The purpose is to devise a multi-level BI-analytics system for assessing the demographic and socio-economic development of regions and municipalities in Russia (using the case of the Republic of Karelia). Methods. I formed a database of socio-economic indicators of Russian regions and municipalities of the Republic of Karelia for 2022, which included three interrelated blocks: demographic processes, economic development, quality of life, and the environment. Information processing was implemented using the BI analytics system of Power BI and the high-level Python programming language, including the use of specialized libraries for data analysis and visualization. Results. I developed a multi-level BI-analytics system that helps evaluate the main demographic and socio-economic indicators of regions and municipalities in the Russian Federation (on the Republic of Karelia case). Conclusions. The interconnection of all social processes necessitates the introduction of new methods of managerial decision-making based on big data and modern software tools. The designed BI-analytics system can be used to evaluate and predict various indicators of demographic and socio-economic development of territories, and elaborate regional program and strategic documents.
Keywords: region, demography, socio-economic development, data analysis, BI-analytics
References:
Kurakova T.V. [Microsoft power BI potential for personnel management]. Ekonomika i predprinimatel'stvo = Journal of Economy and Entrepreneurship, 2021, no. 7, pp. 1116–1121. (In Russ.)
Veriga M.D., Mastilin A.E. [Introduction of Power BI technologies on the example of a retail trade enterprise]. Ekonomika i Sotsium, 2018, no. 5. (In Russ.) URL: Link
Silakova L.V., Magerramov P.A., Semkina M.A. [Automation of integrated business analysis for SME organizations based on MS Power BI]. Nauchnyi zhurnal NIU ITMO. Seriya: Ekonomika i ekologicheskii menedzhment, 2019, no. 3. (In Russ.) URL: Link
Bovykina N.A., Khaidarov A.G. [Development of an automated model for analyzing the socio-psychological climate of the labor collective using MS Power BI]. Ekonomicheskii vektor = Economic Vector, 2022, no. 1, pp. 115–119.
URL: Link (In Russ.)
Tsar'kova N.I., Tarasov A.N. [Research on the demand for reference legal systems in Russia using Power BI]. Informatsionno-tekhnologicheskii vestnik = Information Technology Vestnik, 2021, no. 1, pp. 135–142. URL: Link (In Russ.)
Aksenov M.S., Soldatov R.E. [Brief information about Power BI: Data loading, data visualization]. Pedagogicheskoe obrazovanie na Altae, 2017, no. 2. (In Russ.) URL: Link
Moskalev A.V., Burlakov V.V., Dzyurdzya O.A. [Improving analytical activities in the sphere of public administration based on the introduction of the power BI information system]. Upravlencheskii uchet = Management Accounting, 2023, no. 6, pp. 157–163. URL: Link (In Russ.)
Molchanova E.V. [Medical and demographic particularities of municipalities in the Republic of Karelia]. Regional'naya ekonomika: teoriya i praktika = Regional Economics: Theory and Practice, 2020, vol. 18, iss. 5, pp. 966–991. (In Russ.) URL: Link
Burkin M.M., Molchanova E.V., Kruchek M.M. [Integral Criterion of the Influence of Social, Economic and Environmental Factors on the Regional Demographic Processes]. Ekologiya cheloveka = Human Ecology, 2016, no. 6, pp. 39–46. URL: Link (In Russ.)
Shkiperova G.T., Molchanova E.V. [Features of relationship economic development and medical and demographic indicators in Russia and Western Europe]. Vestnik Altaiskoi akademii ekonomiki i prava = Bulletin of the Altai Academy of Economics and Law, 2020, no. 10-2, pp. 206–213. URL: Link (In Russ.)
Pylov P.A., Protod'yakonov A.V. [Features of the Power BI environment in solving the applied problem of Data Science]. Innovatsii. Nauka. Obrazovanie, 2021, no. 30. (In Russ.) URL: Link
Aivazyan S.A. Analiz kachestva i obraza zhizni naseleniya (ekonometricheskii podkhod) [Analysis of the quality and lifestyle of the population (econometric approach)]. Moscow, Nauka Publ., 2012, 432 p.
Kruchek M.M., Molchanova E.V. [Research of medico-demographic processes in regions of Russia by the method of regression analysis according to panel data]. Regional'naya ekonomika: teoriya i praktika = Regional Economics: Theory and Practice, 2013, no. 18, pp. 41–53. URL: Link (In Russ.)
Rimashevskaya N.M., Bochkareva V.K., Molchanova E.V. et al. [Human potential of Russian regions]. Narodonaselenie = Population, 2013, no. 3, pp. 82–141. URL: Link (In Russ.)
Rybakovskii L.L. [Dynamics of the Russian population and its components in 2001–2025]. Sotsiologicheskie issledovaniya = Sociological Studies, 2011, no. 12, pp. 43–49. (In Russ.)
Shabunova A.A., Rostovskaya T.K. [Demographic Policy in Modern Russia: Population’s View and Expert Assessment]. Vestnik Rossiiskoi akademii nauk = Herald of Russian Academy of Sciences, 2022, vol. 92, no. 12, pp. 1145–1156. URL: Link (In Russ.)
Ivanova A.E. [Approaches to assessing reserves to reduce mortality in Russia]. Uroven' zhizni naseleniya regionov Rossii = Living Standards of the Population in the Regions of Russia, 2022, vol. 18, no. 2, pp. 177–188. URL: Link (In Russ.)
