Business Intelligence to Optimize Decision-Making in a Telecommunication Company

Descripción del Articulo

This article presents an implementation of business intelligence in the sales area with the objective of optimizing decision-making in a telecommunications company because there is not good quality of reports and satisfaction in the use of reports is not suitable for correct decision-making due to t...

Descripción completa

Detalles Bibliográficos
Autores: Cano Lengua, Miguel Angel, Mallma Trujillo, Ronny Elmer, Moquillaza Henríquez, Santiago Domingo
Formato: artículo
Fecha de Publicación:2023
Institución:Universidad Tecnológica del Perú
Repositorio:UTP-Institucional
Lenguaje:inglés
OAI Identifier:oai:repositorio.utp.edu.pe:20.500.12867/9082
Enlace del recurso:https://hdl.handle.net/20.500.12867/9082
https://doi.org/10.14445/22315381/IJETT-V71I8P208
Nivel de acceso:acceso abierto
Materia:Business intelligence
Decision making
Telecommunications
Ralph Kimball
ISO/IEC 25010
https://purl.org/pe-repo/ocde/ford#2.02.04
id UTPD_e9be618f866aedeeaddd952321f54b0e
oai_identifier_str oai:repositorio.utp.edu.pe:20.500.12867/9082
network_acronym_str UTPD
network_name_str UTP-Institucional
repository_id_str 4782
dc.title.es_PE.fl_str_mv Business Intelligence to Optimize Decision-Making in a Telecommunication Company
title Business Intelligence to Optimize Decision-Making in a Telecommunication Company
spellingShingle Business Intelligence to Optimize Decision-Making in a Telecommunication Company
Cano Lengua, Miguel Angel
Business intelligence
Decision making
Telecommunications
Ralph Kimball
ISO/IEC 25010
https://purl.org/pe-repo/ocde/ford#2.02.04
title_short Business Intelligence to Optimize Decision-Making in a Telecommunication Company
title_full Business Intelligence to Optimize Decision-Making in a Telecommunication Company
title_fullStr Business Intelligence to Optimize Decision-Making in a Telecommunication Company
title_full_unstemmed Business Intelligence to Optimize Decision-Making in a Telecommunication Company
title_sort Business Intelligence to Optimize Decision-Making in a Telecommunication Company
author Cano Lengua, Miguel Angel
author_facet Cano Lengua, Miguel Angel
Mallma Trujillo, Ronny Elmer
Moquillaza Henríquez, Santiago Domingo
author_role author
author2 Mallma Trujillo, Ronny Elmer
Moquillaza Henríquez, Santiago Domingo
author2_role author
author
dc.contributor.author.fl_str_mv Cano Lengua, Miguel Angel
Mallma Trujillo, Ronny Elmer
Moquillaza Henríquez, Santiago Domingo
dc.subject.es_PE.fl_str_mv Business intelligence
Decision making
Telecommunications
Ralph Kimball
ISO/IEC 25010
topic Business intelligence
Decision making
Telecommunications
Ralph Kimball
ISO/IEC 25010
https://purl.org/pe-repo/ocde/ford#2.02.04
dc.subject.ocde.es_PE.fl_str_mv https://purl.org/pe-repo/ocde/ford#2.02.04
description This article presents an implementation of business intelligence in the sales area with the objective of optimizing decision-making in a telecommunications company because there is not good quality of reports and satisfaction in the use of reports is not suitable for correct decision-making due to the lengthy time it takes to do it manually, in addition, the quality is not optimal for data analysis. A Data Mart was developed under the Ralph Kimball methodology adapted to the agile Scrum methodology. Finally, software quality tests were carried out for BI implementation according to ISO/IEC 25010. The expected results were obtained regarding the improvement in report generation time of 97.22 %, an improvement in the data quality of the reports by 29.08%, an improvement in user satisfaction by 40% and finally, the perception in decision-making was optimized by 38.66%, according to the results it was concluded that business intelligence provides notable benefits regarding the quality of information, report generation time to make optimal decisions and improvement of decision making. For the telecommunications scenario, this research is important since, in the literature review, it is not observed papers that narrate the implementation of a business intelligence solution applied to the telecommunications sector.
publishDate 2023
dc.date.accessioned.none.fl_str_mv 2024-06-10T17:02:30Z
dc.date.available.none.fl_str_mv 2024-06-10T17:02:30Z
dc.date.issued.fl_str_mv 2023
dc.type.es_PE.fl_str_mv info:eu-repo/semantics/article
dc.type.version.es_PE.fl_str_mv info:eu-repo/semantics/publishedVersion
format article
status_str publishedVersion
dc.identifier.issn.none.fl_str_mv 2231–5381
dc.identifier.uri.none.fl_str_mv https://hdl.handle.net/20.500.12867/9082
dc.identifier.journal.es_PE.fl_str_mv International Journal of Engineering Trends and Technology
dc.identifier.doi.none.fl_str_mv https://doi.org/10.14445/22315381/IJETT-V71I8P208
identifier_str_mv 2231–5381
International Journal of Engineering Trends and Technology
url https://hdl.handle.net/20.500.12867/9082
https://doi.org/10.14445/22315381/IJETT-V71I8P208
dc.language.iso.es_PE.fl_str_mv eng
language eng
dc.relation.ispartofseries.none.fl_str_mv International Journal of Engineering Trends and Technology;Vol. 71, No. 8
dc.rights.es_PE.fl_str_mv info:eu-repo/semantics/openAccess
dc.rights.uri.es_PE.fl_str_mv http://creativecommons.org/licenses/by-nc-nd/4.0/
eu_rights_str_mv openAccess
rights_invalid_str_mv http://creativecommons.org/licenses/by-nc-nd/4.0/
dc.format.es_PE.fl_str_mv application/pdf
dc.publisher.es_PE.fl_str_mv Seventh Sense Research Group
dc.publisher.country.es_PE.fl_str_mv IN
dc.source.es_PE.fl_str_mv Repositorio Institucional - UTP
Universidad Tecnológica del Perú
dc.source.none.fl_str_mv reponame:UTP-Institucional
instname:Universidad Tecnológica del Perú
instacron:UTP
instname_str Universidad Tecnológica del Perú
instacron_str UTP
institution UTP
reponame_str UTP-Institucional
collection UTP-Institucional
bitstream.url.fl_str_mv http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/2/license.txt
http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/1/M.Cano_Articulo_2023.pdf
http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/3/M.Cano_Articulo_2023.pdf.txt
http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/4/M.Cano_Articulo_2023.pdf.jpg
bitstream.checksum.fl_str_mv 8a4605be74aa9ea9d79846c1fba20a33
8dd323790f05cd2cbd6e8dab5112f968
c57b9e36e6abd47581d859b3bb0d258f
ffd9e8c33e7c319488762ae1776d4249
bitstream.checksumAlgorithm.fl_str_mv MD5
MD5
MD5
MD5
repository.name.fl_str_mv Repositorio Institucional de la Universidad Tecnológica del Perú
repository.mail.fl_str_mv repositorio@utp.edu.pe
_version_ 1817984954506674176
spelling Cano Lengua, Miguel AngelMallma Trujillo, Ronny ElmerMoquillaza Henríquez, Santiago Domingo2024-06-10T17:02:30Z2024-06-10T17:02:30Z20232231–5381https://hdl.handle.net/20.500.12867/9082International Journal of Engineering Trends and Technologyhttps://doi.org/10.14445/22315381/IJETT-V71I8P208This article presents an implementation of business intelligence in the sales area with the objective of optimizing decision-making in a telecommunications company because there is not good quality of reports and satisfaction in the use of reports is not suitable for correct decision-making due to the lengthy time it takes to do it manually, in addition, the quality is not optimal for data analysis. A Data Mart was developed under the Ralph Kimball methodology adapted to the agile Scrum methodology. Finally, software quality tests were carried out for BI implementation according to ISO/IEC 25010. The expected results were obtained regarding the improvement in report generation time of 97.22 %, an improvement in the data quality of the reports by 29.08%, an improvement in user satisfaction by 40% and finally, the perception in decision-making was optimized by 38.66%, according to the results it was concluded that business intelligence provides notable benefits regarding the quality of information, report generation time to make optimal decisions and improvement of decision making. For the telecommunications scenario, this research is important since, in the literature review, it is not observed papers that narrate the implementation of a business intelligence solution applied to the telecommunications sector.Campus Lima Centroapplication/pdfengSeventh Sense Research GroupINInternational Journal of Engineering Trends and Technology;Vol. 71, No. 8info:eu-repo/semantics/openAccesshttp://creativecommons.org/licenses/by-nc-nd/4.0/Repositorio Institucional - UTPUniversidad Tecnológica del Perúreponame:UTP-Institucionalinstname:Universidad Tecnológica del Perúinstacron:UTPBusiness intelligenceDecision makingTelecommunicationsRalph KimballISO/IEC 25010https://purl.org/pe-repo/ocde/ford#2.02.04Business Intelligence to Optimize Decision-Making in a Telecommunication Companyinfo:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionLICENSElicense.txtlicense.txttext/plain; charset=utf-81748http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/2/license.txt8a4605be74aa9ea9d79846c1fba20a33MD52ORIGINALM.Cano_Articulo_2023.pdfM.Cano_Articulo_2023.pdfapplication/pdf767200http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/1/M.Cano_Articulo_2023.pdf8dd323790f05cd2cbd6e8dab5112f968MD51TEXTM.Cano_Articulo_2023.pdf.txtM.Cano_Articulo_2023.pdf.txtExtracted texttext/plain60705http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/3/M.Cano_Articulo_2023.pdf.txtc57b9e36e6abd47581d859b3bb0d258fMD53THUMBNAILM.Cano_Articulo_2023.pdf.jpgM.Cano_Articulo_2023.pdf.jpgGenerated Thumbnailimage/jpeg23009http://repositorio.utp.edu.pe/bitstream/20.500.12867/9082/4/M.Cano_Articulo_2023.pdf.jpgffd9e8c33e7c319488762ae1776d4249MD5420.500.12867/9082oai:repositorio.utp.edu.pe:20.500.12867/90822024-06-11 03:06:12.822Repositorio Institucional de la Universidad Tecnológica del Perúrepositorio@utp.edu.peTk9URTogUExBQ0UgWU9VUiBPV04gTElDRU5TRSBIRVJFClRoaXMgc2FtcGxlIGxpY2Vuc2UgaXMgcHJvdmlkZWQgZm9yIGluZm9ybWF0aW9uYWwgcHVycG9zZXMgb25seS4KCk5PTi1FWENMVVNJVkUgRElTVFJJQlVUSU9OIExJQ0VOU0UKCkJ5IHNpZ25pbmcgYW5kIHN1Ym1pdHRpbmcgdGhpcyBsaWNlbnNlLCB5b3UgKHRoZSBhdXRob3Iocykgb3IgY29weXJpZ2h0Cm93bmVyKSBncmFudHMgdG8gRFNwYWNlIFVuaXZlcnNpdHkgKERTVSkgdGhlIG5vbi1leGNsdXNpdmUgcmlnaHQgdG8gcmVwcm9kdWNlLAp0cmFuc2xhdGUgKGFzIGRlZmluZWQgYmVsb3cpLCBhbmQvb3IgZGlzdHJpYnV0ZSB5b3VyIHN1Ym1pc3Npb24gKGluY2x1ZGluZwp0aGUgYWJzdHJhY3QpIHdvcmxkd2lkZSBpbiBwcmludCBhbmQgZWxlY3Ryb25pYyBmb3JtYXQgYW5kIGluIGFueSBtZWRpdW0sCmluY2x1ZGluZyBidXQgbm90IGxpbWl0ZWQgdG8gYXVkaW8gb3IgdmlkZW8uCgpZb3UgYWdyZWUgdGhhdCBEU1UgbWF5LCB3aXRob3V0IGNoYW5naW5nIHRoZSBjb250ZW50LCB0cmFuc2xhdGUgdGhlCnN1Ym1pc3Npb24gdG8gYW55IG1lZGl1bSBvciBmb3JtYXQgZm9yIHRoZSBwdXJwb3NlIG9mIHByZXNlcnZhdGlvbi4KCllvdSBhbHNvIGFncmVlIHRoYXQgRFNVIG1heSBrZWVwIG1vcmUgdGhhbiBvbmUgY29weSBvZiB0aGlzIHN1Ym1pc3Npb24gZm9yCnB1cnBvc2VzIG9mIHNlY3VyaXR5LCBiYWNrLXVwIGFuZCBwcmVzZXJ2YXRpb24uCgpZb3UgcmVwcmVzZW50IHRoYXQgdGhlIHN1Ym1pc3Npb24gaXMgeW91ciBvcmlnaW5hbCB3b3JrLCBhbmQgdGhhdCB5b3UgaGF2ZQp0aGUgcmlnaHQgdG8gZ3JhbnQgdGhlIHJpZ2h0cyBjb250YWluZWQgaW4gdGhpcyBsaWNlbnNlLiBZb3UgYWxzbyByZXByZXNlbnQKdGhhdCB5b3VyIHN1Ym1pc3Npb24gZG9lcyBub3QsIHRvIHRoZSBiZXN0IG9mIHlvdXIga25vd2xlZGdlLCBpbmZyaW5nZSB1cG9uCmFueW9uZSdzIGNvcHlyaWdodC4KCklmIHRoZSBzdWJtaXNzaW9uIGNvbnRhaW5zIG1hdGVyaWFsIGZvciB3aGljaCB5b3UgZG8gbm90IGhvbGQgY29weXJpZ2h0LAp5b3UgcmVwcmVzZW50IHRoYXQgeW91IGhhdmUgb2J0YWluZWQgdGhlIHVucmVzdHJpY3RlZCBwZXJtaXNzaW9uIG9mIHRoZQpjb3B5cmlnaHQgb3duZXIgdG8gZ3JhbnQgRFNVIHRoZSByaWdodHMgcmVxdWlyZWQgYnkgdGhpcyBsaWNlbnNlLCBhbmQgdGhhdApzdWNoIHRoaXJkLXBhcnR5IG93bmVkIG1hdGVyaWFsIGlzIGNsZWFybHkgaWRlbnRpZmllZCBhbmQgYWNrbm93bGVkZ2VkCndpdGhpbiB0aGUgdGV4dCBvciBjb250ZW50IG9mIHRoZSBzdWJtaXNzaW9uLgoKSUYgVEhFIFNVQk1JU1NJT04gSVMgQkFTRUQgVVBPTiBXT1JLIFRIQVQgSEFTIEJFRU4gU1BPTlNPUkVEIE9SIFNVUFBPUlRFRApCWSBBTiBBR0VOQ1kgT1IgT1JHQU5JWkFUSU9OIE9USEVSIFRIQU4gRFNVLCBZT1UgUkVQUkVTRU5UIFRIQVQgWU9VIEhBVkUKRlVMRklMTEVEIEFOWSBSSUdIVCBPRiBSRVZJRVcgT1IgT1RIRVIgT0JMSUdBVElPTlMgUkVRVUlSRUQgQlkgU1VDSApDT05UUkFDVCBPUiBBR1JFRU1FTlQuCgpEU1Ugd2lsbCBjbGVhcmx5IGlkZW50aWZ5IHlvdXIgbmFtZShzKSBhcyB0aGUgYXV0aG9yKHMpIG9yIG93bmVyKHMpIG9mIHRoZQpzdWJtaXNzaW9uLCBhbmQgd2lsbCBub3QgbWFrZSBhbnkgYWx0ZXJhdGlvbiwgb3RoZXIgdGhhbiBhcyBhbGxvd2VkIGJ5IHRoaXMKbGljZW5zZSwgdG8geW91ciBzdWJtaXNzaW9uLgo=
score 13.935659
Nota importante:
La información contenida en este registro es de entera responsabilidad de la institución que gestiona el repositorio institucional donde esta contenido este documento o set de datos. El CONCYTEC no se hace responsable por los contenidos (publicaciones y/o datos) accesibles a través del Repositorio Nacional Digital de Ciencia, Tecnología e Innovación de Acceso Abierto (ALICIA).