Ahp decision making software full#
Ahp decision making software software#

Ahp decision making software software#

This article is distributed under the terms of the Creative Commons Attribution 4.0 International License (), which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license, and indicate if changes were made.Ĭhoosing ETL software is a wise choice that limits the costs and risks associated with projects. In other words, the chosen software must be in accordance with the organizational goals and has to maximize the benefits of the organization. One of the important and initial activities of a BI project is the selection of the most appropriate ETL software.

2009), ETL software has been ranked among the highest priorities (Kimball and Caserta 2004). In the surveys conducted to determine important questions touching decision-makers and designers of BI projects (Simitsis et al. With the development of the use of BI, ETL becomes a critical factor affecting the success of a BI project. The heart of BI is based on data warehouses powered by ETL, which is generally a part of BI and is usually the starting point for each project. It allows implementing the means to collect, transform and restore data to assist decision-makers in enterprises. Keywords: ETL, ETL software selection problem, Business Intelligence, MCDM (multi-criteria decision making), AHP (analytic hierarchy process), TOPSIS (technique for order preference by similarity to ideal solution)īusiness Intelligence (BI) is a field of information systems architecture. Finally, a software prototype for demonstrating both methods is implemented. An example is given to illustrate the proposed methodology. Then, TOPSIS technique is used to calculate the alternatives' ratings. 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. In this study, an application of decisionmaking 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. 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. However, choosing the right software of ETL is critical to the success or failure of any Business Intelligence project. 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.

Ahp decision making software full#

'Correspondence: 1 Departement of Computer Science, Laboratory of Engineering and Information Systems, Faculty of Sciences Semlalia, Cadi Ayyad University, Marrakesh, Morocco Full list of author information is available at the end of the articleĪctually, a set of ETL software (Extract, Transform and Load) is available to constitute a major investment market. Mohamed Hanine1*, Omar Boutkhoum1, Abdessadek Tikniouine1 and Tarik Agouti2 SpringerPlus (2016) 5:263 DOI 10.1186/S40064-016- 1888-zĪpplication of an integrated multi-criteria decision making AHP-TOPSIS methodology for ETL software selection