Utilize este identificador para referenciar este registo: http://hdl.handle.net/10400.3/2150
Título: BI and data warehouse solutions for energy production industry: application of the CRISP-DM methodology.
Autor: Mendes, Armando B.
Palavras-chave: Decision Support Systems
Data Mining
OLAP
Operations Efficiency
Data: Jul-2010
Editora: IOS Press
Citação: Mendes, Armando B. (2010). "BI and data warehouse solutions for energy production industry: application of the CRISP-DM methodology". In Respício, A.; Adam, F.; Phillips-Wren, G.; Teixeira, C. e Telhada, J. (Eds.), «Bridging the Socio-technical Gap in Decision Support Systems: Challenges for the next decade», Series 'Frontiers in Artificial Intelligence and Applications', vol. 212. IOS Press, pp. 211-222. ISBN: 978-1-60750-576-1.
Resumo: This paper reports two projects for supporting decisions of the Company of Electricity in Azores Islands, Electricidade dos Açores. There were several decisions to support, such as whether communications between islands should moved from the present telephone lines to VoIP, and if better models to support forecast power consumption should be adopted. The solution established integrates OLAP cubes in a data mining project, based on CRISP-DM process model. Both for strategic and more operational decisions the objective was always to get accurate data, build a data warehouse and to get tools to analyze it in order to properly inform the decision makers. These DSS's translates big CSV flat files or acquire data in real time from operational Data Bases to update a data warehouse, including importing, evaluating data quality and populating relational tables. Multidimensional data cubes with numerous dimensions and measures were used for operational decisions and as exploration tools in the strategic ones. Data mining models for forecasting, clustering, decision trees and association rules identified several inefficient procedures and even fraud situations. Not only was possible to support the necessary decisions, but several models were also displayed so that control decision makers and strategists could support new problems.
Peer review: yes
URI: http://hdl.handle.net/10400.3/2150
ISBN: 978-1-60750-576-1 (Print)
Versão do Editor: http://dx.doi.org/10.3233/978-1-60750-577-8-211
Aparece nas colecções:DME - Parte ou Capítulo de um Livro / Part of Book or Chapter of Book

Ficheiros deste registo:
Ficheiro Descrição TamanhoFormato 
BI and Data Warehouse Solutions for Energy Production Industry_63.pdf531,55 kBAdobe PDFVer/Abrir


FacebookTwitterDeliciousLinkedInDiggGoogle BookmarksMySpace
Formato BibTex MendeleyEndnote Degois 

Todos os registos no repositório estão protegidos por leis de copyright, com todos os direitos reservados.