Modelo de solución usando inteligencia de negocios por medio de cubos OLAP para el departamento de Crédito de una Empresa comercial de línea Blanca (Diciembre del 2016)
No hay miniatura disponible
Fecha
2016
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Estatal de Guayaquil Facultad de Ciencias Administrativas
Resumen
Las empresas pymes dedicadas a la venta de electrodomésticos de línea
blanca realizan las ventas tanto de contado y/o crédito directo, por lo que es
necesario llevar un control de las ventas como las carteras pendientes por cobrar,
ya que se mantiene un riesgo crediticio. Para disminuir el riesgo crediticio y
desarrollar estrategias eficaces para aumentar las ventas es necesario llevar un
control sobre la cartera, una solución de inteligencia de negocios nos brindara la
información necesaria para mejorar la toma de decisiones ya que la misma nos
permitir analizar, organizar y comprender Información que puede estar alojadas en
distintas fuentes.
El presente proyecto de titulación es una investigación de tipo descriptiva y de
campo, Se realizaron encuestas a las empresas pymes que se dedican a la venta
de electrodomésticos, en el sector de Pascuales. La población total el total de las
empresas pymes en el Ecuador en el año 2014 dedicadas a la venta de
electrodomésticos fue de 220, el 19% pertenece a Guayaquil de donde Se estima
que en la ciudad hay alrededor de 42 pymes dedicadas a esta actividad, por lo que
se decidió tomar como muestra el 20 empresas ubicadas en Pascuales. Obteniendo
como resultados que estas empresas necesitan contar con una herramienta que
les ayude a tener un mejor control sobre su cartera.
La solución de inteligencia de negocios que se está proponiendo brindará la
capacidad al usuario de saber el estado de sus carteras ya que en mismo se hace
una recopilación de la data, para el previo análisis y reportaría de los mismos,
ayudando de esta manera al usuario a que pueda mejorar la toma de decisiones y
teniendo de esta manera una ventaja competitiva. Las herramientas para la
elaboración de esta solución fueron: Base de datos SQL, Data Quality Service,
Integration Service y Reporting Service y Report Builder.
The companies pymes dedicated to the sale of domestic appliances realize the sales so much of counted and/or direct credit, therefore it is necessary to take a control of the sales as the hanging portfolios for charging, since a credit risk is supported. To diminish the credit risk and to develop effective strategies to increase the sales. It is necessary to take a control on the portfolio, a solution of business intelligence will offer to us the necessary information to improve the decision-making since the same one us to allow to analyze, organize and to understand Information that they can be lodged in different sources. The present project of qualification is a research of type descriptive and of field, is carried out surveys to them companies SMEs that is dedicated to the sale of appliances, in the sector of Passover. The total population, the total number of enterprises engaged in the sale of appliances SMEs in the Ecuador in 2014 was 220, 19% belongs to Guayaquil where it is estimated that in the city there are about 42 SMEs engaged in this activity, it was decided to take as an example the 20 companies located in Easter. Obtaining as results that these companies need have with a tool that them help to have a better control on your portfolio. The solution of business intelligence that is being proposed will provide capacity to the user to know the status of their portfolios because that in itself is a compilation of the data, for prior analysis and would bring them, thus helping the user to to improve decision-making and thus having a competitive advantage. The tools for the elaboration of this salución were: database SQL, Data Quality Service, Integration Service and Reporting Service and Report Builder.
The companies pymes dedicated to the sale of domestic appliances realize the sales so much of counted and/or direct credit, therefore it is necessary to take a control of the sales as the hanging portfolios for charging, since a credit risk is supported. To diminish the credit risk and to develop effective strategies to increase the sales. It is necessary to take a control on the portfolio, a solution of business intelligence will offer to us the necessary information to improve the decision-making since the same one us to allow to analyze, organize and to understand Information that they can be lodged in different sources. The present project of qualification is a research of type descriptive and of field, is carried out surveys to them companies SMEs that is dedicated to the sale of appliances, in the sector of Passover. The total population, the total number of enterprises engaged in the sale of appliances SMEs in the Ecuador in 2014 was 220, 19% belongs to Guayaquil where it is estimated that in the city there are about 42 SMEs engaged in this activity, it was decided to take as an example the 20 companies located in Easter. Obtaining as results that these companies need have with a tool that them help to have a better control on your portfolio. The solution of business intelligence that is being proposed will provide capacity to the user to know the status of their portfolios because that in itself is a compilation of the data, for prior analysis and would bring them, thus helping the user to to improve decision-making and thus having a competitive advantage. The tools for the elaboration of this salución were: database SQL, Data Quality Service, Integration Service and Reporting Service and Report Builder.
Descripción
Palabras clave
INTELIGENCIA DE NEGOCIOS, CUBOS OLAP, DATAWAREHOUSE