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 […]

OBJECTIVE: To present the epidemiological profile of cancer patients belonging to a database of a Hospital Cancer Registry and to report on the importance of this database in managing healthcare services at an Oncology and Hematology Center. METHODS: A retrospective survey conducted with 1617 records of patients diagnosed with cancer at the institution between 2004 and 2009. The types of cancer analyzed were of the colon and rectum, breast, prostate and lung. The variables used in the study were age, […]