Ferramenta de análise para estruturar equipe de ambulatório corporativo

Abstract

From engineering offices to large hospitals and wards, there is a need to meet work demands with the staff available, só it is essential to structure a team that is appropriate to the workload. This study will address the problem related to the challenge of assessing and quantifying the demand of a corporate outpatient team, as well as the obstacles in organizing the team to avoid both staff overload and idleness, especially due to the lack of essential information for this structuring. The overall objective was to develop a tool capable of concatenating the data from the activities carried out by the team and transforming it into clear and useful information, facilitating analysis for structuring the team. In addition, we considered the need for a platform integrated with a database updated in real time, displaying information through interactive dashboards that allow different scenarios to be simulated. To do this, the Power BI data analysis tool was used, in which daily records categorized by employee, execution time and frequency were entered. This data was processed and cleaned according to the CRISP-DM methodology in order to facilitate data interpretation, integration and calculations to assess team capacity. With regard to determining the workload, the analysis used the parameters of the “WISN – Workload Indicators of Staffing Need”, established by the World Health Organization (WHO), making it possible to assess the demand for activities and the necessary capacity, respecting an adequate and healthy workload. The result was an interactive tool that made it possible to visualize the demand for work, the team’s capacity, the percentage distribution of occupancy by function and the ideal number of professionals to meet the monthly demand. With this dashboard, it was possible to simulate various scenarios with different team compositions, making it clearer and easier to visualize service needs and the number of people required to meet them, making it easier to make decisions and structure the team, without neglecting work overload or losing quality in the service’s performance.