Maestría en Informática
Permanent URI for this collection
Browse
Browsing Maestría en Informática by Subject "Bases de Datos"
Now showing 1 - 3 of 3
Results Per Page
Sort Options
Item Modelo de caracterización del perfil del cliente adaptado al sector de la construcción, aplicando minería de datos: caso de estudio en empresa constructora(Universidad Santiago de Cali, 2019) Erazo Cardona, Carlos AlbertoBuilding houses process in construction companies is affected by fallen negotiations before delivery of the living place, unknowing the reasons for this situation. In building sector there is no a model that allows the characterization of customer profile linked to the commercialization process that would contribute to mitigate the risk to business agreement. As several productive sectors begin to apply data mining, adaptations of traditional methodologies for data mining arise, which solve particularities of these sectors. This paper proposes a characterization model of customer profile adapted to building sector with data mining that includes the results obtained in case study in a building company. The Knowledge Discovery in Databases (KDD) methodology was followed with an adaptation or contribution found in literature that identified own characteristics of building industry in the approach, design, mining techniques, pattern evaluation and validation that allowed generalizing the model. With case study, a design for the data warehouse based on the multidimensional data model using the star schema was proposed. It was proved that classification, regression and clustering techniques are recommended to solve the problem and finally the proposal for data mining techniques evaluation and validation was presented. The generalization of the characterization model of customer profile, confirmed the tendency and requirement of the productive sectors to have data mining models specific to their needs.Item Sistema de información para la articulación y administración de datos dinámicos del sector educativo (SIADSE) en el departamento del Cauca(Universidad Santiago de Cali, 2019) Bambague Meneses, Rodrigo Gaitán; Sánchez Ledesma, Javier Arley; Dinas, SimenaNowadays, missional entities, in a public and private educational field, provide heterogeneous information systems (IS) to its service and use, delaying articulating the information. The spread of architecture and missional differences hinder the decision making and negatively impact the education fundamental right in the Cauca department. There by designing and developing a IS is proposed to articulate and analyze dynamically the different data sources information to facilitate the strategic educational field making decisions, following a protocol to an analysis and articulation data section. In line with the Ministry of national education normativity, this protocol is used to place strategical value to the information. This technological applied research proposes developing the objective, creating a single data source based on the analytics of the BIG DATA concepts. As a result, it seeks to generate reports or managerial sights that support the decisions agreed with the necessities, facilitating the optimal allocation of resources to the different educational programs and projects. All that is based on the SI development rooted in the XP and APEX methodology as an RAP development tool where they dynamically interacted to develop SIADSE.Item Transformación Digital de la Gestión Docente de la Universidad Santiago de Cali utilizando Inteligencia de Negocios(Universidad Santiago de Cali, 2019) Herrera Ramírez, Javier Ricardo; Borda Restrepo, Jorge Aníbal; Simena, DinasThis document proposes an investigation in the Digital transformation using Business Intelligence to support the decision making in the Santiago de Cali University; the main motivation is the capacity to generate opportune and precise information, to later, to use them in the decision making, to generate the best strategies according to the reality of the organization and that lead to the success. For the purposes of the study, bibliographic reviews of the main concepts of Business Intelligence were carried out, interviews were conducted to the different areas of the institution that require information from teachers such as: quality assurance, human management, research and Academic vice-rectory, to know the needs regarding performance indicators and obtaining information; this approach allowed to obtain the requirements of users, guide the development of the project to meet the needs of the areas interviewed, this research used the business intelligence tool qlik sense, to generate knowledge related to teachers in the USC. As for the methodology, a qualitative descriptive research methodology was used and as a methodology for the development of the business intelligence model, a methodology for the development of business intelligence projects was applied, which allows the identification of the needs to integrate data in an organization. The most relevant findings are: A. The most valuable asset in the organization is knowledge; B. Business intelligence is fed from data repositories to support decision making; C. Technological innovation is fundamental for the institution to remain competitive; D. Business intelligence improves knowledge management and allows an updated reading of the organization.