Dashboards as a management support tool for a clinic provider of physical rehabilitation service

Abstract

This paper presents the application of dashboards in a provider clinic of physical rehabilitation service. The research aimed to show information in a contextualized, accurate and objective way can support the planning and strategic decision-making process of clinic's managers. Thus, a study of the organization's environment was carried out, identifying the needs of strategic indicators for the clinic management, defining four groups of information: attendance overview, detailed view of the care evolution, view of the operational capacity, and view of the level of occupation of the employees. These groups were used to create four dashboards with graphs and indicators. The data used were extracted from the clinic's appointment scheduling system database and were supplemented by local electronic spreadsheets. The Microsoft Power BI Desktop tool was used to build the dashboards. To validate the work, the results were presented for two physical rehabilitation clinics managers with the same organizational characteristics. The proposal stands out as results, validated through triangulation by area managers, of a group of dashboards for tactical and strategic support for rehabilitation clinics. Another result is associated with the working method used in terms of integration with sectors external to the business, such as the IT area. Future works are needed in order to extend the data used for medical records, financial aspects and suppliers' products.