Development of a technological platform for data analysis and customer profile according to consumption patterns

Main Article Content

Julian Alberto Patiño-Murillo
Sebastian Londoño Marin
Muñoz Trejos Muñoz-Trejos
Paola Andrea Quintero Echeverri
Lorena Loaiza Botero

Abstract

The article describes the creation of a web sales platform with the implementation of data analysis and visualization tools, and the use of an Artificial Intelligence Chatbot. The aim was to provide a practical solution that would improve customer service and promote business efficiency through informed decision-making at ABBIS SAS. The applied methodology followed a structured approach based on the MVC (Model-View-Controller) model and the ETL (Extraction, Transformation, Load) process. The project was divided into several stages: project structuring, website migration, chatbot development, and integration of data analytics tools. Using the SCRUM methodology, partial deliveries
of the final product were achieved, allowing for continuous adjustments and improvements based on customer needs. The platform enabled cost reduction, faster response times to customer needs, and the fostering of more productive businesses, which, in turn, will strengthen ABBIS’s competitiveness in the market. Finally, the results of this applied research exercise will serve as a reference for other companies to develop their own  technological platforms for data analysis and customer profiling, aligned with consumption patterns. This approach will contribute to the growth and continued success of companies in an increasingly data-oriented environment with changing consumer needs.


How to Cite
Patiño-Murillo, J. A., Londoño Marin, S., Muñoz-Trejos, M. T., Quintero Echeverri, P. A., & Loaiza Botero, L. (2025). Development of a technological platform for data analysis and customer profile according to consumption patterns. Revista Ingenierías Universidad De Medellín, 25(47). https://doi.org/10.22395/rium.v25n47a4

Article Details

References

J. J. Castro-Maldonado, J. A. Londoño-Gallego, S. Londoño-Marin, y J. A. Patiño-Murillo, «Implementation of a technological, information, and communication tool for project management in the network of Tecnoparque, Colombia», J. Phys. Conf. Ser., vol. 1418, n.o 1, p. 012014, dic. 2019, doi: https://doi.org/10.1088/1742-6596/1418/1/012014

M. A. M. Nieto, D. R. R. Blair, C. C. C. Vanegas, y J. A. P. Murillo, «Análisis comparativo del índice de Libertad económica de 2019 entre Colombia y otros países de Suramérica», Rev. CINTEX, vol. 25, n.o 1, Art. n.o 1, dic. 2020, doi: https://doi.org/10.33131/24222208.360

M. Holmlund et al., «Customer experience management in the age of big data analytics: A strategic framework», J. Bus. Res., vol. 116, pp. 356-365, ago. 2020, doi: https://doi.org/10.1016/j.jbusres.2020.01.022

E. S. Oblander, S. Gupta, C. F. Mela, R. S. Winer, y D. R. Lehmann, «The past, present, and future of customer management», Mark. Lett., vol. 31, n.o 2-3, pp. 125-136, sep. 2020, doi: https://doi.org/10.1007/s11002-020-09525-9.

M. Anshari, M. N. Almunawar, S. A. Lim, y A. Al-Mudimigh, «Customer relationship management and big data enabled: Personalization & customization of services», Appl. Comput. Inform., vol. 15, n.o 2, pp. 94-101, jul. 2019, doi: https://doi.org/10.1016/j.aci.2018.05.004.

H. Gil-Gomez, V. Guerola-Navarro, R. Oltra-Badenes, y J. A. Lozano-Quilis, «Customer relationship management: digital transformation and sustainable business model innovation», Econ. Res.-Ekon. Istraživanja, vol. 33, n.o 1, pp. 2733-2750, ene. 2020, doi: 10.1080/1331677X.2019.1676283.

R. Varadarajan, «Customer information resources advantage, marketing strategy and business performance: A market resources based view», Ind. Mark. Manag., vol. 89, pp. 89-97, ago. 2020, doi: https://doi.org/10.1016/j.indmarman.2020.03.003

J. C. Acosta-Prado y A. A. Tafur-Mendoza, «Influence of information and communication technologies on customer satisfaction and increase in the number of customers», VINE J. Inf. Knowl. Manag. Syst., vol. 53, n.o 3, pp. 377-386, abr. 2023, doi: https://doi.org/10.1108/VJIKMS-11-2020-0207

M. M. Mariani y S. Fosso Wamba, «Exploring how consumer goods companies innovate in the digital age: The role of big data analytics companies», J. Bus. Res., vol. 121, pp. 338-352, dic. 2020, doi: https://doi.org/10.1016/j.jbusres.2020.09.012

A. Følstad et al., «Future directions for chatbot research: an interdisciplinary research agenda», Computing, vol. 103, n.o 12, pp. 2915-2942, dic. 2021, doi: https://doi.org/10.1007/s00607-021-01016-7

J. Cordero, L. Barba-Guaman, y F. Guamán, «Use of chatbots for customer service in MSMEs», Appl. Comput. Inform., nov. 2022, doi: https://doi.org/10.1108/ACI-06-2022-0148

M. A. Selamat y N. A. Windasari, «Chatbot for SMEs: Integrating customer and business owner perspectives», Technol. Soc., vol. 66, p. 101685, ago. 2021, doi: https://doi.org/10.1016/j.techsoc.2021.101685

C. Adarve Gómez, D. A. Castillo Carvajal, E. J. Restrepo Zapata, y H. Villar-Vega, «A review of virtual reality videogames for job-training applications», Rev. CINTEX, vol. 24, n.o 1, pp. 64-70, dic. 2019, doi: https://doi.org/10.33131/24222208.346

S. M. Velásquez, J. D. Vahos Montoya, M. E. Gómez Adasme, E. J. Restrepo Zapata, A. A. Pino, y S. Londoño Marín, «Una revisión comparativa de la literatura acerca de metodologías tradicionales y modernas de desarrollo de software», Rev. CINTEX, vol. 24, n.o 2, pp. 13-23, dic. 2019, doi: https://doi.org/10.33131/24222208.334

A. Abdellatif, K. Badran, D. E. Costa, y E. Shihab, «A Comparison of Natural Language Understanding Platforms for Chatbots in Software Engineering», IEEE Trans. Softw. Eng., vol. 48, n.o 8, pp. 3087-3102, ago. 2022, doi: https://doi.org/10.1109/TSE.2021.3078384

S. VELASQUEZ, J. D. VAHOS, C. LOPEZ, M. E. GOMEZ, J. LONDOÑO, y S. PATIÑO, «El rol de las normas en la acreditación y certificación de pruebas de software», Rev. Espac., vol. 39, n.o 50, p. 17, 2018.

H. Edison, X. Wang, y K. Conboy, «Comparing Methods for Large-Scale Agile Software Development: A Systematic Literature Review», IEEE Trans. Softw. Eng., vol. 48, n.o 8, pp. 2709-2731, ago. 2022, doi: https://doi.org/10.1109/TSE.2021.3069039

D. Ciric, B. Lalic, D. Gracanin, N. Tasic, M. Delic, y N. Medic, «Agile vs. Traditional Approach in Project Management: Strategies, Challenges and Reasons to Introduce Agile», Procedia Manuf., vol. 39, pp. 1407-1414, 2019, doi: https://doi.org/10.1016/j.promfg.2020.01.314

A. P. Chaves y M. A. Gerosa, «How Should My Chatbot Interact? A Survey on Social Characteristics in Human–Chatbot Interaction Design», Int. J. Human–Computer Interact., vol. 37, n.o 8, pp. 729-758, may 2021, doi: https://doi.org/10.1080/10447318.2020.1841438

F. Brandan, D. Pandolfi, y A. Villagra, «Sistemas conversacionales aplicados a la gobernanza Asistencia automatizada al público», Inf. Científicos Téc. - UNPA, vol. 14, n.o 3, Art. n.o 3, dic. 2022, doi: https://doi.org/10.22305/ict-unpa.v14.n3.894

S. Perez-Soler, S. Juarez-Puerta, E. Guerra, y J. De Lara, «Choosing a Chatbot Development Tool», IEEE Softw., vol. 38, n.o 4, pp. 94-103, jul. 2021, doi: https://doi.org/10.1109/MS.2020.3030198

M. A. Kuhail, N. Alturki, S. Alramlawi, y K. Alhejori, «Interacting with educational chatbots: A systematic review», Educ. Inf. Technol., vol. 28, n.o 1, pp. 973-1018, ene. 2023, doi: https://doi.org/10.1007/s10639-022-11177-3

G. A. Santos, G. G. De Andrade, G. R. S. Silva, F. C. M. Duarte, J. P. J. D. Costa, y R. T. De Sousa, «A Conversation-Driven Approach for Chatbot Management», IEEE Access, vol. 10, pp. 8474-8486, 2022, doi: https://doi.org/10.1109/ACCESS.2022.3143323

N. K. G. M. Santacruz, «Asistente conversacional virtual (chatbots) para ser incluido en el portal de la Subsecretaría de Estado de Tributación como mecanismo de asistencia al contribuyente», Rev. Cienc. Empres. Tribut. Comer. Adm., vol. 1, n.o 2, Art. n.o 2, 2022, doi: https://doi.org/10.58287/rcfotriem-1-2-2022-22

M. Baez, F. Daniel, F. Casati, y B. Benatallah, «Chatbot Integration in Few Patterns», IEEE Internet Comput., vol. 25, n.o 3, pp. 52-59, may 2021, doi: https://doi.org/10.1109/MIC.2020.3024605

E. W. T. Ngai, M. C. M. Lee, M. Luo, P. S. L. Chan, y T. Liang, «An intelligent knowledge-based chatbot for customer service», Electron. Commer. Res. Appl., vol. 50, p. 101098, nov. 2021, doi: https://doi.org/10.1016/j.elerap.2021.101098

M. R. King, «The Future of AI in Medicine: A Perspective from a Chatbot», Ann. Biomed. Eng., vol. 51, n.o 2, pp. 291-295, feb. 2023, doi: https://doi.org/10.1007/s10439-022-03121-w

D. Guaman, S. Delgado, y J. Perez, «Classifying Model-View-Controller Software Applications Using Self-Organizing Maps», IEEE Access, vol. 9, pp. 45201-45229, 2021, doi: https://doi.org/10.1109/ACCESS.2021.3066348

S. P. Ong et al., «The Materials Application Programming Interface (API): A simple, flexible and efficient API for materials data based on REpresentational State Transfer (REST) principles», Comput. Mater. Sci., vol. 97, pp. 209-215, feb. 2015, doi: https://doi.org/10.1016/j.commatsci.2014.10.037

ClimaxWeb, «Maxbot - Chatbot Builder WordPress Plugin», CodeCanyon. Accedido: 19 de octubre de 2023. [En línea]. Disponible en: https://codecanyon.net/item/maxbot-chatbot-builder-wordpress-plugin/25237469

B. M. Kowal, T. R. Schreier, J. T. Dauer, y T. Helikar, «Programmatic access to logical models in the Cell Collective modeling environment via a REST API», Biosystems, vol. 139, pp. 12-16, ene. 2016, doi: https://doi.org/10.1016/j.biosystems.2015.11.005

H. Lei, F. Ganjeizadeh, P. K. Jayachandran, y P. Ozcan, «A statistical analysis of the effects of Scrum and Kanban on software development projects», Robot. Comput.-Integr. Manuf., vol. 43, pp. 59-67, feb. 2017, doi: https://doi.org/10.1016/j.rcim.2015.12.001

WordPress, «WordPress, Your Way», WordPress.com. Accedido: 20 de octubre de 2023. [En línea]. Disponible en: https://wordpress.com/es/

J. Lin, M. Sayagh, y A. E. Hassan, «The Co-evolution of the WordPress Platform and Its Plugins», ACM Trans. Softw. Eng. Methodol., vol. 32, n.o 1, pp. 1-24, ene. 2023, doi: https://doi.org/10.1145/3533700

Microsoft, «Power BI», Consiga que sus datos tengan un efecto inmediato. Accedido: 20 de octubre de 2023. [En línea]. Disponible en: https://powerbi.microsoft.com/es-es/

Author Biographies

Julian Alberto Patiño-Murillo, Institución Universitaria Pascual Bravo

Institución Universitaria Pascual Bravo, Medellín, Colombia. E-mail: julian.patino@pascualbravo.edu.co Orcid: https://orcid.org/0000-0001-8914-2838

Sebastian Londoño Marin, SENA

Servicio Nacional de Aprendizaje SENA, Medellín, Colombia. E-mail slondonom@sena.edu.co.
Orcid: https://orcid.org/0000-0001-5437-4495

Muñoz Trejos Muñoz-Trejos, roccap sas

roccap sas, Medellín, Colombia. E-mail: cto@roccap.co. Orcid: https://orcid.org/0009-0008-1556-8551

Paola Andrea Quintero Echeverri, abbis sas

abbis sas, Medellín, Colombia. E-mail: administrativo@abbis.co. Orcid: https://orcid.
org/0009-0006-9555-3354

Lorena Loaiza Botero, roccap sas

roccap sas, Medellín, Colombia. E-mail: seguimiento@roccap.co. Orcid: https://orcid.
org/0009-0007-6808-3964