The 21st century is making use of electricity so extensively that it has almost changed the face of the earth. To generate and harness electricity on a large scale means the development of machinery capable of doing so. An essential strategy for meeting the energy challenge is to concentrate on the generation and use of electricity. One suggested technique to assist in analysis is data warehousing and data mining. Use of the Data warehouse and Business Intelligence Systems for the betterment of the electricity related problems which are lamentably worst specially in rural areas, would enable the respective organizations to deal with the appropriate problems. It would enforce better decision -making. This paper focuses on building data warehouse that will further be followed by dashboard creation by applying data mining techniques that would enable Maharashtra State Electricity Board to analyze electricity trends and take steps accordingly to improve its performance.
Published In : IJCSN Journal Volume 2, Issue 6
Date of Publication : 01 December 2013
Pages : 59 - 72
Figures : 31
Tables : --
Publication Link : ijcsn.org/IJCSN-2013/2-6/IJCSN-2013-2-6-131.pdf
Shivani Khedikar : Department of Computer Technology, YCCE
Nagpur- 441110, Maharashtra, India
Purva Kirolikar : Department of Computer Technology, YCCE
Nagpur- 441110, Maharashtra, India
Supriya Thombre : Department of Computer Technology, YCCE
Nagpur- 441110, Maharashtra, India
With such an overwhelming list of advantages, it is easy to wonder why every organization does not already have a data warehouse. The only reason is that before the availability of prebuilt warehouses, custom creation was an expensive, time-consuming, and expert-intensive process. Thousands of organizations, including the majority of the most successful businesses in the world, have made the investment to create data warehouses. Their pioneering work has made it much easier for those starting today.
The case for obtaining a BI solution based on a data warehouse has become compelling, even for businesses struggling with layoffs and drastic cost cutting. Without one it is very hard to determine how to rebuild a business model around current levels of demand. Trying to manage a complex business in a highly challenging economic environment without a BI solution based on a data warehouse is thus fraught with risk.
[1] Maharashtra State Electricity Board , From Wikipedia, the free encyclopedia http://en.wikipedia.org/wiki/Maharashtra_State_Electricity_Board.
[2] Golfarelli & Rizzi," Chapter 1 Introduction to Data Warehousing ",Data Warehouse Design : Modern Principles and Methodologies.
[3] Ali Asheibi,David A. Stirling, Sarath Perera, D A. Robinson, " Power Quality Data Analysis Using Unsupervised Data Mining" , Australasian Universities Power Engineering Conference (AUPEC 2004) 26-29 September 2004, Brisbane, Australia.
[4] Can ANIL, " Benchmarking of Data Mining Techniques as Applied to Power System Analysis",Department of Information Technology.
[5] Abel Damtew, "Designing a predictive model for Heart Disease Detection using data mining techniques", A Thesis Submitted to the School of Graduate Studies of Addis Ababa University in Partial Fulfillment of the Requirements for the Degree of Master of Science in Health Informatics.
[6] Solomon Negash, " Business Intelligence", Communications of the Association for Information Systems (Volume13, 2004) 177-195.
[7]Logical Data Model, From Wikipedia the free encyclopedia http://en.wikipedia.org/wiki/Logical_data_model.
[8] http://microstrategy-tutorials.blogspot.in/2010/01/physical-warehouse-chema.html.
[9] http://en.wikipedia.org/wiki/Fact_table.
[10] Ali Asheibi,David A. Stirling, Sarath Perera, D A. Robinson, " Power Quality Data Analysis Using Unsupervised Data Mining" , Australasian Universities Power Engineering Conference (AUPEC 2004) 26-29 September 2004, Brisbane, Australia.
[11] Joseph Guerra, David Andrews " Why You Need a Data Warehouse", Andrews Consulting Group.
