Study of Energy Performance in Malaysian Public Hospital using Power Query
Abstract
In 2016, the Ministry of Health (MOH), Malaysia, initiated a sustainable program that includes activities for sustainable energy management at all 145 buildings under the MOH. The focus of the sustainable energy management program is to target these buildings to reduce their annual energy consumption by 10% by 2018. The target implementation of a sustainable energy management program includes achieving 3-star EMGS certification within 5 years. By December 2022, 135 have achieved two-star certification with the requirement to achieve at least 5% energy consumption savings. By 2019, the 118 buildings that embarked on EMGS certification had achieved 22.62% energy consumption savings. District and specialist hospitals achieved 23%–24% savings in 2019. The largest energy consumption in MOH buildings is for room cooling, which is contributed by air conditioning and mechanical ventilation (ACMV) equipment. The implementation of a sustainable energy management program has contributed to energy cost savings of RM21 million per year to MOH energy bills in 2019.
Downloads
References
Chung, W. (2011). Review of building energy-use performance benchmarking methodologies. Chung, 2011.
Chua, S. C. & Oh, T .H. (2012). Solar energy outlook in Malaysia. Renewable and Sustainable Energy Reviews, 16 564-574.
Diouf, P. S. & BolyA, Ndiaye S. (2018). Variety of data in the ETL processes in the cloud: State of the art. 2018 IEEE International Conference on Innovative Research and Development, ICIRD 2018, February 2019, 1–5. https://doi.org/10.1109/ICIRD.2018.8376308
Dwaikat, L. N. & Ali, K. N. (2016). Measuring the actual energy cost performance of green buildings: A test of the earned value management approach. Energies, 9(3). https://doi.org/10.3390/en9030188
El-Sappagh, S. H. A., Hendawi, A. M. A. & el Bastawissy, A. H. (2011). Proposed model for data warehouse ETL processes. Journal of King Saud University - Computer and Information Sciences, 23(2), 91–104. https://doi.org/10.1016/j.jksuci.2011.05.005
Enerdata. (2020). Year book 2020 Enerdata. https://yearbook.enerdata.net/electricity/electricity-domestic-consumption-data.html
Erik Kajáti, M. M. P. P. (2017). Advanced Analysis of Manufacturing Data in Excel and its Add-Ins.
European Union (2016). The Paris Agreement 2015. October 2016.
Fulton, L., Mejia, A., Arioli, M., Dematera, K. & Lah, O. (2017). Climate Change Mitigation Pathways for Southeast Asia: CO2 Emissions Reduction Policies for the Energy and Transport Sectors. Sustainability, 9(7), 1160. https://doi.org/10.3390/su9071160
Gangolells, M., Casals, M., Forcada, N., Macarulla, M. & Giretti, A. (2016). Energy performance assessment of an intelligent energy management system. Renewable and Sustainable Energy Reviews, 55, 662–667. https://doi.org/10.1016/j.rser.2015.11.006
González, A. G., García-sanz-calcedo, J. & Salgado, D. R. (2018). Quantitative analysis of functional energy consumption in hospitals in Spain. Sustainable Cities and Society, 36(September 2017), 169–175. https://doi.org/10.1016/j.scs.2017.10.029
Gowthami, K. & Kumar, M. R. P. (2017). Business Intelligence Tools for Enterprise Dashboard Development. International Research Journal of Engineering and Technology (IRJET), 4(4), 2987–2992. https://www.irjet.net/archives/V4/i4/IRJET-V4I4721.pdf
Leonard, U., Chikumba, P., Leonard, U., Malemia, M. T. & Chikumba, P. (2021). Digital Commons @ Kennesaw State University Assessing Excel Skills towards Implementation of BI Solutions in Corporate Institutions?: The Case of Accountants in Malawi Assessing Excel Skills towards Implementation of BI Solutions in Corporate Institutions?: 0–10.
Malaysia Energy Commission (2018). Malaysia Energy Statistic. Malaysia Energy Commission. Malaysia Energy Statistic Handbook; 2018. https://doi.org/10.1016/j.jpcs.2012.08.005
Malaysia International Trade Investment. (2018). MITI R e p o r t 2018.
MGTC, M. G. T. C. (2019). October 9, 2019, | environment.
Ministry of International Trade and Industry. (2017). Malaysia and the United Nations Framework Convention on Climate Change (UNFCCC)-The Paris Agreement. 3. http://www.wri.org/sites/default/files/uploads/absolute_emissions.png%0Ahttp://www.miti.gov.my/miti/resources/Article_on_Malaysia_UNFCCC-_Paris_Agreement.pdf?mid=572
Moghimi, S., Mat, S., Lim, C. H., Zaharim, A. & Sopian, K. (2011). Building Energy Index (BEI) in Large Scale Hospital?: Case Study of Malaysia, 167–170.
Ong, H. C., Mahlia, T. M. I. & Masjuki, H. H. (2011). Review of the energy scenario and sustainable energy in Malaysia. Renewable and Sustainable Energy Reviews, 15(1), 639–647. https://doi.org/10.1016/j.rser.2010.09.043
Rina, S. & Zakaria, R. (2014). Green Assessment Criteria for Public Hospital Building Development in Malaysia. Procedia Environmental Sciences, 20, 106–115. https://doi.org/10.1016/j.proenv.2014.03.015
Rodzi, N. A. H. M., Othman, M. S. & Yusuf, L. M. (2016). Significance of data integration and ETL in the business intelligence framework for higher education. Proceedings - 2015 International Conference on Science in Information Technology: Big Data Spectrum for Future Information Economy, ICSI Tech 2015, 181–186. https://doi.org/10.1109/ICSITech.2015.7407800
Saidur, R., Hasanuzzaman, M., Yogeswaran, S., Mohammed, H. A. & Hossain, M. S. (2010). An end-use energy analysis in a Malaysian public hospital. Energy, 35(12), 4780–4785. https://doi.org/10.1016/j.energy.2010.09.012
Schaeffer, R., Szklo, A. S., Pereira de Lucena, A. F., Moreira Cesar Borba, B. S., Pupo Nogueira, L. P., Fleming, F. P., Troccoli, A., Harrison, M. & Boulahya, M. S. (2012). Energy sector vulnerability to climate change: A review. Energy, 38(1), 1–12. https://doi.org/https://doi.org/10.1016/j.energy.2011.11.056
Shaikh, M.S., Waghmare, B, S., Labade, S. & Tekale, A. (2017). A Review Paper on Electricity Generation from Solar Energy. International Journal for Research in Applied Science and Engineering Technology, 1884-1889.
Shepley, M. M., Baum, M., Ginsberg, R. & Rostenberg, B. (2009). Eco-Effective design and evidence-based design: Perceived Synergy and Conflict. HERD, 2, 56–70.
Simitsis, A., Vassiliadis, P. & Sellis, T. (2005). Optimizing ETL processes in data warehouses. 21st International Conference on Data Engineering (ICDE’05), 564–575.
Valdez, A., Cortes, G., Castaneda, S., Vazquez, L., Medina, J. & Haces, G. (2017). Development and Implementation of a Balanced Scorecard for a Higher Education Institution using Business Intelligence Tools. International Journal of Advanced Computer Science and Applications, 8(10), 164–170. https://doi.org/10.14569/ijacsa.2017.081022
Wang, T., Li, X., Liao, P. C. & Fang, D. (2016). Building energy efficiency for public hospitals and healthcare facilities in China: Barriers and drivers. Energy, 103, 588–597. https://doi.org/10.1016/j.energy.2016.03.039
Wu, T. (2010). ETL function realization of data warehouse system based on SSIS platform. 2010 2nd International Workshop on Database Technology and Applications, DBTA2010 - Proceedings, 1–4. https://doi.org/10.1109/DBTA.2010.5659098.
Copyright (c) 2023 Hasbullah Harun
This work is licensed under a Creative Commons Attribution 4.0 International License.
Author (s) should affirm that the material has not been published previously. It has not been submitted and it is not under consideration by any other journal. At the same time author (s) need to execute a publication permission agreement to assume the responsibility of the submitted content and any omissions and errors therein. After submission of revised paper in the light of suggestions of the reviewers, the editorial team edits and formats manuscripts to bring uniformity and standardization in published material.
This work will be licensed under Creative Commons Attribution 4.0 International (CC BY 4.0) and under condition of the license, users are free to read, copy, remix, transform, redistribute, download, print, search or link to the full texts of articles and even build upon their work as long as they credit the author for the original work. Moreover, as per journal policy author (s) hold and retain copyrights without any restrictions.
