An Integrated Strategy Based in Processes, Requirements, Measurement and Evaluation for the Formalization of Necessities in Data Warehouse Projects

Abstract

In this work we proposes an Integrated Strategy based in Processes, Requirements, Measurement and Evaluation, whose objective is to identify and maintain a traceability of such requirements at early stages in data warehouse projects. Our strategy starts with the process formalization using SPEM to improve its communicability and extensibility. From the process formalization, we continue with the definition of the measurement and evaluation (M&E) project to quantify the behavior of each process and its necessities. This enables progress in the project scoping, the early identification of its risks, and at the same time establishes a traceability mechanism between the decisions and the artifacts that may generate throughout its life cycle. This represents an important compliment regarding life cycles as proposed by Kimball, in which the requirement phase is not formalized and there is no strategy to clearly define the aspects to quantify and/or analyze to the effects of supporting a decision making process. Finally, an example of the strategy application for one process of the Ministry of Education of Ecuador is shown.