MODEL OF DRUG CIRCULATION BASED ON THE DOMESTIC ANALYTICAL PLATFORM LOGINOM

Striving to improve the economic efficiency of pharmaceutical business in an unstable market situation and high competition requires the subjects of drug circulation to implement modern approaches to the organization of their activities. In these conditions, an important problem that the management has to solve in the process of circulation of medicines is the problem of quality of source information accompanying the business processes of pharmaceutical activities. The source information is not intended for the purposes of analysis, is presented, as a rule, rather raw material that requires preliminary processing by special methods, including their sampling, purification and transformation. The article discusses the advantages of practical application of the capabilities of Loginom analytical platform, which implements the above mentioned methods of pre-processing of raw material and allows solving the tasks of modeling the characteristics of drug circulation. Based on the concept of low-code architecture that provides visual design of complex data analysis scenarios, without involving IT-specialists and realize programming tasks by the business user. The object of the research was the current data obtained from the accounting system of material assets of a wholesale pharmaceutical organization. When organizing a request to the accounting system, based on the considerations of commercial confidentiality, it was decided to limit the 12-month time period and the assortment group, including only antibiotics. During the research, a data processing scenario was developed in the Loginom environment, representing the sequence of actions that need to be carried out to analyze the data. A processing script is a combination of data processing nodes configured by the developer to solve a specific problem. Each script node performs a separate operation on specific data. The drug circulation model scenario developed during the study, consisting of five nodes, includes two nodes with initial data “Receipt Data” and “Consumption Data”, as well as nodes “Data Combination”, “Sorting” and “Grouping”. The developed drug circulation model is an alternative to modeling based on the popular Excel spreadsheet processor, the capabilities of which are limited by the volume of processed data, low productivity on large volumes, the difficulty of automating the execution of sequences of actions, and the inconvenience of reusing processing scripts.