Abstract
Various types of health data are routinely collected and published as national health profiles. However, these vast amounts of data are not always used effectively since they are presented in raw tabular data sets, fragmented, and are not well-equipped with the statistical data inferences and the trend of changes which are essential to explore some unknown previous information. In this paper, we propose how to manage the national open health data sets as a dashboard application to support the decision making for maternal and child health-care services in Indonesia. The research was conducted in four steps. First, we described what maternal and child health parameters are involved in relation to the availability of open and accessible data set. Second, we designed the dashboard application based on Kimball’s four step dimensional modelling. Third, we implemented the schema modelling as data warehouse by executing ETL (extract, transform and load) and OLAP (On Line Analytical Processing) cubes. Fourth, we analyzed the results with the business intelligence approach. We explored the open data sets in four consecutive years (2014-2017) and determined seven types of business process, i.e. analysis of health profile on neonates, infants, and children, analysis of maternal health profile before, during and after pregnancy period, and analysis of health supporting factors. By applying data warehouse and business intelligence, our proposed system has the ability to integrate and extract a number of tabular and fragmented data sets into an easy and quickly inferred information about the current situation of maternal and children health care services.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
More From: IOP Conference Series: Materials Science and Engineering
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.