Business intelligence in decision-support on communications: Describing a case
Autor(a) principal: | |
---|---|
Data de Publicação: | 2018 |
Outros Autores: | , |
Tipo de documento: | Artigo |
Idioma: | por |
Título da fonte: | Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
Texto Completo: | https://doi.org/10.34627/rcc.v3i0.70 |
Resumo: | This project addresses decisions of investment on communication infrastructures in Electricidade dos Açores (EDA), the local Electric Company in the Azores Islands. The main decision was that EDA communications should be moving to Voice over IP (VoIP) from present telephone lines, outsourced to an external communications company. At the beginning, a business intelligence project was set, with the objective of getting data from the communications company and analyzing it in order to offer useful information to decision makers. The system uses Microsoft SQL server technologies to establish an OnLine Analytical Processing (OLAP) application. It translates big CSV flat files in a ROLAP infrastructure and presents the results as multidimensional data cubes. Latter some data mining models were implemented and both techniques were incorporated in the CRISP-DM process model. Different models identified several inefficient procedures and even fraud situations as long as supporting the investment decision. These models as long as all the technology developed for gathering data, maintain an manage the OLAP cubes and data mining models were made available to control and strategic decision makers. |
id |
RCAP_f287723b910af9a1b97188b183426fc6 |
---|---|
oai_identifier_str |
oai:ojs2.journals.uab.pt:article/70 |
network_acronym_str |
RCAP |
network_name_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository_id_str |
7160 |
spelling |
Business intelligence in decision-support on communications: Describing a caseBusiness Intelligence no Suporte a Decisões sobre Comunicações: Descrição de um CasoThis project addresses decisions of investment on communication infrastructures in Electricidade dos Açores (EDA), the local Electric Company in the Azores Islands. The main decision was that EDA communications should be moving to Voice over IP (VoIP) from present telephone lines, outsourced to an external communications company. At the beginning, a business intelligence project was set, with the objective of getting data from the communications company and analyzing it in order to offer useful information to decision makers. The system uses Microsoft SQL server technologies to establish an OnLine Analytical Processing (OLAP) application. It translates big CSV flat files in a ROLAP infrastructure and presents the results as multidimensional data cubes. Latter some data mining models were implemented and both techniques were incorporated in the CRISP-DM process model. Different models identified several inefficient procedures and even fraud situations as long as supporting the investment decision. These models as long as all the technology developed for gathering data, maintain an manage the OLAP cubes and data mining models were made available to control and strategic decision makers.O projecto descrito tem o objectivo de apoiar decisões de investimento em infraestruturas de comunicação na Electricidade Dos Açores (EDA), a empresa responsável pela geração, transporte e venda de corrente eléctrica na Região Autónoma dos Açores. A decisão imediata a apoiar consistia em saber se as comunicações entre ilhas deveriam passar para tecnologias Voice over IP (VoIP), um serviço actualmente contratado em regime de outsourcing. Foi estabelecido um projecto de business intelligence, usando tecnologias OLAP do Microsoft SQL Server, para ler e pré-processar os ficheiros CSV de grande dimensão, combinar esses dados com bases de dados existentes e apresentar os resultados sobre a forma de cubos multidimensionais. Posteriormente, implementaram-se igualmente algoritmos de data mining, integrando na metodologia CRISP-DM as duas técnicas utilizadas. Construindo vários modelos foi possível, além de apoiar a decisão pretendida, identificar situações ineficientes e mesmo fraudulentas. Os modelos construídos foram ainda disponibilizados aos decisores estratégicos e de controlo, assim como toda a estrutura de reutilização, manutenção e realimentação que suporta o OLAP e os modelos de data mining.Universidade Aberta2018-04-05info:eu-repo/semantics/articleinfo:eu-repo/semantics/otherinfo:eu-repo/semantics/publishedVersionapplication/pdfhttps://doi.org/10.34627/rcc.v3i0.70oai:ojs2.journals.uab.pt:article/70Revista de Ciências da Computação; v. 3 (2008); 23-372182-18011646-633010.34627/rcc.v3i0reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAPporhttps://journals.uab.pt/index.php/rcc/article/view/70https://doi.org/10.34627/rcc.v3i0.70https://journals.uab.pt/index.php/rcc/article/view/70/86Direitos de Autor (c) 2018 Universidade Abertahttp://creativecommons.org/licenses/by/4.0info:eu-repo/semantics/openAccessMendes, Armando B.Alfaro, Paulo JorgeFerreira, Aires2022-10-25T11:31:53Zoai:ojs2.journals.uab.pt:article/70Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-19T16:13:59.375690Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse |
dc.title.none.fl_str_mv |
Business intelligence in decision-support on communications: Describing a case Business Intelligence no Suporte a Decisões sobre Comunicações: Descrição de um Caso |
title |
Business intelligence in decision-support on communications: Describing a case |
spellingShingle |
Business intelligence in decision-support on communications: Describing a case Mendes, Armando B. |
title_short |
Business intelligence in decision-support on communications: Describing a case |
title_full |
Business intelligence in decision-support on communications: Describing a case |
title_fullStr |
Business intelligence in decision-support on communications: Describing a case |
title_full_unstemmed |
Business intelligence in decision-support on communications: Describing a case |
title_sort |
Business intelligence in decision-support on communications: Describing a case |
author |
Mendes, Armando B. |
author_facet |
Mendes, Armando B. Alfaro, Paulo Jorge Ferreira, Aires |
author_role |
author |
author2 |
Alfaro, Paulo Jorge Ferreira, Aires |
author2_role |
author author |
dc.contributor.author.fl_str_mv |
Mendes, Armando B. Alfaro, Paulo Jorge Ferreira, Aires |
description |
This project addresses decisions of investment on communication infrastructures in Electricidade dos Açores (EDA), the local Electric Company in the Azores Islands. The main decision was that EDA communications should be moving to Voice over IP (VoIP) from present telephone lines, outsourced to an external communications company. At the beginning, a business intelligence project was set, with the objective of getting data from the communications company and analyzing it in order to offer useful information to decision makers. The system uses Microsoft SQL server technologies to establish an OnLine Analytical Processing (OLAP) application. It translates big CSV flat files in a ROLAP infrastructure and presents the results as multidimensional data cubes. Latter some data mining models were implemented and both techniques were incorporated in the CRISP-DM process model. Different models identified several inefficient procedures and even fraud situations as long as supporting the investment decision. These models as long as all the technology developed for gathering data, maintain an manage the OLAP cubes and data mining models were made available to control and strategic decision makers. |
publishDate |
2018 |
dc.date.none.fl_str_mv |
2018-04-05 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article info:eu-repo/semantics/other |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
https://doi.org/10.34627/rcc.v3i0.70 oai:ojs2.journals.uab.pt:article/70 |
url |
https://doi.org/10.34627/rcc.v3i0.70 |
identifier_str_mv |
oai:ojs2.journals.uab.pt:article/70 |
dc.language.iso.fl_str_mv |
por |
language |
por |
dc.relation.none.fl_str_mv |
https://journals.uab.pt/index.php/rcc/article/view/70 https://doi.org/10.34627/rcc.v3i0.70 https://journals.uab.pt/index.php/rcc/article/view/70/86 |
dc.rights.driver.fl_str_mv |
Direitos de Autor (c) 2018 Universidade Aberta http://creativecommons.org/licenses/by/4.0 info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
Direitos de Autor (c) 2018 Universidade Aberta http://creativecommons.org/licenses/by/4.0 |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.publisher.none.fl_str_mv |
Universidade Aberta |
publisher.none.fl_str_mv |
Universidade Aberta |
dc.source.none.fl_str_mv |
Revista de Ciências da Computação; v. 3 (2008); 23-37 2182-1801 1646-6330 10.34627/rcc.v3i0 reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação instacron:RCAAP |
instname_str |
Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
instacron_str |
RCAAP |
institution |
RCAAP |
reponame_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
collection |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository.name.fl_str_mv |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
repository.mail.fl_str_mv |
|
_version_ |
1799130592929906688 |