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...
| Autores: | , , |
|---|---|
| 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).
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).