Methods for Automating Business Analysis by Integrating Heterogeneous Data

In the current business environment, there is no company that does not have to process and analyze data. Regardless of whether it is a structure in the private or public sector, with two or dozens of employees, the volume of information is growing, but with it the potential for business units to extract qualitative knowledge is also growing. The most common “solution†for storing and processing primary information even in 2025 remains Microsoft Excel. The availability of advanced artificial intelligence tools does not always solve the primary problem – how to integrate and present data so that it can be used in the future for in-depth analysis and trend tracking. This report should propose a methodology for automating information processing, which unites the processes of collecting, unifying and transforming heterogeneous data extracted from Excel sources. Good practices in primary data storage will be proposed, modern low-code/no-code solutions will be considered, and ideas for application in small and medium-sized enterprises with limited resources will be proposed.