Design And Implementation Of Combing Platform Marketing Data Analysis Of Electric Power Company Based On The Data Warehouse Technology

Since 2002, the domestic electric power industry information construction has been a rapid rise in the situation, the Power Grid Corp’s investment in information technology is also increasing, the use of electricity acquisition system, marketing system, production management information system, OA, ERP and other applications began to gradually on the line, to the company’s operating information and intelligence has brought a lot of improvement. How to effectively use all kinds of information technology, especially data mining, data warehouse and other new data analysis technology to solve the power industry marketing data analysis problems, has become the key technology problems to be solved by power companies.The overall construction of domestic electric power industry informatization has been rapidly rising trend, the Sichuan Power Grid Corp to informatization investment is also increasing, various applications of acquisition system, power marketing system, production management information system, ERP, OA began to online, has been in daily operation plays an important role in. But because of differences between each system system structure, because the system construction sequence and the technical scheme of different reasons, resulting in the same business data describing the differences among diverse systems, system data for overall business description there is lack of consistency conditions, can not be formed efficiently available global data. Especially the marketing end user data is missing in the marketing system is more serious in the field, and also has the very big discrepancy, and marketing system for grid resource data not inside and check management system of production, leading to the foundation of data inconsistency. This directly affect the relevant index, need marketing system of line loss analysis work. Each application system information platform in the calculation and performance depends on the data, developing data determine system functions practical, vitality and follow-up service. Therefore, carries on the data analysis and combing the need for marketing related data, to meet the needs of business applications, further enhance the Sichuan power grid construction of the marketing system achievement efficiency.This paper studies the goal of our work is to use data warehouse technology to project management, software engineering method to realize the related grid resources, marketing data to conduct a comprehensive inventory of repair work in marketing system of electric power company, the after treatment data can meet the marketing system of daily business, index analysis, the line loss analysis, power quality analysis of demand. Study on the technology of data warehouse, data review work by data extraction, data conversion, data integrated from different platform data source, establishing a marketing data analysis combing platform, can extract data from heterogeneous database, rule base, construction of data comb comb achieve data, data loading and data comb confirmation of the work, and provide statistical information to the user grid data cleaning condition.