Uso de un marco de inteligencia empresarial en la gestión de la calidad del suministro eléctrico en pequeñas y medianas empresas

Publicado

2022-04-25

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

Palabras clave:

analytics; business intelligence; clustering; CRISP-DM; data mining. (en)
analítica; inteligencia de negocios; agrupamiento; CRISP-DM; minería de datos. (es)

Descargas

Autores/as

Redy Risco-Ramos Universidad de Piura, Piura, Perú https://orcid.org/0000-0002-3491-6020
Daniel Pérez-Aguilar Universidad de Piura, Piura, Perú https://orcid.org/0000-0003-4514-2873
Luis Casaverde-Pacherrez Universidad de Piura, Piura, Perú https://orcid.org/0000-0003-4037-1802
Edilberto Vásquez-Díaz Universidad de Piura, Piura, Perú https://orcid.org/0000-0003-0413-1625

Resumen (en)
Resumen (es)

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.

Descargas

Los datos de descargas todavía no están disponibles.

Citas

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

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.