IJCSN International Journal of Computer Science and Network, Volume 2, Issue 6, December 2013 ISSN (Online) : 2277-5420 www.IJCSN.org 59                                              1 Shivani Khedikar, 2 Purva Kirolikar, 3 Supriya Thombre 1, 2, 3 Department of Computer Technology, YCCE Nagpur- 441110, Maharashtra, India Abstract - The 21 st 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. Keywords - Data Warehouse, Business Intelligence, Logical Data Model, Physical Data Model 1. Introduction Maharashtra State Electricity Board ( MSEB) is a state - owned electricity regulation board operating within the state of Maharashtra in India. The MSEB was formed on June 20, 1960 under Section 5 of the Electricity Act, 1948. As of 1998, it was the second largest electricity generating utility in India after National Thermal Power Corporation. [1] Following figure shows the various functionalities of the MSEB. Electric power systems are critical infrastructures for modern society. They span huge geographical areas, and comprise thousands of measurement and monitoring systems continuously collecting various data such as voltage and current, power lows, line temperatures, plus data relating to the stating of devices. The increased utilization of information and communication technologies make available a wealth of data which can be used to gain a deeper understanding of the dynamics of the process as well as an opportunity to use online data decision support. Figure 1: MSEB functionalities When properly trained up, pattern recognition algorithms in data mining can detect deviation from the regular data, which may be useful for triggering alarms and messages (classification) that provide important information to the operator. The mining and off-line analysis of historical data can provide knowledge that can be subsequently implemented online. This knowledge might be related to fault analysis, energy consumption, analysis of distributed generation, or load pattern.[4] Data mining is an essential step in the process of knowledge discovery in databases in which intelligent methods are applied in order to extract patterns[2].Data mining is a process that uses a variety of data analysis tools to identify hidden patterns and relationships within data. The idea that drives us to use this lamentably awesome Data Warehousing (DW) and Business Intelligence (BI) tools in the field of Electricity and Power field is that there are three reasons that are as follows : Firstly , the population Explosion drives the use of Electricity on a large scale. Secondly, electrification of everything as a part of lavish lifestyle and thirdly, expectation inflation. Inspite of these factors, this is the field that has not use BI techniques much .