Desarrollo de Modelos Dimensionales

Abstract

The main problems encountered in the company Azucarera Valdez are the lack of control and follow-up on sales of each of the products; the control and monitoring of agricultural equipment used in the adequacy, preparation, sowing, cultivation and harvesting; the costs incurred in the zafra and interzafra, also the large number of reports developed manually and submitted to the directory. For these reasons, the solution was to implement a strategy of business intelligence that is not a simple reporting tool, but a tool that generates competitive advantage. This tool allows the company to make decisions at the right time. It is noteworthy that the developed models of information contain historical information that will support the analysis of performance and return on investment. Among the obtained results we have: Reduction of the time required to collect all relevant information from the business and Allow that users do not rely on reports or scheduled reports, because they will be generated dynamically.