Dise��o e implementaci��n de un sistema de soporte de decisiones para el Centro de Documentaci��n Regional ���Juan Bautista V��zquez���

El volumen de datos en bibliotecas ha aumentado enormemente en los ��ltimos a��os, as�� como tambi��n la complejidad de sus fuentes y formatos de informaci��n, dificultando su gesti��n y acceso, especialmente como apoyo en la toma de decisiones. Sabiendo que una buena gesti��n de bibliotecas involucra la integraci��n de indicadores estrat��gicos, la implementaci��n de un Data Warehouse (DW), que gestione adecuadamente tal cantidad de informaci��n, as�� como su compleja mezcla de fuentes de datos, se convierte en una alternativa interesante a considerar. El art��culo describe el dise��o e implementaci��n de un sistema de soporte de decisiones (DSS) basado en t��cnicas de DW para la biblioteca de la Universidad de Cuenca. Para esto, el estudio utiliza una metodolog��a hol��stica, propuesto por Siguenza-Guzman et al. (2014) para la evaluaci��n integral de bibliotecas. Dicha metodolog��a eval��a la colecci��n y los servicios, incorporando importantes elementos para la gesti��n de bibliotecas, tales como: el desempe��o de los servicios, el control de calidad, el uso de la colecci��n y la interacci��n con el usuario. A partir de este an��lisis, se propone una arquitectura de DW que integra, procesa y almacena los datos. Finalmente, estos datos almacenados son analizados y visualizados a trav��s de herramientas de procesamiento anal��tico en l��nea (OLAP). Las pruebas iniciales de implementaci��n confirman la viabilidad y eficacia del enfoque propuesto, al integrar con ��xito m��ltiples y heterog��neas fuentes y formatos de datos, facilitando que los directores de bibliotecas generen informes personalizados, e incluso permitiendo madurar los procesos transaccionales que diariamente se llevan a cabo.

Optimal resource allocation and budgeting in libraries

Libraries since their inception 4000 years ago have been in a process of constant change. Although, changes were in slow motion for centuries, in the last decades, academic libraries have been continuously striving to adapt their services to the ever-changing user needs of students and academic staff. In addition, e-content revolution, technological advances, and ever-shrinking budgets have obliged libraries to efficiently allocate their limited resources among collection and services. Unfortunately, this resource allocation is a complex process due to the diversity of data sources and formats required to be analyzed prior to decision-making, as well as the lack of efficient integration methods. The main purpose of this study is to develop an integrated model that supports libraries in making optimal budgeting and resource allocation decisions among their services and collection by means of a holistic analysis. To this end, a combination of several methodologies and structured approaches is conducted. Firstly, a holistic structure and the required toolset to holistically assess academic libraries are proposed to collect and organize the data from an economic point of view. A four-pronged theoretical framework is used in which the library system and collection are analyzed from the perspective of users and internal stakeholders. The first quadrant corresponds to the internal perspective of the library system that is to analyze the library performance, and costs incurred and resources consumed by library services. The second quadrant evaluates the external perspective of the library system; user���s perception about services quality is judged in this quadrant. The third quadrant analyses the external perspective of the library collection that is to evaluate the impact of the current library collection on its users. Eventually, the fourth quadrant evaluates the internal perspective of the library collection; the usage patterns followed to manipulate the library collection are analyzed. With a complete framework for data collection, these data coming from multiple sources and therefore with different formats, need to be integrated and stored in an adequate scheme for decision support. A data warehousing approach is secondly designed and implemented to integrate, process, and store the holistic-based collected data. Ultimately, strategic data stored in the data warehouse are analyzed and implemented for different purposes including the following: 1) Data visualization and reporting is proposed to allow library managers to publish library indicators in a simple and quick manner by using online reporting tools. 2) Sophisticated data analysis is recommended through the use of data mining tools; three data mining techniques are examined in this research study: regression, clustering and classification. These data mining techniques have been applied to the case study in the following manner: predicting the future investment in library development; finding clusters of users that share common interests and similar profiles, but belong to different faculties; and predicting library factors that affect student academic performance by analyzing possible correlations of library usage and academic performance. 3) Input for optimization models, early experiences of developing an optimal resource allocation model to distribute resources among the different processes of a library system are documented in this study. Specifically, the problem of allocating funds for digital collection among divisions of an academic library is addressed. An optimization model for the problem is defined with the objective of maximizing the usage of the digital collection over-all library divisions subject to a single collection budget. By proposing this holistic approach, the research study contributes to knowledge by providing an integrated solution to assist library managers to make economic decisions based on an ���as realistic as possible��� perspective of the library situation.

Inteligencia de negocios aplicando la metodolog��a RFM a las cuentas de los Socios de la COAC Jard��n Azuayo

El presente proyecto:Inteligencia de negocios, aplicando la metodolog��a RFM a las cuentas de los socios de la COAC Jard��n Azuayo, se desarrolla sobre la necesidad de la instituci��n de contar con herramientas eficientes y eficaces para la toma de decisiones y conocimiento del socio. Primero, se determina la importancia de construir una herramienta de Inteligencia de Negocios dentro de Jard��n Azuayo que permita obtener informaci��n clara y concisa en tiempo real para la toma de decisiones. Segundo, se contin��a con el desarrollo de metodolog��as para la gesti��n del valor del socio a trav��s del conocimiento de sus necesidades analizando la informaci��n hist��rica de su ��ltima transacci��n realizada, la frecuencia con la que acude para acceder a los servicios que ofrece la Cooperativa y el monto promedio por transacci��n. Finalmente, al combinar la herramienta de Inteligencia de Negocios para la obtenci��n de informaci��n y la aplicaci��n de metodolog��as para el conocimiento del socio, se ha podido plantear dos estrategias b��sicas para la afianzar la fidelizaci��n del socio con la Cooperativa.