A DATA-DRIVEN APPROACH TO SUPPLIER SELECTION IN INDUSTRIAL CONSTRUCTION PROJECTS

ALI  AHMAD; FAYEZ  JRAD; SAMAH  MAKIA

doi:10.26682/csjuod.2023.26.2.20

ALI AHMAD Dept. of Engineering and Construction Management, Faculty of Civil Engineering, Tishreen
FAYEZ JRAD Dept. of Engineering and Construction Management, Faculty of Civil Engineering, Tishreen
SAMAH MAKIA Dept. of Engineering and Construction Management, Faculty of Civil Engineering, Tishreen

DOI: https://doi.org/10.26682/csjuod.2023.26.2.20

Keywords: Business Intelligence; Construction companies; Data warehouse; Industrial construction; Online Analytical Processing; Project management; Supplier selection

Abstract

The process of selecting suppliers is a formidable challenge in managing industrial construction projects. Construction companies generate a huge amount of data that is spread across multiple databases, but this data is not used to support decisions for future projects. To address this issue, a data warehouse was developed specifically for construction companies which are specializing in industrial projects. The proposed data warehouse utilizes operational databases from past projects, including planning and execution details, to organize and analyze data for supplier selection decisions in ongoing and future projects. The warehouse's dimensional model was built to meet the requirements of construction enterprises and the available data. The methodology employs Online Analytical Processing (OLAP), which enables direct queries and generates relevant reports to support construction management decisions and evaluate suppliers for different types of work. By adopting this approach, construction companies can make more informed decisions about which suppliers to choose for their projects, ultimately improving their economic performance. By leveraging the data available to them, these companies can enhance the quality of their decisions and improve outcomes for their industrial construction projects.

Downloads

Download data is not yet available.

References

Beale, M. H., Hagan, M. T., & Demuth, H. B. (2010). Neural network toolbox 7 user’s guide (Version 7). MathWorks Inc.
Botha, L. J. (2018). Data mining construction project information to aid project management (Master’s thesis). Stellenbosch University. https://scholar.sun.ac.za/handle/10019.1/103922
Chau, K. C. Y., Anson, M., & Zhang, J. (2003). Application of data warehouse and decision support system in construction management. Automation in Construction, 12(2), 213-224. https://doi.org/10.1016/S0926-5805(02)00057-9
Dalalah, D., Hayajneh, M., & Batieha, F. (2011). A fuzzy multi-criteria decision making model for supplier selection. Expert Systems with Applications, 38(7), 8384-8391. https://doi.org/10.1016/j.eswa.2010.12.102
Deng, X., Hu, Y., Deng, Y., & Mahadevan, S. (2014). Supplier selection using AHP methodology extended by D numbers. Expert Systems with Applications, 41(1), 156-167. https://doi.org/10.1016/j.eswa.2013.07.018
Desai, V. S. (2010). Application of decision tree technique to analyze construction project data. In A. Abraham, A.-E. Hassanien, & V. Snášel (Eds.), Computational social network analysis: Trends, tools and research advances (pp. 304-313). Springer. https://doi.org/10.1007/978-1-84882-229-0_14
Ghodsypour, S. H., & O’Brien, C. (1998). A decision system for supplier selection using an integrated analytic hierarchy process and linear programming. International Journal of Production Economics, 56-57(1), 199-212. https://doi.org/10.1016/S0925-5273(97)00009-9
Güdüz, Ç., & Güdüz, G. Ş. (2019). Supplier selection under fuzzy environment. Tekstil ve Konfeksiyon, 29(4), 344-352.
Inmon, W. (1996). Building the data warehouse (2nd ed.). Wiley.
Hassan, B., Naja, H., Balouch, A., & Makiah, S. (2012). A decision support system for construction equipment management based on data warehousing technique. Tishreen University Journal-Engineering Sciences Series, 34(2), 203-223.
Kannan, D., Jabbour, A. B. L. D. S., & Jabbour, C. J. C. (2014). Selecting green suppliers based on GSCM practices: Using fuzzy TOPSIS applied to a Brazilian electronics company. European Journal of Operational Research, 233(2), 432-447. https://doi.org/10.1016/j.ejor.2013.07.023
Kannan, D., Govindan, K., & Rajendran, S. (2015). Fuzzy Axiomatic Design approach based green supplier selection: a case study from Singapore. Journal of Cleaner Production, 96, 194-208. https://doi.org/10.1016/j.jclepro.2014.01.070
Kohzadi, N., Boyd, M. S., Kaastra, I., Kermanshahi, B., & Scuse, D. (1995). Neural Networks for Forecasting: An Introduction. Canadian Journal of Agricultural Economics/Revue Canadienne D’Agronomie, 43(3), 463-474.
Konys, A. (2019). Green Supplier Selection Criteria: From a Literature Review to a Comprehensive Knowledge Base. Sustainability, 11(15), 4121. https://doi.org/10.3390/su11154121
Kumar, D. (2017). An analytical model for supplier selection. International Journal of Indian Culture and Business Management, 14(2), 131-140.
Kılıç, H. S. (2013). An integrated approach for supplier selection in multi-item/multi-supplier environment. Applied Mathematical Modelling, 37, (14-15), 7752-7763. https://doi.org/10.1016/j.apm.2013.02.032
Moon, S. K. J., & Kwon, K. (2007). Effectiveness of OLAP-based cost management in construction cost estimate. Automation in Construction, 16, 336-344. https://doi.org/10.1016/j.autcon.2006.06.005
Rong, P., Liu, G., An, P., Qi, X., Wang, Q., Yue, C., Zhang, W., Zhang, H., & Dai, Y. (2020). Construction and application of data mining model of unit scale cost of electric grid project. IOP Conference Series: Earth and Environmental Science, 446, 012021. https://doi.org/10.1088/1755-1315/446/1/012021
Rujiayanyong, T., & Shi, J. J. (2006). A project-oriented data warehouse for construction. Automation in Construction, 15, 800-807. https://doi.org/10.1016/j.autcon.2005.11.002
Wang, C. N., Dang, D. C., Vu, Q. Q., & Zeng, Y. X. (2018). Supplier selection for manufacturing industries. In International Conference on Advanced Manufacturing (ICAM) (pp. 1-6). IEEE.
Yahya, S., & Kingsman, B. (1999). Vendor rating for an entrepreneur development programme: a case study using the analytic hierarchy process method. Journal of the Operational Research Society, 50(9), 916-930.
Zakaria, N., Shaharnee, I. N. M., Jamil, J. M., & Nawi, M. N. M. (2015). Assessing stakeholder’s credit risk using data mining in construction project. Advances in Environmental Biology, 9(5), 67-70.
Zhang, S., Zhang, C., & Yang, Q. (2003). Data preparation for data mining. Applied Artificial Intelligence, 17(5-6), 37