This paper presents a comprehensive data analysis and visualization of electricity consumers’ prepaid bills of Tulkarm district. We analyzed 250,000 electricity consumers’ prepaid bills covering the time period from June to December 2018. The application of data mining techniques for understanding electricity consumers’ behavior in electricity consumption and their behavior in charging their electricity meter’s smart cards in terms of quantities charged and charging frequencies in different time periods, areas and tariffs are used. Understanding consumers’ behavior will support planning and decision making at strategic, tactical and operational levels. This analysis is useful for predicting and forecasting future demand with a certain degree of accuracy. Monthly, weekly, daily and hourly time periods are covered in the analysis. Outliers detection using visualization tools such as box plot is applied. K-means unsupervised machine learning clustering algorithm is implemented. The support vector machine classification method is applied. As a result of this study, electricity consumers’ behavior in different areas, tariffs and timing periods is understood and presented by numbers and graphs and new electricity consumer segmentation is proposed.

At present, the continuous increase of household electricity demand is strategic and crucial in electricity demand management. Household electricity consumers can play an important role in this issue. The rationalization of electricity consumption might be achieved by using an efficient Demand Response (DR) program. In this paper a new methodology is suggested using a combination of data mining techniques namely K-means clustering, K-Nearest Neighbors (K-NN) classification and ARIMA for electricity load forecasting using consumers' electricity prepaid bills data set of an ordinary electricity grid with prepaid electricity meters. As a result of applying this methodology, various DR programs are recommended as an attempt to assist the management of electricity system to manage the electricity demand issues from demand-side in an efficient and effective manner, which can be put into practice. A case study has been carried out in Tulkarm District, Palestine. The performance of applying the suggested methodology is measured, and the results are considered very well.