Skip to main content
SpringerLink
Log in

Applying Business Intelligence and KPIs to Manage a Pharmaceutical Distribution Center: A Case Study

  • Conference paper
  • First Online:
Technology, Sustainability and Educational Innovation (TSIE) (TSIE 2019)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 1110))

  • 687 Accesses

Abstract

The use of modern Business Intelligence (BI) tools, provide real-time information and support decision making. In this context, the purpose of the present study was to develop a BI application. To do so we had to identify the structure of the Key Performance Indicators (KPI), to analyze and select a BI methodology and tools through an empirical method. Three types of research methods were applied: Descriptive, documentary and field. Data were collected through interviews. Finally, the elements of the KPI structure were identified as the following: (a) denomination, (b) concept, (c) function, (d) objective (e) form of calculation, (f) frequency of calculation, (g) data source, (h) form of representation and (i) responsible. Then, we developed as a case study a BI application using QPM and the QlikView methodology to support decision-making in the distribution center of the company Farmaenlace Cía Ltda.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Muñoz, H., Osorio, R., & Zúñiga, L.: Inteligencia de los negocios. Clave del éxito en la era de la información. Clío América, 10(20), 194–211 (2016)

    Google Scholar 

  2. Maldonado, I.: Solución de inteligencia de negocios y toma de decisiones en la gestión administrativa de boticas. UCV- HACER: Revista de Investigación y Cultura, Vol. 3 (No. 2) (2014)

    Google Scholar 

  3. Fortuin, L.: Performance indicators-Why, where and how? (1998)

    Google Scholar 

  4. Epstein, M. J., Manzoni, J. F.: The balanced scorecard and tableau de bord: a global perspective on translating strategy into action (1998)

    Google Scholar 

  5. Coneval, C.N.: Manual para el diseño y la construcción de indicadores. México, Distrito Federal (2013)

    Google Scholar 

  6. Asociación Española de Normalización y Certificación AENOR: Norma Española UNE 66175-Sistemas de gestión de la calidad: Guía para la implantación de sistemas de indicadores. España: AENOR (2003)

    Google Scholar 

  7. Michelo, J., Medellin, E., Hidalgo, A., Jassó, J.: Conocimiento e innovación. UAM-UNAM-Plaza y Valdés, México (2008)

    Google Scholar 

  8. Leonard, E., Castro, Y.: Metodologías para desarrollar Almacén de Datos. Revista de Arquitectura e Ingeniería, 7(3) (2013)

    Google Scholar 

  9. Gartner, Inc.: Magic Quadrant for Business Intelligence and Analytics Platforms. Obtenido de (2017). www.gartner.com

  10. Sterry, B., Nieuwenhuijs, J.: QlikView Project Methodology HandBook. Obtenido de (2011). https://es.slideshare.net/AntoninoBarbaro/qlik-viewproject-methodology-handbook-v-10-docx

  11. SAIMA Solutions: QlikView. Recuperado el 14 de 04 de 2017, de (2017). http://saimasolutions.com/qlikview/

  12. Carrasco, L., Zambrano, R.: Implementación de Inteligencia de Negocios en el área de servicios hospitalarios del Hospital San José. Universidad de Guayaquil, Guayaquil, Ecuador (2015)

    Google Scholar 

  13. Guevara-Vega, C.P., Guzmán-Chamorro, E.D., Guevara-Vega, V.A., Andrade, A.V.B., Quiña-Mera, J.A.: Functional Requirement Management Automation and the Impact on Software Projects: Case Study in Ecuador. Springer Professional, Advances in Intelligent Systems and Computing, vol. 918, pp. 317–324 (2019). https://doi.org/10.1007/978-3-030-11890-7_31

  14. Coronel, F.T.: Análisis de cadenas de ventas al Retail para definir procesos ETL que faciliten la elaboración de un Data Warehouse que permita un análisis financiero. Universidad de Cuenca, Cuenca, Ecuador (Julio de 2015)

    Google Scholar 

  15. Kimball, R., Caserta, J.: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Wiley Publishing, Indianapolis (2004)

    Google Scholar 

  16. Inmon, W.H.: Building the Data Warehouse, 3rd edn. Wiley Publishing, Inc., New York (2005)

    Google Scholar 

  17. Bernabeu, R.: Data Warehousing Investigación y Sistematización de Conceptos. Hefesto: Metodología para la Construcción de un Data Warehouse. Córdova, Argentina (2010)

    Google Scholar 

  18. Merino, H.: Implementación de un modelo básico para el uso de la información georeferencial en aplicaciones de Business Intelligence. Caso de Estudio: Empresa Retail. Pontificia Universidad Católica del Ecuador, Quito – Ecuador (2015)

    Google Scholar 

  19. Torres, J.E.: Propuesta metodológica de una solución de inteligencia de negocios aplicada al sistema infromático integrado de talento humano y sistema de registro de contratos y actas de finiquito. Universidad de las Américas UDLA, Quito, Ecuador (2016)

    Google Scholar 

  20. Estudio: Empresa Retail. Pontificia Universidad Católica del Ecuador, Quito - Ecuador

    Google Scholar 

  21. Microsoft: SQL Server Business Intelligence. Recuperado el 2017, de (2013). https://www.microsoft.com/en-us/sql-server/sql-business-intelligence

  22. Microsoft: Power BI. Recuperado el 01 de 05 de 2017, de (2017). https://powerbi.microsoft.com/es-es/what-is-power-bi/

  23. Tableau: La plataforma de Tableau. Recuperado el 29 de 03 de 2017, de (2017). https://www.tableau.com/es-es/products

  24. Guevara, C.: La Inteligencia de Negocios en las Instituciones de Educación Superior. Ibarra, Ecuador: Imprenta Universitaria-Universidad Técnica del Norte (2015)

    Google Scholar 

  25. Acosta, J., Flórez, D.: Diseño e implementación de prototipo BI utilizando una herramienta Big Data para empresas Pymes Distribuidoras de tecnología. Recuperado el 30 de 04 de 2017, de (2015). http://repository.ucatolica.edu.co/bitstream/10983/2543/1/PROYECTO%20FINAL_pdf

  26. Information Technology Consulting Services: Business Intelligence. Obtenido de (2017). http://www.itcon.es/bi

  27. Bitterer, A., Bange, C., Fuchs, C.: BARC Business Intelligence Score 2015 (2015)

    Google Scholar 

  28. CIAT: Nuevas tendencias de la BI. Recuperado el 15 de 04 de 2017, de (2013). https://www.ciat.org/nuevas-tendencias-de-la-bi/

  29. Reddy, C.S., Sangam, R.S., Srinivasa Rao, B.: A survey on business intelligence tools for marketing, financial, and transportation services. In: Smart Innovation, Systems and Technologies, pp. 495–504 (2019)

    Google Scholar 

  30. Karami, M., Safdari, R.: From information management to information visualization: Development of radiology dashboards. In: Applied Clinical Informatics, pp. 308–329 (2016)

    Google Scholar 

  31. Zheng, A.: Finance net-interest margin analysis with qlikview. In: Business Analytics: Progress on Applications in Asia Pacific, pp. 432–453 (2016)

    Google Scholar 

  32. Shukla, A., Dhir, S.: Tools for data visualization in business intelligence: case study using the tool qlikview. In: Information Systems Design and Intelligent, pp. 319–326 (2016)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Universidad Técnica del Norte, Facultad de Ingeniería en Ciencias Aplicadas Network Science Research Group e-CIER, Av. 17 de Julio, Ibarra, Ecuador

    Cathy Guevara-Vega, Jeferson Ayala, Jenny Ortiz, Alexander Guevara-Vega, Daisy Imbaquingo & Pablo Landeta

Authors
  1. Cathy Guevara-Vega
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jeferson Ayala
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jenny Ortiz
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Alexander Guevara-Vega
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Daisy Imbaquingo
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. Pablo Landeta
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Cathy Guevara-Vega .

Editor information

Editors and Affiliations

  1. Ciudadela Universitaria, Universidad Técnica del Norte, Ibarra, Ecuador

    Andrea Basantes-Andrade

  2. Ciudadela Universitaria, Universidad Técnica del Norte, Ibarra, Ecuador

    Miguel Naranjo-Toro

  3. Ciudadela Universitaria, Universidad Técnica del Norte, Ibarra, Ecuador

    Marcelo Zambrano Vizuete

  4. Department of Mathematics and Computer, Eindhoven University of Technology, Eindhoven, Noord-Brabant, The Netherlands

    Miguel Botto-Tobar

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Guevara-Vega, C., Ayala, J., Ortiz, J., Guevara-Vega, A., Imbaquingo, D., Landeta, P. (2020). Applying Business Intelligence and KPIs to Manage a Pharmaceutical Distribution Center: A Case Study. In: Basantes-Andrade, A., Naranjo-Toro, M., Zambrano Vizuete, M., Botto-Tobar, M. (eds) Technology, Sustainability and Educational Innovation (TSIE). TSIE 2019. Advances in Intelligent Systems and Computing, vol 1110. Springer, Cham. https://doi.org/10.1007/978-3-030-37221-7_25

Download citation

Publish with us

Policies and ethics

Search

Navigation