Correo Electrónico
DNINFOA - SIA
Bibliotecas
Convocatorias
Identidad U.N.
Publicado
Use of a business intelligence framework in the management of the quality of the electricity supply in small and medium-sized companies
Uso de un marco de inteligencia empresarial en la gestión de la calidad del suministro eléctrico en pequeñas y medianas empresas
DOI:
https://doi.org/10.15446/dyna.v89n221.99085Palabras clave:
analytics; business intelligence; clustering; CRISP-DM; data mining. (en)analítica; inteligencia de negocios; agrupamiento; CRISP-DM; minería de datos. (es)
Descargas
This work shows a method based on Business Intelligence and its application for solving issues and problems in small and medium industries. In this matter, methodologies used by specialists were investigated: three methods were chosen and evaluated, and, of them, the CRISP-DM (Cross-Industry Standard Process for Data Mining) methodology was used as a reference. Making an unconventional use of a commercial BI platform, the methodology was applied to a real case study: an agro-industrial company. After the application of the methodology and the descriptive, diagnostic and prescriptive analyzes, information and knowledge were found that allowed to propose the deployment of corrective measures that will improve the management of the company's electricity supply. This showed that these tools not only have application in commercial matters but also in the management of the electricity supply and, therefore, in the organizational performance of the company.
Este trabajo muestra un método basado en Business Intelligence y su aplicación para la resolución de incidencias y problemas en la pequeña y mediana industria. En este sentido, se investigaron las metodologías utilizadas por los especialistas: se eligieron y evaluaron tres métodos y, de ellos, se tomó como referencia la metodología CRISP-DM (Cross-Industry Standard Process for Data Mining). Haciendo un uso no convencional de una plataforma de BI comercial, la metodología se aplicó a un caso de estudio real: una empresa agroindustrial. Tras la aplicación de la metodología y los análisis descriptivos, diagnósticos y prescriptivos, se encontraron informaciones y conocimientos que permitieron proponer el despliegue de medidas correctoras que mejorarán la gestión del suministro eléctrico de la empresa. Esto demostró que estas herramientas no solo tienen aplicación en materia comercial sino también en la gestión del suministro eléctrico y, por tanto, en el desempeño organizacional de la empresa.
Referencias
Wixom, B. and Watson, H., The BI-Based organization, International Journal of Business Intelligence Research, 1(1), pp. 13-28, 2010. DOI: https://doi.org/10.4018/jbir.2010071702
Muntean, M., Dănăiaţă, D., Hurbean, L. and Jude, C., A business intelligence & analytics framework for clean and affordable energy data analysis, Sustain, 13(2), pp.1-25, 2021. DOI: https://doi.org/10.3390/su13020638
Schuh, G., Reinhart, G., Prote, J.P., et al., Data mining definitions and applications for the management of production complexity. In: Procedia CIRP, 81, pp. 874-879, 2019. DOI: https://doi.org/10.1016/j.procir.2019.03.217
Arce, D., Lima, F., Orellana-Cordero, M.P., Ortega, J., Sellers, C. and Ortega, P., Discovering behavioral patterns among air pollutants: a data mining approach, Enfoque UTE, 9(4), pp. 168-179, 2018. DOI: https://doi.org/10.29019/enfoqueute.v9n4.411
Upadhyay, N., CABology: value of cloud, Analytics and Big Data Trio Wave, Springer, Singapore, 2018. DOI: https://doi.org/10.1007/978-981-10-8675-5
Zhang, Y., Huang, T. and Bompard, E.F., Big data analytics in smart grids: a review, Energy Informatics, 1(1), pp. 1-24, 2018. DOI: https://doi.org/10.1186/s42162-018-0007-5
Hossain, E., Khan, I., Un-Noor, F., Sikander, S.S. and Sunny, M.S.H., Application of Big Data and Machine Learning in Smart Grid, and associated security concerns: a review, IEEE Access, 7, pp.13960-13988, 2019. DOI: https://doi.org/10.1109/ACCESS.2019.2894819
Bhattarai, B.P., Paudyal, S., Luo, Y., et al., Big data analytics in smart grids: state‐of‐the‐art, challenges, opportunities, and future directions, IET Smart Grid, 2(2), pp. 141-154, 2019. DOI: https://doi.org/10.1049/iet-stg.2018.0261
Alavikia, Z. and Shabro, M., A comprehensive layered approach for implementing internet of things-enabled smart grid: a survey, Digital Communications and Networks, art. in press, Feb, 2022. DOI: https://doi.org/10.1016/j.dcan.2022.01.002
Congreso de la República del Perú, Proyecto de Ley N° 4335, Ley que modifica el Marco Jurídico Eléctrico y autoriza a elaborar el Texto Único Ordenado de las normas que regulan las actividades eléctricas, [en línea]. Disponible en: https://www2.congreso.gob.pe, 2010
Ministerio de Energía y Minas del Perú, Planeamiento estratégico hacia Smart Grid – herramientas, [en línea]. Disponible en: http://eficienciaenergetica.minem.gob.pe//es-pe/noticia/, 2021
Vásquez-Cordano, A., Aspectos económicos de la implementación de redes inteligentes (Smart Grids) en el sector eléctrico peruano- Documento de Trabajo No 38, Perú, Gerencia de Políticas y Análisis Económico – Osinergmin, Perú, 2017, 46 P.
Asghari, P., Rahmani, A.M. and Javadi, H.H.S., Internet of things applications: a systematic review, Computer Networks, 148, pp. 241-261, 2019. DOI: https://doi.org/10.1016/j.comnet.2018.12.008
Lai, C.F., Chien, W.C., Yang, L.T. and Qiang, W., LSTM and edge computing for big data feature recognition of industrial electrical equipment, IEEE Transactions on Industrial Informatics, 15(4), pp. 2469-2477, 2019. DOI: https://doi.org/10.1109/TII.2019.2892818
Ridi, A., Gisler, C. and Hennebert, J., A survey on intrusive load monitoring for appliance recognition. In: Proceedings - International Conference on Pattern Recognition. Institute of Electrical and Electronics Engineers Inc., pp. 3702-3707, 2014. DOI: https://doi.org/10.1109/ICPR.2014.636
Livera, A., Theristis, M., Makrides, G. and Georghiou, G.E., Recent advances in failure diagnosis techniques based on performance data analysis for grid-connected photovoltaic systems, Renewable Energy, 133, pp. 126-143, 2019. DOI: https://doi.org/10.1016/j.renene.2018.09.101
Arghandeh, R. and Zhou, Y., Big Data application in power systems. Elsevier, [online]. 2017. Available at: https://www.elsevier.com/books/big-data-application-in-power-systems/arghandeh/978-0-12-811968-6
Al-Turjman, F., Altrjman, C., Din, S. and Paul, A., Energy monitoring in IoT-based ad hoc networks: an overview, Computer & Electrical Engineering, 76, pp. 133-142, 2019. DOI: https://doi.org/10.1016/j.compeleceng.2019.03.013
Ramesh, B. and Ramakrishna, A., Unified business intelligence ecosystem: a project management approach to address business intelligence challenges. In: PICMET 2018 - Portland International Conference on Management of Engineering and Technology: managing technological entrepreneurship: the engine for economic growth, Proceedings, Institute of Electrical and Electronics Engineers Inc., 2018. DOI: https://doi.org/10.23919/PICMET.2018.8481744
Tumpa, Z.N., Saifuzzaman, M., Rabby, S.K.F., Crearie, L. and Stansfield, M., Understanding business intelligence in the context of mental healthcare sector of Bangladesh for improving health services, In: IEEE Region 10 Humanitarian Technology Conference, R10-HTC, Vol. 2020-Decem. Institute of Electrical and Electronics Engineers Inc., 2020. DOI: https://doi.org/10.1109/R10-HTC49770.2020.9357023
Phillips-Wren, G., Daly, M. and Burstein, F., Reconciling business intelligence, analytics and decision support systems: more data, deeper insight, Decision Support System, 146, art. 113560, 2021. DOI: https://doi.org/10.1016/j.dss.2021.113560
Kimball, R. and Ross, M., The Data warehouse toolkit: the definitive guide to dimensional modeling, Wiley, 3rd Ed., Indianapolis, USA, 2013.
Ramos, S., Mejores soluciones con Power BI siguiendo estos 6 pasos [en línea], 2021. [Consultado: Mayo 30 de 2021]. Disponible en: https://www.elfuturodelosdatos.com/power-bi-6-pasos-para-crear-mejores-soluciones/
Mishra, B.K., Hazra, D., Tarannum, K. and Kumar, M., Business intelligence using Data Mining techniques and business analytics, In: Proceedings of the 5th International Conference on System Modeling and Advancement in Research Trends, SMART 2016. Institute of Electrical and Electronics Engineers Inc., pp. 84-89, 2017. DOI: https://doi.org/10.1109/SYSMART.2016.7894496
Shearer, C., The CRISP-DM Model: the new blueprint for data mining, Journal of Data Warehouse, 5(4), pp. 13-22, 2000.
Ali, M., Ali, R., Khan, W.A., et al., A Data-Driven knowledge acquisition system: an end-to-end knowledge engineering process for generating production rules, IEEE Access, 6, pp. 15587-15607, 2018. DOI: https://doi.org/10.1109/ACCESS.2018.2817022
Huber, S., Wiemer, H., Schneider, D. and Ihlenfeldt, S., DMME: data mining methodology for engineering applications – a holistic extension to the CRISP-DM model, Procedia CIRP, 79, pp. 403-408, 2019. DOI: https://doi.org/10.1016/j.procir.2019.02.106
Shi-Nash, A. and Hardoon, D.R., Data analytics and predictive analytics in the era of big data. In: Internet of Things and Data Analytics Handbook, pp. 329-345, Wiley, 2017. DOI: https://doi.org/|10.1002/9781119173601.ch19
Martínez, F., Marínez, F. and Jacinto, E., Strategy for the selection of reactive power in an industrial installation using K-Means clustering. In: Tan, Y. and Shi, Y., (eds), Data Mining and Big Data. DMBD 2019. Communications in Computer and Information Science, 1071, pp.146-153, Springer, Singapore, 2019. DOI: https://doi.org/10.1007/978-981-32-9563-6_15
Cómo citar
IEEE
ACM
ACS
APA
ABNT
Chicago
Harvard
MLA
Turabian
Vancouver
Descargar cita
CrossRef Cited-by
1. Md. Nur Alam, Syed Shamim Hasan, Syed Salman Haider, Md. Noor Un Nabi, Imtiaz Masroor, Sayma Mehezabin Bably. (2026). Pushing boundaries: market intelligence elevating SMEs export intensity through vibrant ecosystem. Review of International Business and Strategy, 36(1), p.33. https://doi.org/10.1108/RIBS-11-2024-0135.
2. Karen Stefania Astudillo Jara, Alex Vicente Suarez Jaya, Gabriela Isabel Araujo Ochoa. (2024). Generación de estrategias basados en business intelligence para la competitividad en empresas de distribución de material eléctrico. Visionario Digital, 8(3), p.6. https://doi.org/10.33262/visionariodigital.v8i3.3066.
3. Tao Wang, Xiaozhe Hu. (2024). A Multi-Objective Optimization Method for Power Material Supply Chain Network Based on HBA Algorithm. 2024 3rd International Conference on Energy and Electrical Power Systems (ICEEPS). , p.1369. https://doi.org/10.1109/ICEEPS62542.2024.10693075.
4. Claudia Spilotro, Giustina Secundo, Nicola Magaletti, Ettore Zini, Chiara Tognon, Angelo Zerega. (2025). Data-Driven ESG KPIs Optimization: A Framework for Smart Buildings and Smart Factories. Sustainability, 17(23), p.10837. https://doi.org/10.3390/su172310837.
5. Ornela Isbela Silva Zierz, Alberto Casado Lordsleem Junior. (2026). Business Intelligence Tools in Organizations with a Focus on Power BI Applications in Civil Construction: A Systematic Literature Review. Buildings, 16(4), p.869. https://doi.org/10.3390/buildings16040869.
6. Pajares-Delgado Ariana, Inche-Huaringa Damaris, Zarate-Mollehuara Nicolle, Villena-Presentación Ricardo. (2024). Management, Tourism and Smart Technologies. Lecture Notes in Networks and Systems. 1190, p.497. https://doi.org/10.1007/978-3-031-74825-7_44.
7. Cristian Perales-Domínguez, Jeison Eli Sánchez-Calle, Danny Lévano-Rodriguez, Katherine Gallegos-Carrillo. (2024). Metodologías para la construcción de soluciones de inteligencia de negocios . Revista científica de sistemas e informática, 4(1), p.e612. https://doi.org/10.51252/rcsi.v4i1.612.
Dimensions
PlumX
Visitas a la página del resumen del artículo
Descargas
Licencia
Esta obra está bajo una licencia internacional Creative Commons Atribución-NoComercial-SinDerivadas 4.0.
El autor o autores de un artículo aceptado para publicación en cualquiera de las revistas editadas por la facultad de Minas cederán la totalidad de los derechos patrimoniales a la Universidad Nacional de Colombia de manera gratuita, dentro de los cuáles se incluyen: el derecho a editar, publicar, reproducir y distribuir tanto en medios impresos como digitales, además de incluir en artículo en índices internacionales y/o bases de datos, de igual manera, se faculta a la editorial para utilizar las imágenes, tablas y/o cualquier material gráfico presentado en el artículo para el diseño de carátulas o posters de la misma revista.
