{'fraction_non_alphanumeric': 0.012903225806451613, 'fraction_numerical': 0.0, 'mean_word_length': 5.44213649851632, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 1, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Modeling of the Information System for Processing of a Large Distilled Data for the Investigation of Competitiveness of Enterprises

The technology of data analysis is offered for finding competitiveness of the enterprises. To determine the competitiveness of enterprises, a methodology based on the theory of effective competition is used. This method is proposed by economists Joseph Schumpeter and Friedrich Hayek and is one of the most widely used methods. According to this theory, the most competitive enterprises are those, where there is the best organized work of all units and services as a system. An example of using the Microsoft Excel Power Pivot technology to download large volumes of data, their processing and analysis of unstructured information and its organization into an ordered database is given. Examples of methods for working with non-structured data arrays are given. Scientific directions for the analysis of cumbersome data are determined. The principles of work of unstructured data in distributed information systems are formulated. The work of the Microsoft Office Excel spreadsheet process is presented to achieve goals. Its properties and highlights of advantages and disadvantages of finding and comparing the competitiveness of enterprises were analyzed. An analysis of the ease of connection to the database, the data transferfrom the model, the formation of tables, conducting complex data calculations, updating information in tables, grouping data and outputting totals is made. The experiments conducted have proven the feasibility of using the Microsoft Office Excel spreadsheet to process large volumes of data presented in text files, modeling and grouping data with poor quality information representation. This work analyzes the data structure in order to determine the state of the enterprises in the Ukrainian export market and develop algorithms for the research of competitiveness. Further research may consist in the widespread use of information systems that would provide an easy-to-understand and effective set of technologies to determine the company's competitiveness and make recommendations for its improvement.