The Use of Business Intelligence Tools for Health Data Analytics

Authors

  • Phatpicha Yochum College of Information and Communication Technology, Rangsit University, Pathumthani 12000, THAILAND
  • Chutima Beokhaimook College of Information and Communication Technology, Rangsit University, Pathumthani 12000, THAILAND

Keywords:

Business Intelligence, Intelligence System, Data Analytics, Data warehouse, Healthcare Analytics

Abstract

This research develops business intelligence (BI) for university health data analytics. The data warehouse has been constructed to store the four-year annual health checkup data of students and staffs. The reports are appro- priately designed to present the relationships among data and forecast or predict the risks of disease. The results of the analytics from OHW-RSU BI system show that 95% of students have good health. However, the health problem is still found mostly in myopia. For staff health analytics, 90% of staffs have good health. Unfortunately, unhealthy staffs are in class 2 and 3 obesity.

References

MarketingOops, https://www.marketingoops.com

BzInsight, https://bzinsight.wordpress.com

The Geek CEO, http://thegeekceo.com

CompareCamp, http://comparecamp.com

Gubalová, J.: The use of Business Intelligence Tools for leadership and university administration. In: 13th Interna- tional Conference on Emerging eLearning Technologies and Applications, Slovakia (2015)

Valdiviezo-Díaz, P., Cordero, J., Reátegui, R.: A Business Intelligence Model for Online Tutoring Process. In: IEEE Frontiers in Education Conference, USA (2015)

Mungsang, C.: Epidemiological Alert System by Using Business Intelligence and Epidemic Forecast by Using Data Mining. Thai National Research (2015)

Ruengjutipopan, T.: Business intelligence system for analyzing revenue budget, Faculty of Medicine, Chiang Mai University. CMU Intellectual Repository (2012)

Saikaewtat, V.: Development of business intelligence system for voluntary automobile insurance, the union prospers insurance Co.,Ltd, CMU Intellectual Repository (2012)

Jitrapakdee, P.: Business Intelligence for Sugar Cane Production Management. Thai Library Integrated System (2010)

Boonthai, P.: Sales Analysis of Siam Global House Public Co.,Ltd. Wiangkumkam Branch by Using Business Intelligence Principles. CMU Intellectual Repository (2009)

Pentaho Data Integration (Kettle), http://www.pentaho.com 13. Jaspersoft ETL, https://www.jaspersoft.com

CloverETL, http://www.cloveretl.com

Power-Center, https://www.informatica.com

Talend Open Studio, https://www.talend.com

Kaul, C., Kaul, A.: Comparitive Study on Healthcare Predic- tion systems using Big Data. In: IEEE Sponsored 2nd International Conference on Innovations in Information Embedded and Communication Systems, India (2015)

Kaewchompoo, T.: Data Warehouse System for Analysis of Diagnosis and Illness Primary Healthcare Units. KU Library Catalog (2010)

Apache Software Foundation, https://www.apache.org

Chennamsetty, H., Chalasani, S., Riley, D.: Predictive Analytics on Electronic Health Records (EHRs) using Hadoop and Hive. In: IEEE International Conference on Electrical, Computer and Communication Technologies, India (2015)

Surak, S.: Data Warehouse System for Student of Chiangmai University. CMU Intellectual Repository (2015)

Tathong, W.: Development of Schools Data Warehouse in Lampang Primary Educational Service Area Office 3. Thai Library Integrated System (2013)

Jatindan, N.: The Development of Executive Information System Using Technical Data Warehouse: A Case Study of Thai Traffic Police Official. Thai Library Integrated System (2012)

Suwanpinta, P.: Data Warehousing for Analysis of Rework Problems in Wheel Alignment Process. CU Digital Library (2012)

AVOSYS Technology, http://www.avosys.com

Data Made Good, https://www.datamadegood.com

NTT Data Americas, http://americas.nttdata.com

Donald Ham, http://www.infrics.com

Gartner, http://www.gartner.com

Tableau, https://www.tableau.com

Qlik, http://www.qlik.com

Microsoft, https://www.microsoft.com

G2CROWND, https://www.g2crowd.com

Downloads

Published

2024-02-12

How to Cite

1.
Yochum P, Beokhaimook C. The Use of Business Intelligence Tools for Health Data Analytics. j.intell.inform. [Internet]. 2024 Feb. 12 [cited 2024 Dec. 23];3(April). Available from: https://ph05.tci-thaijo.org/index.php/JIIST/article/view/114