Implementación de un prototipo de sistema para la gestión de suministros médicos a través del uso de Dashboard y analítica de datos para el consultorio odontológico Leodent.

Abstract

This project consists in the development and implementation of a medical supply management system for the dental clinic “Leodent”, integrating new technologies to an-Excel template using the new integration through the Microsoft Insider beta channel, which allows pure Python programming in the Microsoft Excel environment. This project arises from the need presented by the clinic where they performed inventory operations manually, it means, there was a total lack of knowledge by the doctor of the inventory supply, which undermined the quality service provided from the clinic. In order to achieve the development of this project, different technological tools were investigated that could meet the needs of the clinic, for this we have opted for the implementation of a prototype divided in two, the first consisting of a system that allows having the information stored in the Python anywhere cloud that allows multiple tasks such as: the entry of products, history, entry to the warehouse according to the supplier, the manipulation of information and display of information in real time through dashboards with interactive graphics. The second one is the Excel template tool using pure Python programming that allows the doctor to perform hypothetical cases of analysis of the supplies through dashboards that include interactive and updatable graphs, through the different Python Dataframes with inventory information, to have greater control over operations, resource costs and the possibility of achieving significant savings.