CodexProj: Data generation module

The main articles are:

• Database Management System (DMS)
• Data Quality Management

2023: A system has been developed to translate data maintenance into electronic form and visualize it in BI tools

The Russian company CodexProj (Codexproj), which is represented mainly by graduates of MIPT, has developed the information system "Data Generation Module." The system provides the ability to maintain data in a structured form with storage in the database without any modifications for each new data maintenance task.

Prerequisites

In organizations, the level of introduction of information technologies is growing, there are many information systems on the market, but at the same time there continue to be processes for which data is not maintained in these systems, including Word, Excel, etc.

During the selective analysis of the processed data by various organizations, it was revealed that more than 20% of the data is conducted manually. Manual data is those that are not processed in the IT systems of the organization, unstructured and maintained separately in different files or in principle only on paper, and this type of data always causes a large number of problems in consolidation, processing and analytics.

In the framework of data generation and processing, when organizations perform their functions, activities can be divided into 3 categories.

1. Atypical activity, which is due to the unique functions of organizations, as a rule, in the public sector, among the subjects of natural monopolies, for example: registration of rights to real estate, accounting for pension rights of citizens, directly accrual and payment of pensions. These functions are carried out by one or a limited list of organizations, to ensure them, information systems with unique functionality are developed and mainly with the transfer of exclusive rights to the customer.
2. Typical activity, which is regulated and for its support the relevant information systems (1C and many others) operate, for example: accounting for the production of products, sale of goods, accounting tax and accounting, accrual, wages accrual and payment of insurance claims, etc.
3. Activities with similar tasks for many organizations, but not corresponding to strictly typical activities, in such areas as setting planned indicators for subordinate institutions and taking into account their implementation, collecting and processing various information, taking into account the tasks performed within the framework of the functions performed by organizations, etc.

Only a few of the many examples of similar tasks for organizations:

• an emergency has occurred in the region and at the federal level it is necessary to keep records and monitor how the constituent entities of the Russian Federation carry out the necessary measures to eliminate the consequences and provide assistance to the victims;
• in medical institutions, it is necessary to ensure that the doctor's prescriptions that he establishes for the treatment of patients are taken into account and their further impact (effect) on the patient based on comparisons with the consequences;
• in sports, keep records and generate data on the fact of the athlete's attendance at training, the volume of the training process, his participation in competitions and relevant sports achievements, including for determining correlation;
• in any areas and industries keep records of the use of real estate for effective management, including the ratio of the number of employees to the area of ​ ​ offices, the presence of unused area, etc.;
• Also, in any areas and industries, conduct the formation and accounting of the implementation of various action plans, the implementation of KPIs.

At the same time, in almost any organization, regardless of industry and size, the level of application of information technologies, it is necessary to form and maintain data not in information systems and without saving in the database within the framework of the above examples.

This happens for the following reasons:

• It is necessary to organize the maintenance of new data on the tasks that have arisen within a short period of time within a few days and it is not possible to provide them at the expense of already operated information systems that require their revision;
• Procurement procedures for new information systems also do not allow you to solve the problem in the necessary time, and the organization maintains data manually, including using Excel;
• in principle, the organization does not have funds for the purchase and/or refinement of information systems.
• What are the main ways organizations go in these conditions:
• do not keep data in electronic form in principle;
• use Excel, which does not solve the main problems below.

This affects the following within the organization:

• Data is not stored in the database in structured form, no change history exists
• there is no delimitation of user access to data;
• uncontrolled data maintenance;
• Errors when users enter data
• complexity of simultaneous operation of users;
• no ability to build analytics on dashboards and other visual solutions of BI tools;

Capabilities of the "Data Generation Module"

The information system "Data Generation Module" provides obtaining and processing of the necessary information in electronic form, maintaining information in a database and structured form, solves many tasks on unprocessed data in operated IT systems, including allows:

• bring the planned indicators to subordinate organizations, divisions, monitor their implementation, receive reports;

• promptly organize a request for collection and control of data entry, their processing (in the Module it is implemented "turnkey" within a period of no more than 3 days);

• model and predict indicators online and embed in dashboards;

• do not maintain data in Excel, Google Docs, Yandex.Documents, etc., due to the lack of ability or expediency to process in IT systems;

• separate access rights, log user actions when entering, downloading data, including simultaneously by many employees;

• eliminate errors when entering and loading data by employees, minimize the risks of providing inaccurate information;

The Module maximizes the format and logic control of input, creating directories and classifiers in the system and the ability to function tables through almost any algorithms and cross-links written in the system. This is a graphical interface for work, no-code setting up rules and checks and no need for modifications (which means the start time from the formation of the requirement up to 3 days)

It is also possible to notify users both about the timing of data entry/download and about the achievement of indicators of certain values ​ ​ for taking preventive measures in order to correct the situation and ultimately ensure the fulfillment of the required indicator (the notification channel can be configured by the user himself, including through telegram)

But also, the Module, forming data in a structured form, allows you to implement data mappings not only in tables, but also in visual components of BI tools, thereby making analytics possible and stable.

The module provides mapping in dashboards with online modeling by embedding the tabular forms themselves directly into the BI tool through the API. That is, users see how their change in one value affects another and the entire analytics on the dashboard, for example, how the change in cases affects the demand for drugs, for the commercial sector, how the admission of new workers will affect the increase in costs (not only the wage fund, but also other costs).

At the same time, the Codexprodge team can not only embed analytics in Dashboards (what-if analysis), but also has great expertise in the development of individual visual solutions (adapted to the subject of analytics), for example, a comparative display of the shares and dynamics of human organs and oncology on the structure of the human structure, including organ analytics that are susceptible to cancer or protein content in human organs. You can get acquainted with the services in more detail at the# second_section link.

Thus, the "Data Generation Module" solves almost all tasks of data maintenance in a structured form and the organization, after a single implementation of the Module, will be able to ensure the launch of accounting, data formation and analytics in a short time and without the need for additional financial costs. Organizations for many data management start-up processes do not need to modify each individual IT system, or purchase IT systems, but make settings in the Module.

To access the demo version.

For answers to questions you may contact:

• https://codexproj.ru/get.html;
• https://t.me/codexproj;
• inbox@codexproj.ru.