Abstract
The transition to Industry 4.0 is accompanied by significant progress and change in many areas of society and the economy. Digitalization changes and improves business processes, simplifies and enriches people's lives. Innovation is taking place. New tools provide, among other things, the collection of large amounts of data. In this regard, the problem of big data analysis is urgent. Since this task is associated with a large amount of digital computing and relies heavily on advanced software and server tools, we were faced with the task of conducting such an in-depth analysis with available software tools with high efficiency. The constructed multi-level universal algorithm for obtaining, collecting, processing and visualizing data is implemented in Microsoft Excel using the Power Pivot add-on. The analysis carried out in the study is aimed at identifying and comparing regions in terms of the level of development of spheres of public life, including the level of digitalization in the context of industry 4.0.