Olap Applications In The Analysis Of Power Marketing

With the development of the power system in our country, how to advance the management level of the enterprise,draw examination standards and check staff performance are all the conundrums which Jixi Power Company needs to resolve in business management. The OLAP technologies enable the analysts to be able to analyze the different regions by means of the operation of drill-down,roll-up,rotate and slice operations to dig out the valuable information for the check of the Lines and the Range of Transformer Supply. At the same time,it provides the important support for the enterprise management layer's scientific management and DSS.Firstly, the statistics of the electricity purchase and distribution of business data is analyzed then with the subject of electricity and electric charge.Star schema used to establish the fact table and dimension table.After extraction, transformation and loading,the data is restored into the data mart. It can provide the basic data for OLAP then through the operation of the drill-down, roll-up and slice operations to analyze the data cube from the different facts to get the tidings of the electricity sales condition,the charge and the arrears on various regions,each line and time dimension.The theses focuses on transferring the tidings to the corresponding figures through the business intellectual tool and count the various electric quantity and electric charge in different regions in every period of time.The analysis is displayed with Multidimensional Reports or Graphic Statements to provide the corporate decision-makers in order to provide scientific assessment and adequate theoretical basis.Finally, here's coming a piece of advice for the Power Company application that "Pattern on Management of Contract according to Line and Check-up the Range of Transformer Supply" through the analysis.