Análisis de cadenas de ventas al Retail para definir procesos ETLque faciliten la elaboración de un Datawarehouse que permita un análisis financiero

Abstract

This document, in its first chapter presents the subject of the study, hypothesis, and the objectives that want to be achieved along with relevant methodology. The second chapter includes the literature review that focuses on what Retail sales are, and their important characteristics; after, the financial aspect, its concept and its importance in the area of Retail businesses will be analyzed to obtain indicators which will allow to measure its performance. In the third chapter, the concept of Balanced Scorecard will be analyzed to define observable parameters (indicators) that will be obtained by applying a survey to the financial area of various Retail businesses in the city of Cuenca with the purpose of obtaining objectives that will give us as result only the indicators that are considered important for making decisions in the local level. In the fourth chapter, main concepts and characteristics of Datawarehouse are described; subsequently, the different methodologies that exist for its development are examined, selecting the most suitable for the analyzed context. This will be done by means of a comparative chart between the methodologies and characteristics of Retail businesses. Finally, in the last chapter, taking as reference the selected methodology, the steps and characteristics that Datawarehouse should have will be defined in order to structure it in such a way that allows a financial analysis based on the previously established indicators, and this will be achieved through a case study applied to the enterprise PapeleríaMonsalve Cia. Ltdafromthecity of Cuenca.