| For power management and business enterprises, Wire Loss Analysis occupies a very important position. Wire loss rate is a comprehensive reflection of the management standard and economic efficiency of power companies. As an important economic and technical indicator of the power companies, the standard of wire loss management is directly related to the power companies'business performance. To some extent, the wire loss management is directly related to the companies'survival and development. Therefore, it is imperative to develop a system which could serve companies with date analysis and enhancement for management efficiency. In this background, Wire Loss Analysis and Management is projected, and put into development.Wire Loss Analysis and Management System includes collection of power data, wire loss calculation data, wire loss indicators analysis, the causes of wire loss analysis, and evaluation of wire loss management performance, which cover the main daily operations of Wire Loss Analysis. Acquisition of power data at all levels of the main elements of the gateway table power data, ETL, the establishment of the corresponding dimension tables and fact tables; Line Loss Calculation data section includes the calculation substation, Taiwan District theoretical line loss of value, acquisition value of the measured line loss. Line Loss index analysis, including line losses, line loss rate, indicators of line losses to drill, drill, rotating, etc. OLAP operations, and through multi-dimensional tables, charts, etc. a full range of indicators on the line loss analysis; Line Loss Cause analysis includes the maintenance of the causes of line losses, and produce a variety of reasons for line losses, such as leakage copy, estimate copy, stealing, errors or incorrect meter wiring, transformer magnification error analysis to guide to reduce line losses of the method; line loss management performance evaluation refers to the film, Taiwan District, responsible for line loss indicators, assessment, and responsibilities of the contractor's performance-related in order to enhance power management, and blocked all loopholes.The development process of Wire Loss Analysis and Management includes five periods, which are concluded as need analysis and design, structure design and model design for database, ETL (Extraction - Transformation - Load) program design for historical business data, the development of Wire Loss Analysis and Management, system test and on-line test.In the requirements modeling process of Wire Loss Analysis and Management, begin with the workflow of wire loss analysis and management, we make the requirements modeling and eventually complete a block diagram of the system functional requirements. The system is divided into five parts, data ETL (Extraction - Conversion - load) process; providing analysis's reports, charts, analysis of the situation on the wire loss; the assessment and management indicators; Loss Reduction program's development and maintenance; analysis of Loss Reduction's implementation.Wire Loss Analysis and Management is a "superstructure" of the power management system; it uses the data warehouse technology for data storage and integration to fully support the decision of Power Company's management of wire loss. In the development process of the "Wire Loss Analysis and Management", we integrate and analyze the early OLTP (online transaction processing system) operational data, then form the OLAP (Online Analytical Processing System) analytical data. In the process of building data warehouse, we understand the related technologies, terminology, and architecture approach of data warehouse. In the guidance of the design idea of "based on data" - "" By combining demand "-" "Building Analysis" - "" get results "-" "producing benefits ", we establish the Data Warehouse of "Wire Loss Analysis and Management"."Wire Loss Analysis and Management" use SqlServer2008's SSAS (Sql Server Analysis Service) as a data warehouse creation and management tools; and built tables, fact sheets, measure, KPI, etc. during the data warehouse dimension, and use the partition data analysis technology of SSAS to improve efficiency.We use SSIS (Sql Server Integration Service) to carry out data's extraction - Conversion - loading; in the process of the development of Wire Loss Analysis and Management ETL (Extraction - Transform - Load) program there are four step, first, setting up data warehouse data standards, standardization of the data warehouse; second, the establishment of non-standardization and standardization of comparison table; third, to achieve ETL (Extraction - Transform - load) program development, including data, merge, split, polymerization, cleaning and other operations, The data will be distributed through the ETL process integration for data warehousing and normative data. Fourth, on a regular basis to run ETL (Extraction - Transform - load) program, periodic operational system's database will be loaded into the data warehouse.We use SSRS (Sql Server Reporting Service) as a reporting tool for the analytical framework. Microsoft Visual Studio2008 presented as a front-end development tools, system development language use a currently popular C # language. Paper to wire loss evaluation index management and actual Wire Loss Analysis in the purchase power, sales analysis, for example shows the system front-end rendering program development. Wire loss evaluation index management entry a monthly wire loss evaluation index to the database and through the ETL process associated the wire loss assessment indicators and the actual wire losses , analyzed and ranked, in order to strengthen the management of company. Wire loss analysis of the actual purchase, electricity sales analysis, purchase and consumption of area contractors, sales analysis, are carried out in multi-angle analysis of visual rendering by the charts and other means.The use of Wire Loss Analysis and Management solves these two problems. By years of historical data integration, different aspects are employed to analyze the rate of wire loss, drill-down analysis, and rotation analysis. Comparisons are made between the theoretical and actual value of wire loss. Management and maintenance of wire loss causes , analysis of the current proportion of wire losses adjusting technical and management strategies, and taking appropriate means, and using charts or curves follow-up measures to the results obtained, it provided the management of the company a scientific and rational basis.In the period of project researching, we use the methods of software engineering management, iterative way of work, and close communication with managers and users to save project costs and enhance researching efficiency.Wire Loss Analysis and Management is an important part of company information construction in our enterprise. During the whole researching process, I was responsible for the Requirements Analysis and overall architecture design for Wire Loss Analysis System. I also participated in the technology research and realization of the system. By using software engineering knowledge in my master degree study, combining theory and practice, I completed the actual work perfectly. From the project composing to on-line operation, Wire Loss Analysis and Management lasted ten months. Now, the system is running well and has achieved good economic and social benefits. |
