Extension of correlation coefficient based TOPSIS technique for interval-valued Pythagorean fuzzy soft set: A case study in extract, transform, and load techniques

Correlation is an essential statistical concept for analyzing two dissimilar variables’ relationships. Although the correlation coefficient is a well-known indicator, it has not been applied to interval-valued Pythagorean fuzzy soft sets (IVPFSS) data. IVPFSS is a generalized form of interval-valued intuitionistic fuzzy soft sets and a refined extension of Pythagorean fuzzy soft sets. In this study, we propose the correlation coefficient (CC) and weighted correlation coefficient (WCC) for IVPFSS and examine their necessary properties. Based on the proposed correlation measures, we develop a prioritization technique for order preference by similarity to the ideal solution (TOPSIS). We use the Extract, Transform, and Load (ETL) software selection as an example to demonstrate the application of these measures and construct a prioritization technique for order preference by similarity to the ideal solution (TOPSIS) model. The method investigates the challenge of optimizing ETL software selection for business intelligence (BI). This study offers to illuminate the significance of using correlation measures to make decisions in uncertain and complex settings. The multi-attribute decision-making (MADM) approach is a powerful instrument with many applications. This expansion is predicted to conclude in a more reliable decision-making structure. Using a sensitivity analysis, we contributed empirical studies to determine the most significant decision processes. The proposed algorithm’s productivity is more consistent than prevalent models in controlling the adequate conformations of the anticipated study. Therefore, this research is expected to contribute significantly to statistics and decision-making.