Then, choosing 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. Finally, a software prototype for demonstrating both methods is implemented.īusiness Intelligence (BI) is a field of information systems architecture. 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 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. 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. Actually, a set of ETL software (Extract, Transform and Load) is available to constitute a major investment market.
0 kommentar(er)
