BI and Data Warehouse Solutions for Energy Production Industry: Application of the CRISP-DM methodology

Authors:
Armando B. Mendes
Affiliations:
Azores University and CEEAplA, Ponta Delgada, Azores, Portugal
Venue:
Proceedings of the 2010 conference on Bridging the Socio-technical Gap in Decision Support Systems: Challenges for the Next Decade
Year:
2010

Citing 10
Cited 0

From data mining to knowledge discovery: an overview

Advances in knowledge discovery and data mining
Critical success factors revisited: success and failure cases of information systems for senior executives

Decision Support Systems
Microsoft data mining: integrated business intelligence for e-commerce and knowledge management

Microsoft data mining: integrated business intelligence for e-commerce and knowledge management
Emerging standards for data mining

Computer Standards & Interfaces
Principles of data mining

Principles of data mining
Intelligent Data Warehousing: From Data Preparation to Data Mining

Intelligent Data Warehousing: From Data Preparation to Data Mining
Data fusion and data grafting

Computational Statistics & Data Analysis - Nonlinear methods and data mining
The knowledge discovery process

Handbook of data mining and knowledge discovery
Introduction: Lessons Learned from Data Mining Applications and Collaborative Problem Solving

Machine Learning
Delivering Business Intelligence with Microsoft SQL Server 2005

Delivering Business Intelligence with Microsoft SQL Server 2005

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.