Abstract
Actually, a set of ETL software (Extract, Transform and Load) is available to constitute a major investment market. Each ETL uses its own techniques for extracting, transforming and loading data into data warehouse, which makes the task of evaluating ETL software very difficult. However, choosing the right software of ETL is critical to the success or failure of any Business Intelligence project. As there are many impacting factors in the selection of ETL software, the same process is considered as a complex multi-criteria decision making (MCDM) problem. In this study, an application of decision-making methodology that employs the two well-known MCDM techniques, namely Analytic Hierarchy Process (AHP) and Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) methods is designed. In this respect, the aim of using AHP is to analyze the structure of the ETL software selection problem and obtain weights of the selected criteria. Then, TOPSIS technique is used to calculate the alternatives’ ratings. An example is given to illustrate the proposed methodology. Finally, a software prototype for demonstrating both methods is implemented.
Highlights
Business Intelligence (BI) is a field of information systems architecture
The analytical model integrated with Analytic Hierarchy Process (AHP) (Analytical Hierarchy Process) method and TOPSIS (Technique for Order Preference by Similarity to Ideal Solution) will help to determine the right judgment in ETL software selection based on decision-makers’ specific requirements
AHP method is an excellent multicriteria decision making (MCDM) technique as it provides a structure and hierarchy method for synthesizing software selection problems which is used to calculate the weight of selected criteria (Lin et al 2007), and TOPSIS technique is employed to rank the alternative software based on their overall performance
Summary
Business Intelligence (BI) is a field of information systems architecture. It allows implementing the means to collect, transform and restore data to assist decision-makers in enterprises. The analytical model integrated with AHP (Analytical Hierarchy Process) method and TOPSIS (Technique for Order Preference by Similarity to Ideal Solution) will help to determine the right judgment in ETL software selection based on decision-makers’ specific requirements. AHP method is an excellent MCDM technique as it provides a structure and hierarchy method for synthesizing software selection problems which is used to calculate the weight of selected criteria (Lin et al 2007), and TOPSIS technique is employed to rank the alternative software based on their overall performance.
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: 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.
