| Peer-Reviewed

Business Intelligence Information in the World Under Control

Received: 18 March 2021    Accepted: 8 April 2021    Published: 27 August 2021
Views:       Downloads:
Abstract

As a starting point and to clarify the methodology of this project we emphasize that the first person to coin the term Business Intelligence was Hans Peter Luhn, IBM researcher, who, in his article "A Business Intelligence System" published in 1958 mentions the term and provides the following definition: "is the ability to learn the relationships of facts presented in a way that guides actions towards a desired goal". And although it is quite basic compared to today, it opens the doors to a large field of research that brings us to one of the most important technologies of today. Years later topics were introduced to the world of BI, as for example the creation of the concept of database, then large databases for large companies, in the same way the concept of the Datawarehouse, time later arrived the Business Intelligence 2.0, Big data and so on to structure a robust methodology in which all companies worldwide would be immersed. On the other hand, and hand the main objective of the BI was structured. It allows companies to optimize resources, monitor the fulfillment of the company’s objectives and the ability to make good decisions to obtain better results. It represents a competitive advantage for the company, since it acts as a strategic factor in its organization and responds to the doubts that arise in a business, such as financial control, cost optimization, customer profile analysis, production planning or profitability of a product. Thus, all Business Intelligence systems have in common the following features: Accessibility to information: these tools and techniques guarantee users' access to data, regardless of where they come from. Decision Support: Users are sought to have access to analytics tools that allow them to select and use the data they are most interested in. End-User Orientation: The aim is the independence between the technical knowledge of users and their ability to use these tools.

Published in American Journal of Computer Science and Technology (Volume 4, Issue 3)
DOI 10.11648/j.ajcst.20210403.12
Page(s) 55-74
Creative Commons

This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.

Copyright

Copyright © The Author(s), 2024. Published by Science Publishing Group

Keywords

Intelligence, Oracle, Warehouse, Systems, Etl, Corporate, Tools, Logic

References
[1] De Mazariegos, A. (May 9, 2004). Information systems for executives. Obtained from gestiopolis: http://www. gestiopolis.com/sistemas-de-information -para-executives/.
[2] Dominguez, J. I. (March 17, 2005). CRM visions. Retrieved from Gestiopolis: http://www.gestiopolis. /4-visiones-crm/.
[3] Zarate, G. (2013). Business intelligence. Obtained from Gestiopolis: http://www.gestiopolis.com/-business intelligence/.
[4] Pentaho.com. (2014). Pentaho Business Analytics. Recuperado de: http://www.pentaho.com/ product/business-visualization-analytics.
[5] Watson, Hugh J. (2009). Tutorial: Business Intelligence – Past, Present, and Future. Communications of the Association for Information Systems, Vol. 25, Article 39. Recuperado de: http://aisel.aisnet.org/cais/vol25/iss1/39.
[6] Chaudhuri, S., Dayal, U., & Narasayya, V. (2011). An Overview of Business Intelligence Technology. Communications of the ACM, 54 (8), 88-98. Recuperado de https://cacm.acm.org/magazines/2011/8/114953-an-overview-of-business-intelligence-technology/fulltext.
[7] Snijders, C., Matzat, U., & Reips, U. D. (2012). ‘Big Data’: Big gaps of knowledge in the field of Internet. International Journal of Internet Science, 7 (1), 1-5. Recuperado de https://kops.uni-konstanz.de/bitstream/handle/123456789/28647/Snijders_286475.pdf?sequence=2.
[8] Betts, Mitch. "The future of business intelligence". Computerworld. http://www.kmcluster.com/The%20Future%20of%20Business%20Intelligence.html.
[9] Pavez Salazar, 2000 Pavez Salazar, A. A. (2000). Knowledge management in organizations. Online document. Available in: http://www.gestiondelconocimiento.com/documentos2/apavez/gdc.htm. Retrieved 13 October 2013.
[10] EFQM, 2010 EFQM. European Foundation for Quality Management [consultado 1 Oct 2010]. Disponible en: http://www.efqm.org.
[11] Claver, E.; Llopis, J.; Lloret, M.; Molina, H.: "Business Administration Manual", 4th Edition, Civitas, Madrid, 2000.
[12] Cyert, R. M.; March, J. G.: "Theory of economic decisions of the comp any", Herrero Hermanos, Mexico, 1965.
[13] Davis, D.: "Management Research for Decision Making", Thomson, Mexico, 2000.
[14] Dixon, J. R.: "Engineering Design: Inventiveness, Analysis and Decision Making", Limusa-Wiley, Mexico, 1970.
[15] Gil Pechuán, I.: "Information Systems and Technologies for Management", Polytechnic University of Valencia, 1996.
[16] Gil Pechuán, I.: "Information Systems for Business Management", Polytechnic University of Valencia, 1994.
[17] González Ramírez, M. R.: "Information Systems for the Company", Publications of the University of Alicante, 2001.
[18] Greenwood, W.: "Theory of Decisions and Information Systems", Trillas, Mexico, 1978.
[19] Herrera, F.; Herrera-Viedma, E.; Verdegay, J. L.: “Direct approach processes in group decision making using linguistic OWA operators”, Fuzzy Sets and Systems, 79, 1996, págs. 175-190.
[20] Huber, G. P.: "Management Decision Making", Trillas, Mexico, 1984.
[21] Ernestina Mensalvas Ruiz, José María Peña Sanchez, 2000. Data Mining: Techniques and tools. Polytechnic University of Madrid, Department of Languages and Computer Systems and Software Engineering.
[22] José Martín Arevalillo, 2000. Data Mining, a decision-making tool. U. N. E. D. Department of Statistics and Operational Research.
[23] Areas of Research, Data Warehousing and OLAP Technology in http://gplsi.dlsi.ua.es/gplsi/areas.htm.
[24] Javier Cantoral Justo, 2002. Data Mining Concepts and Techniques. University of Alicante, Research Group of information systems in the company.
[25] Data Mining y Data Warehousing en www.kdnuggets.com.
[26] Data Warehouse Terminology, 2003. En http://www.credata.com/research/terminology.html.
[27] On Line Analitical Processing en http://altaplana.com/olap/.
[28] SENA - National Learning Service (s.f.) ARCHITECTURE OF A DATA BODEGA. Retrieved from https://senaintro.blackboard.com/bbcswebdav/institution/seeds/2172191VIRTUAL/OAAPs/OAAP3/aa4/oaarchitecturebodegas/utilities/downloadable.pdf.
[29] M. Rizzi S. (2009) Data Warehouse Desing. Modern Principles and Methodologies. Tata McGra-Hill. Recuperado dehttps://cs09lects.files.wordpress.com/2012/12/bookdata-warehouse-design-golfarelli-_-rizzi.pdf.
[30] Castro, Eduardo. (2015). Introduccion datawarehouse. https://es.slideshare.net/ecastrom/introduccion-datawarehouse44384485.
[31] Ionos - SGBD: introduction to the database management system – March 03, 20 https://www.ionos.es/digitalguide/hosting/cuestiones-tecnicas/sistema-gestor-de-base-de-datos-sgbd/.
[32] Aprende Colombia Aprende - Database Management Systems http://aprende.colombiaaprende.edu.co/sites/default/files/naspublic/curriculos_ex/n2g10_pweb1/nivel2/web1/unidad1/leccion3.html.
[33] What is a database manager and what is it for? – May 9, 19 -https://blog.powerdata.es/el-valor-de-la-gestion-de-datos/que-es-un-gestor-de-datos-y-para-que-sirve.
[34] Most used database managers- June 24, 2019 - https://www.netec.com/post/que-es-un-gestor-de-base-de-datos-y-cuales-son-los-mas-usados.
[35] Wikipedia - Database management systems - https://es.wikipedia.org/wiki/Sistema_de_gesti%C3%B3n_de_bases_de_datos Concepto.de - What is a database -June 24, 20 - https://concepto.de/base-de-datos/.
[36] 200 Response - Comparison of relational and non-relational databases – October 8, 19 - https://medium.com/200-response/comparaci%C3%B3n-bases-de-datos-relacionales-y-no-relacionales-424dd83dd693.
[37] Academia Progma – Relational databases – May 28, 2019 - https://www.pragma.com.co/academia/lecciones/bases-de-datos-relacionales-vs.-no-relacionales#:~:text=todos%20los%20residentes.-,Las%20bases%20de%20datos%20relacionales%20utilizan%20un%20lenguaje%20de%20consulta,y%20se%20almacenan%20por%20tablas.&text=afecta%20a%20nadie.-,Las%20bases%20de%20datos%20no%20relacionales%20tienen%20un%20esquema%20din%C3%A1mico,los%20datos%20para%20su%20manipulaci%C3%B3n.
[38] PowerData - Types and function of database managers - August 12, 2015 - https://blog.powerdata.es/el-valor-de-la-gestion-de-datos/bid/406547/tipos-y-funci-n-de-los-gestores-de-bases-de-datos.
[39] FreelancerMap - What does a database administrator do? June 17, 2020 https://www.freelancermap.com/blog/es/que-hace-administrador-bases-datos/.
[40] The Web Logic, (2017), Youtube “Business Intelligence | How to create a Data Warehouse." https://www.youtube.com/watch?v=WAOs7E0xXZk.
[41] Alejandro P, (2015), YouTube “Introducción a Data Warehouses”. https://www.youtube.com/watch?v=R9XZavDU-9M.
[42] Logicalis, (2016) "Business Intelligence Tools". https://blog.es.logicalis.com/analytics/herramientas-business-intelligence-tendencias-2017.
[43] Synergy, (website), "Architecture of a Business Intelligencesolution". https://www.sinnexus.com/business_intelligence/arquitectura.aspx.
[44] DeepenU5, (PDF Document),"Layers of all architecture of a Datawarehouse". https://virtual.cun.edu.co/contenidos/migracion2020/sistemas/s9/business-intelligence/u5/recurso5.pdf.
[45] Power Data. (2016). The value of data management. What you need to know about the architecture of a datawarehousehttps://blog.powerdata.es/elvalor-de-la-gestion-de-datos/lo-que-necesitassaber-acerca-de-la-arquitectura-de-undatawarehouse.
[46] NSU, (2019), (web magazine), "Handling and Using Metadata for Files: Comparative Analysis of Major Models and Standards". http://www.nosolousabilidad.com/articulos/manejo_y_uso_de_los_metadatos_para_archivos.htm.
[47] European Union (2004). Commission Decision 2004/387/EC of 28 April 2004 — Decision 2004/387/EC of the European Parliament and of the Council of 21 April 2004 on the interoperable provision of Pan-European e-government services to the public sector, businesses and citizens (IDABC). Recovered from http://eur-lex.europa.eu/legal-content/ES/TXT/?uri=OJ:L:2004:144:TOC.
[48] Van Ballegooie, M., Duff, W. (2006). DCC Digital Curation Manual: Instalment on Archival Metadata. Recuperado de http://www.dcc.ac.uk/sites/default/files/documents/resource/curation-manual/chapters/archival-metadata/archival-metadata.pdf.
[49] OrganizesU5, (PDF Document), "Datawarehouse Layers". https://virtual.cun.edu.co/contenidos/migracion2020/sistemas/s9/business-intelligence/u5/recurso7.pdf.
[50] P. N. Roldan, “That is the statistics”, Ecnomipedia, https://economipedia.com/definiciones/estadistica.html.
[51] Lugo. A. (2020). ¿What is the intelligence of Business? – INVID. Recovered of: https://invidgroup.com/es/que-es-la-inteligencia-de-negocios/.
[52] Syloper. (2018). ¿Why does it serve the mining of information does its date mining? [Online]. Available: https://www.syloper.com/blog/recursos/para-que-sirve-la-mineria-de-datos/.
[53] R. Gallard, “Extraction of Knowledge in Big Databases Using strategies adaptive”, Doctoral dissertation, University of the silver, / Buenos Aires, Argentina marsh de 2012. Available: http://sedici.unlp.edu.ar/bitstream/handle/10915/35555/Documento_completo.pdf?sequence=1.
[54] Lopez. A. Joaquin. (2019). Data mining - Economipedia. Recovered of: https://economipedia.com/definiciones/mineria-de-datos.html.
[55] National university of México. (marsh del 2016). Intelligence of Business: strategy for the development of the competitiveness in companies of technological base. ScienceDirect. Recovered of: https://www.sciencedirect.com/science/article/pii/S0186104215000807.
[56] Golive. (2019). ¿What is the intelligence of business? – GOLIVE. Recovered of: https://www.onegolive.com/faq/guia-practica-de-inteligencia-de-negocio/que-es-inteligencia-de-negocio/.
[57] Oracle. (2016). What is the intelligence of business? Recovered of: https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/317529_esa.pdf.
[58] A. Gonzalez. (2016). ¿What is Machine Learning? [Online]. Available: https://cleverdata.io/que-es-machine-learning-big-data/#:~:text=Machine%20Learning%20es%20una%20disciplina,complejos%20en%20millones%20de%20datos.
[59] Iberdrola. (2018) What is the artificial intelligence? [Online]. Available: https://www.iberdrola.com/innovacion/que-es-inteligencia-artificial.
[60] Andrés. Q. (2021). "That it's business intelligence" and "Information Systems in Decision Making".
[61] Jhon. B. (2021). "DataMining".
[62] Leyder. C. (2021). “DataWareHouse”.
[63] David. R. (2021). "Database Manager Systems".
[64] Felipe. M. (2021). "Data WareHouse Covers".
Cite This Article
  • APA Style

    Andres Felipe Quimbayo Gomez, Jhon Alejandro Botero Gomez, Leyder Andres Cabrales Salazar, Jhojan David Reinoso Bernal, Andres Felipe Marín Rodríguez. (2021). Business Intelligence Information in the World Under Control. American Journal of Computer Science and Technology, 4(3), 55-74. https://doi.org/10.11648/j.ajcst.20210403.12

    Copy | Download

    ACS Style

    Andres Felipe Quimbayo Gomez; Jhon Alejandro Botero Gomez; Leyder Andres Cabrales Salazar; Jhojan David Reinoso Bernal; Andres Felipe Marín Rodríguez. Business Intelligence Information in the World Under Control. Am. J. Comput. Sci. Technol. 2021, 4(3), 55-74. doi: 10.11648/j.ajcst.20210403.12

    Copy | Download

    AMA Style

    Andres Felipe Quimbayo Gomez, Jhon Alejandro Botero Gomez, Leyder Andres Cabrales Salazar, Jhojan David Reinoso Bernal, Andres Felipe Marín Rodríguez. Business Intelligence Information in the World Under Control. Am J Comput Sci Technol. 2021;4(3):55-74. doi: 10.11648/j.ajcst.20210403.12

    Copy | Download

  • @article{10.11648/j.ajcst.20210403.12,
      author = {Andres Felipe Quimbayo Gomez and Jhon Alejandro Botero Gomez and Leyder Andres Cabrales Salazar and Jhojan David Reinoso Bernal and Andres Felipe Marín Rodríguez},
      title = {Business Intelligence Information in the World Under Control},
      journal = {American Journal of Computer Science and Technology},
      volume = {4},
      number = {3},
      pages = {55-74},
      doi = {10.11648/j.ajcst.20210403.12},
      url = {https://doi.org/10.11648/j.ajcst.20210403.12},
      eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajcst.20210403.12},
      abstract = {As a starting point and to clarify the methodology of this project we emphasize that the first person to coin the term Business Intelligence was Hans Peter Luhn, IBM researcher, who, in his article "A Business Intelligence System" published in 1958 mentions the term and provides the following definition: "is the ability to learn the relationships of facts presented in a way that guides actions towards a desired goal". And although it is quite basic compared to today, it opens the doors to a large field of research that brings us to one of the most important technologies of today. Years later topics were introduced to the world of BI, as for example the creation of the concept of database, then large databases for large companies, in the same way the concept of the Datawarehouse, time later arrived the Business Intelligence 2.0, Big data and so on to structure a robust methodology in which all companies worldwide would be immersed. On the other hand, and hand the main objective of the BI was structured. It allows companies to optimize resources, monitor the fulfillment of the company’s objectives and the ability to make good decisions to obtain better results. It represents a competitive advantage for the company, since it acts as a strategic factor in its organization and responds to the doubts that arise in a business, such as financial control, cost optimization, customer profile analysis, production planning or profitability of a product. Thus, all Business Intelligence systems have in common the following features: Accessibility to information: these tools and techniques guarantee users' access to data, regardless of where they come from. Decision Support: Users are sought to have access to analytics tools that allow them to select and use the data they are most interested in. End-User Orientation: The aim is the independence between the technical knowledge of users and their ability to use these tools.},
     year = {2021}
    }
    

    Copy | Download

  • TY  - JOUR
    T1  - Business Intelligence Information in the World Under Control
    AU  - Andres Felipe Quimbayo Gomez
    AU  - Jhon Alejandro Botero Gomez
    AU  - Leyder Andres Cabrales Salazar
    AU  - Jhojan David Reinoso Bernal
    AU  - Andres Felipe Marín Rodríguez
    Y1  - 2021/08/27
    PY  - 2021
    N1  - https://doi.org/10.11648/j.ajcst.20210403.12
    DO  - 10.11648/j.ajcst.20210403.12
    T2  - American Journal of Computer Science and Technology
    JF  - American Journal of Computer Science and Technology
    JO  - American Journal of Computer Science and Technology
    SP  - 55
    EP  - 74
    PB  - Science Publishing Group
    SN  - 2640-012X
    UR  - https://doi.org/10.11648/j.ajcst.20210403.12
    AB  - As a starting point and to clarify the methodology of this project we emphasize that the first person to coin the term Business Intelligence was Hans Peter Luhn, IBM researcher, who, in his article "A Business Intelligence System" published in 1958 mentions the term and provides the following definition: "is the ability to learn the relationships of facts presented in a way that guides actions towards a desired goal". And although it is quite basic compared to today, it opens the doors to a large field of research that brings us to one of the most important technologies of today. Years later topics were introduced to the world of BI, as for example the creation of the concept of database, then large databases for large companies, in the same way the concept of the Datawarehouse, time later arrived the Business Intelligence 2.0, Big data and so on to structure a robust methodology in which all companies worldwide would be immersed. On the other hand, and hand the main objective of the BI was structured. It allows companies to optimize resources, monitor the fulfillment of the company’s objectives and the ability to make good decisions to obtain better results. It represents a competitive advantage for the company, since it acts as a strategic factor in its organization and responds to the doubts that arise in a business, such as financial control, cost optimization, customer profile analysis, production planning or profitability of a product. Thus, all Business Intelligence systems have in common the following features: Accessibility to information: these tools and techniques guarantee users' access to data, regardless of where they come from. Decision Support: Users are sought to have access to analytics tools that allow them to select and use the data they are most interested in. End-User Orientation: The aim is the independence between the technical knowledge of users and their ability to use these tools.
    VL  - 4
    IS  - 3
    ER  - 

    Copy | Download

Author Information
  • Systems Engineering, National Unified Higher Education Corporation, Bogotá, Colombia

  • Systems Engineering, National Unified Higher Education Corporation, Bogotá, Colombia

  • Systems Engineering, National Unified Higher Education Corporation, Bogotá, Colombia

  • Systems Engineering, National Unified Higher Education Corporation, Bogotá, Colombia

  • Systems Engineering, National Unified Higher Education Corporation, Bogotá, Colombia

  • Sections