1 results
11/Jul/2025
DOI: 10.31744/einstein_journal/2025AO1070
Highlights ■ The extract, transform, and load algorithm automates data extraction and updates in the PostgreSQL database. ■ The interactive dashboard enables detailed queries on establishments and professionals. ■ Results highlight medical doctor deficit in 22 cities and a shortage of community agents. ■ The tool can scale and assist managers in resource allocation for healthcare. ABSTRACT Objective: To develop a process (pipeline) for extracting, processing, and analyzing data from the National Registry of Health Establishments in the State of […]
Keywords: Apache Spark; Big data; CNES; Dashboard systems; Database; Geographic locations; Health facilities; Health personnel; Health Services Accessibility; PostgreSQL; Power BI; Public health