Portal de Periódicos da CAPES

Data Mart in Business Intelligence with Hefesto for Sales Area in a Dental Clinic

2024; Springer International Publishing; Linguagem: Inglês

10.1007/978-3-031-54820-8_2

2367-3370

María Domínguez, Gian Terrones Castrejon, Juan J. Soria, M Manrique, Lidia Segura Peña,

Customer churn and segmentation

Large volumes of dental patient data are a problem if your data and business intelligence tools are not properly exploited. This paper provides a clear and concise overview of the tangible benefits of implementing the Data Mart at Pinaud Dental Clinic. The results showed an impressive increase in overall profits. The detailed breakdown of specific treatments and payments highlights the accuracy in data analysis. The use of tableau for reporting further underscores the clinic’s commitment to leveraging technology to improve the business. I recommend this paper for its examination of Data Mart’s impact on a dental practice’s operations. Future studies could delve deeper into the long-term benefits and potential scalability to larger clinical settings. Sales reports in June show us that clinic appointments increased by 69 and in July by 48 appointments, having obtained majority payments in crown treatment, exodontias, prophylaxis, prosthetics, and restoration where the favorable percentage of total payment per customer is 44% thus showing higher gains in dental services in May and June. The number of appointments per day increased by 21%, the total payment for specific treatments increased by 25%, with orthodontics being the most requested and, finally, there was a 7% increase in total profit. It is concluded that the implementation of the Data Mart with Hefesto achieved the following results.