CN113590607A - Electric power marketing report realization method and system based on report factor - Google Patents
Electric power marketing report realization method and system based on report factor Download PDFInfo
- Publication number
- CN113590607A CN113590607A CN202111146875.9A CN202111146875A CN113590607A CN 113590607 A CN113590607 A CN 113590607A CN 202111146875 A CN202111146875 A CN 202111146875A CN 113590607 A CN113590607 A CN 113590607A
- Authority
- CN
- China
- Prior art keywords
- report
- basic
- business
- data
- factors
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000005259 measurement Methods 0.000 claims abstract description 41
- 238000007621 cluster analysis Methods 0.000 claims abstract description 4
- 230000005611 electricity Effects 0.000 claims description 56
- 238000004458 analytical method Methods 0.000 claims description 15
- 238000012545 processing Methods 0.000 claims description 11
- 238000004140 cleaning Methods 0.000 claims description 6
- 238000007781 pre-processing Methods 0.000 claims description 6
- 238000013499 data model Methods 0.000 claims description 5
- 238000000605 extraction Methods 0.000 claims description 4
- 238000003064 k means clustering Methods 0.000 claims description 4
- 230000006698 induction Effects 0.000 claims description 3
- 230000001939 inductive effect Effects 0.000 claims description 3
- 238000009434 installation Methods 0.000 claims description 3
- 238000010606 normalization Methods 0.000 claims description 3
- 230000002159 abnormal effect Effects 0.000 claims description 2
- 230000008030 elimination Effects 0.000 claims description 2
- 238000003379 elimination reaction Methods 0.000 claims description 2
- 238000010276 construction Methods 0.000 abstract description 3
- 238000011161 development Methods 0.000 description 15
- 230000008569 process Effects 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 230000009467 reduction Effects 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 238000012271 agricultural production Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000013049 sediment Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
- 230000005612 types of electricity Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Water Supply & Treatment (AREA)
- Tourism & Hospitality (AREA)
- Primary Health Care (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Software Systems (AREA)
- Game Theory and Decision Science (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a method and a system for realizing a power marketing report based on report factors, wherein the method comprises the following steps: extracting basic data of the power marketing system, and combing the statistics and judgment logics of the basic data; performing cluster analysis on the obtained data result, and extracting basic commonality factors; carrying out standardization treatment on the basic common factors, and putting the basic common factors into a set to form a basic factor library; the basic common factors in the basic factor library are generalized to a business measurement set and a business dimension set; respectively selecting dimensions and measurement factors from the business measurement set and the business dimension set to generate report factors; and determining the operation logic according to the statistical requirements, and selecting the corresponding report factors to assemble the report. In the information construction of large-scale group-level power marketing enterprises, the method can reduce the repeated entry of basic unit data, realize the repeated application of system data in one-time filling and reporting, and meet the requirements of report personalized application.
Description
Technical Field
The invention belongs to the technical field of data statistical analysis and electric power marketing report development and configuration, and relates to a method and a system for realizing an electric power marketing report based on a report factor.
Background
The world is in a great revolution era of transition from industrial economy to digital economy, data becomes a new engine driving enterprise development, and reports are important and solid data applications of businesses. The electric power enterprise continuously excavates a large amount of client and business data of enterprise sediments by means of full-dimensional visual angle analysis by utilizing the data analysis capability of the report, and customer experience optimization is promoted.
At present, reports of power enterprises extract basic data of a system, and data support is carried out on business specialties such as electricity charge, metering, business expansion, market and service in a fixed report form after a series of procedures such as data analysis, data cleaning and data statistics. The report demands of the power business are complex, and meanwhile, the report demands are varied, so that the basic report business is heavier in burden due to the fact that reports are reported layer by layer. Meanwhile, due to the fact that different report businesses are different, common report components are lacked, flexibility is low, and multiple reports need to be developed independently. However, if each report adopts a mode of independent service independent development, the workload is very high, and the newly added report service needs to be subjected to processes of demand reporting, confirmation, template design, program development and the like, so that the process is complicated, the development period is long, and the response speed to the service demand is very low.
Prior art document 1 (CN 102222105B) discloses a method for generating a real-time statistics report, by which the efficiency of generating a real-time statistics report is high. The method is characterized in that: the method comprises the steps that a general frame of a report function generating program is preset, a report format, report data content filling, a data statistical mode and a chart generating mode in the general frame are set as self-defined modules, when the report format, the report data content filling, the data statistical mode and the chart generating mode are respectively defined, the report function generating program converts the definitions into various statistical functions, then the whole program automatically generates a complete algorithm, and the functions of data extraction, data filling and report output are sequentially realized. The prior art document 1 has the disadvantages that the method has certain requirements on the computer language level of report operators, the definition formats of report data content, cluster fields, grouping fields and the like in a custom module are relatively complex, and the fields need to be redefined and operated when a new report is constructed.
Prior art document 2 (CN 105843936A) discloses a business data reporting method and system, including: generating and storing original data required by generating a business report; receiving the original data, and performing dimensionality reduction processing on the original data; generating a multi-dimensional data set according to the data subjected to the dimensionality reduction treatment; and generating a report according to the multi-dimensional data set. The invention carries out dimension reduction processing by using the received original data, arranges standard format data from a large amount of disordered original data and writes the standard format data into a multi-dimensional data set, and generates a report according to the requirements of different angles. The prior art document 2 has the disadvantages that the report in the power marketing is various, the dimension of the report is complex, the dimension of the multidimensional data set obtained by the original data dimension reduction processing is too much, the business logic between different dimension sets cannot be embodied, and the applicability to the power marketing report is low.
Disclosure of Invention
In order to overcome the defects in the prior art, the application provides a method and a system for realizing a power marketing report based on report factors. In the information construction of large-scale group-level power marketing enterprises, the method can reduce the repeated entry of basic unit data, realize the repeated application of system data in one-time filling and reporting, and meet the requirements of report personalized application.
In order to achieve the above purpose, the invention adopts the following technical scheme:
a method for realizing a power marketing report based on a report factor comprises the following steps:
step 1: extracting basic data of the power marketing system, and combing business statistical requirements and statistical rules;
step 2: performing clustering analysis on the data result obtained in the step 1, and extracting basic commonality factors;
and step 3: carrying out standardization treatment on the basic common factors, and putting the basic common factors into a set to form a basic factor library;
and 4, step 4: according to the electric power marketing business analysis logic, the basic common factors in the basic factor library are induced into a business measurement set and a business dimension set;
and 5: respectively selecting dimensions and measurement factors from the business measurement set and the business dimension set to generate report factors;
step 6: and determining the operation logic according to the statistical requirements, and selecting the corresponding report factors to assemble the report.
The invention further comprises the following preferred embodiments:
preferably, in step 1, an ETL tool is used for extracting basic data from an oracle database of the power marketing system, performing data cleaning, and then combing business statistical requirements and statistical rules.
Preferably, the electric power marketing system basic data comprises marketing business data, business expansion data, marketing work order data and marketing archive data involved in the electric power marketing system.
Preferably, the data cleansing refers to cleansing errors in the data which do not conform to the actual business logic, and the situations of repetition and inconsistent data logic.
Preferably, the business statistical requirements comprise indexes concerned by power marketing, including electric quantity, electric charge, business expansion and installation, and station area line loss related statistical indexes;
the statistical rules comprise different time windows and logic judgment rules during service statistics.
Preferably, in step 2, a K-Means clustering analysis method or a hierarchical clustering method is adopted to cluster the data according to space, time, entity attributes, service significance and measurement standards, and to extract basic commonality factors.
Preferably, the space and the time respectively refer to a unit and a month and year;
the entity attributes comprise industry classification and enterprise scale;
the service significance comprises a voltage grade, an electricity price classification and an electricity charge type;
the electric charge types comprise capacity basic electric charge, demand basic electric charge, power factor adjustment electric charge;
the measurement standard comprises the number of business users, the number of electric users, the capacity of the transformer, the amount of electric charge, the number of work units, the number of days, the electricity selling amount and the electricity generating amount.
Preferably, in step 3, according to the business statistical requirements and statistical rules in step 1, a data model is designed according to the entity attributes and business meanings of the basic commonality factors, the data model performs outlier elimination, special character removal and normalization processing on the basic commonality factors according to the normalization rules, and the processed data is loaded into a predetermined data warehouse.
Preferably, in step 4, the traffic metric set includes the following metrics:
the number of business users, the number of power users, the capacity of the transformer, the amount of electric charge, the number of work units, the amount of electricity sold and the amount of generated electricity;
the set of business dimensions includes the following dimensions:
year and month, unit, industry category, enterprise scale, voltage class, electricity price category, and electricity charge type.
Preferably, in step 5, the dimension is selected in the business dimension set, the measurement is selected in the business measurement set, the measurement under the definite dimension is formed according to the business logic operation and is checked, if the check is qualified, the measurement is released as the report factor, otherwise, the report factor is removed.
Preferably, in step 5, when the reporting factor is issued, the singleness of the reporting factor is verified first, and the redundant reporting factors are merged or cleared.
The invention also discloses a system for realizing the electric power marketing report based on the report factor, which specifically comprises the following steps:
the data acquisition and preprocessing module is used for extracting basic data of the power marketing system and combing business statistical requirements and statistical rules;
the basic commonality factor extraction module is used for carrying out cluster analysis on the data results obtained in the data acquisition and preprocessing module and extracting basic commonality factors;
the standardization processing module is used for carrying out standardization processing on the basic common factors and putting the basic common factors into a set to form a basic factor library;
the basic commonality factor induction module is used for inducing basic commonality factors in the basic factor library to a business measurement set and a business dimension set according to the electric power marketing business analysis logic;
the report factor generation module is used for respectively selecting dimensions and measurement factors from the business measurement set and the business dimension set to generate report factors;
and the report assembling module is used for determining the operation logic according to the statistical requirements at the current stage and selecting the corresponding report factors to assemble the report.
The beneficial effect that this application reached:
1. the invention extracts and summarizes basic commonality factors of basic data of the electric power marketing system to obtain different business measurement and business dimensions, and the report factors are obtained by determining the measurable attributes which can be used for result table assembly in entities related to the measurement expression report business under the dimensions, thereby forming a universal component for report development and configuration. By designing the report factor definition, the unified business rule, the unified dimension measurement and the unified index algorithm can be ensured, the constantly-changing report requirements of power marketing business personnel can be responded very quickly, the flexibility and the expansibility of the report are increased, basic units do not need to repeatedly input data, and a large amount of repeated development work in a complicated development process and the report is avoided.
2. The invention reduces the programming capability requirement of report development and configuration personnel, and common business personnel can complete the development and configuration of the personalized report by means of report factors.
Drawings
Fig. 1 is an overall flowchart of a method for implementing a power marketing report based on a report factor according to the present application.
Detailed Description
The present application is further described below. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present application is not limited thereby.
As shown in fig. 1, the method for implementing a power marketing report based on a report factor of the present invention includes the following steps:
step 1: and extracting basic data from an oracle database of the power marketing system by using an ETL tool, cleaning the data, and combing business statistical requirements and statistical rules.
The data includes but is not limited to report query data, report result data, condition data, process data and the like involved in the electric power marketing system, such as but not limited to marketing business data such as electric charge settlement data, business expansion data, marketing work order data, marketing archive data such as electric power customer data;
the step aims to improve the data quality, and clean the errors which are inconsistent with the actual business logic in the data set, the repetition, the inconsistent data logic and other conditions.
And combing the data according to the data combing rule generated by the power marketing business practice.
The business statistical requirements comprise indexes concerned by power marketing, including electric quantity, electric charge, business expansion and installation, and line loss related statistical indexes of the transformer area;
the statistical rules comprise different time windows and logic judgment rules during service statistics.
Step 2: performing clustering analysis on the data result obtained in the step 1 according to entity significance, measurement standard, dimension attribute and the like, and extracting basic commonality factors;
and clustering the processed data such as the electric charge settlement data, the business expansion data, the marketing work order data, the marketing archive data and the like by adopting a K-Means clustering analysis method, a hierarchical clustering method and other methods according to space, time, entity attributes, business significance, measurement standards and extracting basic commonality factors.
When the method is implemented, a K-Means clustering analysis method is adopted to divide the sample points into a plurality of classes, so that each point belongs to the class corresponding to the centroid closest to the point, the class serves as a clustering standard, the operation speed is high, and the data volume capable of being processed is large.
The space and the time respectively refer to a unit and a year and a month;
the entity attributes comprise industry classification and enterprise scale;
the industry classification comprises manufacturing industry, agriculture, forestry, animal husbandry, fishery, mining industry, construction industry and the like;
the enterprise scale comprises regular enterprises, medium and small micro enterprises and the like;
the service meaning includes but is not limited to voltage grade, electricity price classification, electricity charge type and the like;
the voltage grades comprise low voltage (below 10 kV) and high voltage (10 kV-220 kV);
the electricity price classification comprises five types of electricity prices of residential life electricity consumption, large industrial electricity consumption, general industrial and commercial electricity consumption, non-industrial electricity consumption and agricultural production electricity consumption;
the electric charge types comprise capacity basic electric charge, demand basic electric charge, power factor adjustment electric charge;
the measurement standards comprise the number of business users, the number of electric users, the capacity of the transformer, the amount of electric charge, the number of work units, the number of days, the amount of electricity sold and the amount of generated electricity.
The step realizes the extraction of basic commonality factors through clustering. In implementation, the basic commonality factor obtained by clustering is a factor that the dimension combination does not need to be subdivided and the metric value do not need to be subdivided under the current business, for example, in year and month, unit, industry classification, enterprise scale, voltage level, electricity price classification, electricity charge type and the like.
And step 3: and (4) standardizing the basic common factors, and putting the basic common factors into a set to form a basic factor library.
According to a predefined data model, according to a certain rule, the method comprises the following steps: the method comprises the steps of removing abnormal values, removing special characters, normalizing and the like, and loading cleaned factor data into a given data warehouse (a data source-data cleaning-data warehouse model-data warehouse), wherein the step converts the data into information and knowledge, and improves the value of common factors.
And 4, step 4: and according to the electric power marketing business analysis logic, the basic factors are generalized to a business measurement set and a business dimension set.
According to the electric marketing business analysis logic, the measurement and the dimensionality are clearly divided in the existing electric power enterprise information system.
The dimension is a measured environment, is an angle for observing the service, and is used for reflecting a class of attributes of the service. The columns which represent the dimensions and are contained in the dimensions are called dimension attributes, and the dimension attributes are basic sources for query constraint conditions, grouping and report generation;
a measure is referred to as a fact, and is typically numeric data, which is a fact of a logical table of facts.
In the practice of the present invention, the set of traffic metrics includes, but is not limited to, the following metrics:
the number of business users, the number of electricity users, the capacity of the transformer, the amount of electricity charges (the amount of electricity charges such as capacity basic electricity charges, demand basic electricity charges, electricity consumption charges and power factor adjustment electricity charges), the number of work orders (including 95598 service work orders, business expansion work orders, meter operation and maintenance work orders and the like), the amount of electricity sold, the amount of generated electricity and the like;
the set of business dimensions includes, but is not limited to, the following dimensions:
year and month, unit, industry classification, enterprise scale, voltage level, electricity price classification, electricity fee type and the like.
And 5: selecting a certain dimension in the service dimension set, selecting a certain measure in the service measure set, forming the measure under the definite dimension according to the service logic operation, checking and confirming by service personnel, if the check is qualified, releasing the measure as a report factor, and removing the unqualified measure. And the principle of unity is verified in the release, so that the uniqueness is ensured on the semantic (or ontology) of the service, and the redundant report factors are merged or eliminated. The step forms a reusable report factor, and avoids repeated development of similar contents of the report.
In specific implementation, whether the service personnel is qualified or not is judged according to service experience and statistical requirements, if the power company needs to frequently count and track the electricity sales amount in the time dimension, the year and month and the electricity sales amount are qualified report factors with high demand and more application scenes, but the combination of the two factors of the electricity utilization category and the electricity generation amount obviously generates logical errors and does not meet the service requirements, and the electricity utilization category and the electricity generation amount belong to disqualification.
The step generates the report factors such as monthly electricity sales amount, monthly generated energy, business user number of unit administration area, industry electricity capacity and the like which can be directly used for report assembly under the current service.
For example: according to the statistical aperture of the power company, the monthly sale electric charge factor which is a report factor is formed by combining factors such as basic electric charge _ capacity, basic electric charge _ demand, electric charge, power factor adjustment electric charge and the like with a statistical window period;
the basic electricity charge capacity (namely capacity basic electricity charge) is calculated by the capacity of a transformer of a client and the electricity price of the industry to which the client belongs;
the basic electricity charge _ demand is calculated by the demand of a transformer of a customer and the electricity price of the industry to which the customer belongs;
the electricity consumption is calculated by the electricity consumption of the client and the electricity price of the industry to which the client belongs;
the power factor adjustment electric charge refers to electric charge which is reduced or increased by an electric power company according to the level of the power factor of a user according to a power factor adjustment electric charge method.
Step 6: and the service personnel determines the operation logic according to the statistical requirements at the current stage, selects a proper report factor and assembles the report.
In specific implementation, business personnel are required to select configuration conditions by themselves, namely, the report factors required to be called and the logical relation 'AND/OR' between the report factors are determined, and statistical rules are required to be selected for making reports.
For example, when the monthly electric charge sales income details of a certain power saving company are counted, a monthly electric charge sales factor needs to be called, and meanwhile, different window periods and different electric charge sales unit entities (prefecture and county companies under the power saving company) are used as dimensional conditions for grouping and adding.
The invention relates to a power marketing report realization system based on report factors, which specifically comprises the following steps:
the data acquisition and preprocessing module is used for extracting basic data of the power marketing system and combing business statistical requirements and statistical rules;
the basic commonality factor extraction module is used for carrying out cluster analysis on the data results obtained in the data acquisition and preprocessing module and extracting basic commonality factors;
the standardization processing module is used for carrying out standardization processing on the basic common factors and putting the basic common factors into a set to form a basic factor library;
the basic commonality factor induction module is used for inducing basic commonality factors in the basic factor library to a business measurement set and a business dimension set according to the electric power marketing business analysis logic;
the report factor generation module is used for respectively selecting dimensions and measurement factors from the business measurement set and the business dimension set to generate report factors;
and the report assembling module is used for determining the operation logic according to the statistical requirements at the current stage and selecting the corresponding report factors to assemble the report.
The invention extracts and summarizes basic commonality factors of basic data of the electric power marketing system to obtain different business measurement and business dimensions, and the report factors are obtained by determining the measurable attributes which can be used for result table assembly in entities related to the measurement expression report business under the dimensions, thereby forming a universal component for report development and configuration. By designing the report factor definition, the unified business rule, the unified dimension measurement and the unified index algorithm can be ensured, the constantly-changing report requirements of power marketing business personnel can be responded very quickly, the flexibility and the expansibility of the report are increased, basic units do not need to repeatedly input data, and a large amount of repeated development work in a complicated development process and the report is avoided.
The invention has low requirement on the programming capability of report development and configuration personnel, and common business personnel can complete the development and configuration of the personalized report by virtue of the report factor.
The present applicant has described and illustrated embodiments of the present invention in detail with reference to the accompanying drawings, but it should be understood by those skilled in the art that the above embodiments are merely preferred embodiments of the present invention, and the detailed description is only for the purpose of helping the reader to better understand the spirit of the present invention, and not for limiting the scope of the present invention, and on the contrary, any improvement or modification made based on the spirit of the present invention should fall within the scope of the present invention.
Claims (12)
1. A method for realizing a power marketing report based on report factors is characterized by comprising the following steps:
the method comprises the following steps:
step 1: extracting basic data of the power marketing system, and combing business statistical requirements and statistical rules;
step 2: performing clustering analysis on the data result obtained in the step 1, and extracting basic commonality factors;
and step 3: carrying out standardization treatment on the basic common factors, and putting the basic common factors into a set to form a basic factor library;
and 4, step 4: according to the electric power marketing business analysis logic, the basic common factors in the basic factor library are induced into a business measurement set and a business dimension set;
and 5: respectively selecting dimensions and measurement factors from the business measurement set and the business dimension set to generate report factors;
step 6: and determining the operation logic according to the statistical requirements, and selecting the corresponding report factors to assemble the report.
2. The electric power marketing report realization method based on the report factor as claimed in claim 1, wherein:
in the step 1, basic data are extracted from an oracle database of the electric power marketing system by using an ETL tool, data are cleaned, and then business statistical requirements and statistical rules are combed.
3. The electric power marketing report realization method based on the report factor as claimed in claim 1, wherein:
the basic data of the electric power marketing system comprise marketing business data, business expansion data, marketing work order data and marketing archive data which are related in the electric power marketing system.
4. The electric power marketing report realization method based on the report factor as claimed in claim 3, wherein:
the data cleaning refers to cleaning errors which do not accord with actual business logic in the data, and cleaning the situations of repetition and inconsistent data logic.
5. The electric power marketing report realization method based on the report factor as claimed in claim 1, wherein:
the business statistical requirements comprise indexes concerned by power marketing, including electric quantity, electric charge, business expansion and installation, and line loss related statistical indexes of the transformer area;
the statistical rules comprise different time windows and logic judgment rules during service statistics.
6. The electric power marketing report realization method based on the report factor as claimed in claim 1, wherein:
in step 2, clustering data according to space, time, entity attributes, service significance and measurement standards by adopting a K-Means clustering analysis method or a hierarchical clustering method, and extracting basic commonality factors.
7. The electric power marketing report realization method based on the report factor as claimed in claim 6, wherein:
the space and the time respectively refer to a unit and a year and a month;
the entity attributes comprise industry classification and enterprise scale;
the service significance comprises a voltage grade, an electricity price classification and an electricity charge type;
the electric charge types comprise capacity basic electric charge, demand basic electric charge, power factor adjustment electric charge;
the measurement standard comprises the number of business users, the number of electric users, the capacity of the transformer, the amount of electric charge, the number of work units, the number of days, the electricity selling amount and the electricity generating amount.
8. The electric power marketing report realization method based on the report factor as claimed in claim 1, wherein:
and 3, designing a data model according to the business statistical requirements and the statistical rules in the step 1 and the entity attributes and the business significance of the basic commonality factors, wherein the data model carries out abnormal value elimination, special character removal and normalization processing on the basic commonality factors by using the standardized rules, and processed data are loaded into a set data warehouse.
9. The electric power marketing report realization method based on the report factor as claimed in claim 1, wherein:
in step 4, the service metric set includes the following metrics:
the number of business users, the number of power users, the capacity of the transformer, the amount of electric charge, the number of work units, the amount of electricity sold and the amount of generated electricity;
the set of business dimensions includes the following dimensions:
year and month, unit, industry category, enterprise scale, voltage class, electricity price category, and electricity charge type.
10. The electric power marketing report realization method based on the report factor as claimed in claim 1, wherein:
and 5, selecting dimensionality in the service dimensionality set, selecting measurement in the service measurement set, forming measurement under definite dimensionality according to service logic operation, checking, if the check is qualified, issuing the measurement as a report factor, and if the check is not qualified, clearing the report factor.
11. The electric power marketing report realization method based on the report factor as claimed in claim 10, wherein:
in step 5, when the report factor is issued, firstly, the singleness of the report factor is verified, and the redundant report factor is merged or eliminated.
12. A report factor-based electric power marketing report realization system for operating the report factor-based electric power marketing report realization method according to any one of claims 1 to 11, characterized in that:
the system specifically comprises:
the data acquisition and preprocessing module is used for extracting basic data of the power marketing system and combing business statistical requirements and statistical rules;
the basic commonality factor extraction module is used for carrying out cluster analysis on the data results obtained in the data acquisition and preprocessing module and extracting basic commonality factors;
the standardization processing module is used for carrying out standardization processing on the basic common factors and putting the basic common factors into a set to form a basic factor library;
the basic commonality factor induction module is used for inducing basic commonality factors in the basic factor library to a business measurement set and a business dimension set according to the electric power marketing business analysis logic;
the report factor generation module is used for respectively selecting dimensions and measurement factors from the business measurement set and the business dimension set to generate report factors;
and the report assembling module is used for determining the operation logic according to the statistical requirements at the current stage and selecting the corresponding report factors to assemble the report.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111146875.9A CN113590607A (en) | 2021-09-29 | 2021-09-29 | Electric power marketing report realization method and system based on report factor |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111146875.9A CN113590607A (en) | 2021-09-29 | 2021-09-29 | Electric power marketing report realization method and system based on report factor |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113590607A true CN113590607A (en) | 2021-11-02 |
Family
ID=78242445
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111146875.9A Pending CN113590607A (en) | 2021-09-29 | 2021-09-29 | Electric power marketing report realization method and system based on report factor |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113590607A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114372189A (en) * | 2021-12-31 | 2022-04-19 | 上海金仕达软件科技有限公司 | Processing method and device of user-defined report, storage medium and electronic equipment |
| CN116776175A (en) * | 2023-08-24 | 2023-09-19 | 中国空气动力研究与发展中心计算空气动力研究所 | Hierarchical clustering-based data tag system construction method and system |
| CN117035532A (en) * | 2023-08-18 | 2023-11-10 | 金现代信息产业股份有限公司 | Electric power marketing management system and method based on marketing index multidimensional linkage analysis |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104240043A (en) * | 2014-10-10 | 2014-12-24 | 国家电网公司 | Full-service centralized management service platform for electric power customer service based on number 95598 |
| CN110427418A (en) * | 2019-07-04 | 2019-11-08 | 深圳供电局有限公司 | Customer analysis grouping method based on customer energy value index system |
| CN111008197A (en) * | 2019-11-20 | 2020-04-14 | 王锦志 | Data center design method for power marketing service system |
| CN111159157A (en) * | 2019-12-31 | 2020-05-15 | 远光软件股份有限公司 | Method and device for indexing processing of enterprise report data |
| CN112364603A (en) * | 2020-11-19 | 2021-02-12 | 中国平安财产保险股份有限公司 | Index code generation method, device, equipment and storage medium |
| CN112749986A (en) * | 2021-01-14 | 2021-05-04 | 国网吉林省电力有限公司 | Intelligent electricity price library for settlement sharing service of power system |
-
2021
- 2021-09-29 CN CN202111146875.9A patent/CN113590607A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104240043A (en) * | 2014-10-10 | 2014-12-24 | 国家电网公司 | Full-service centralized management service platform for electric power customer service based on number 95598 |
| CN110427418A (en) * | 2019-07-04 | 2019-11-08 | 深圳供电局有限公司 | Customer analysis grouping method based on customer energy value index system |
| CN111008197A (en) * | 2019-11-20 | 2020-04-14 | 王锦志 | Data center design method for power marketing service system |
| CN111159157A (en) * | 2019-12-31 | 2020-05-15 | 远光软件股份有限公司 | Method and device for indexing processing of enterprise report data |
| CN112364603A (en) * | 2020-11-19 | 2021-02-12 | 中国平安财产保险股份有限公司 | Index code generation method, device, equipment and storage medium |
| CN112749986A (en) * | 2021-01-14 | 2021-05-04 | 国网吉林省电力有限公司 | Intelligent electricity price library for settlement sharing service of power system |
Non-Patent Citations (1)
| Title |
|---|
| 王维佳: "面向电力营销的OLAP与数据挖掘技术研究与应用", 《中国优秀硕士学位论文全文数据库 (信息科技辑)》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114372189A (en) * | 2021-12-31 | 2022-04-19 | 上海金仕达软件科技有限公司 | Processing method and device of user-defined report, storage medium and electronic equipment |
| CN117035532A (en) * | 2023-08-18 | 2023-11-10 | 金现代信息产业股份有限公司 | Electric power marketing management system and method based on marketing index multidimensional linkage analysis |
| CN116776175A (en) * | 2023-08-24 | 2023-09-19 | 中国空气动力研究与发展中心计算空气动力研究所 | Hierarchical clustering-based data tag system construction method and system |
| CN116776175B (en) * | 2023-08-24 | 2023-11-24 | 中国空气动力研究与发展中心计算空气动力研究所 | Hierarchical clustering-based data tag system construction method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106570778B (en) | A kind of method that data integration based on big data is calculated with line loss analyzing | |
| CN113590607A (en) | Electric power marketing report realization method and system based on report factor | |
| WO2021135177A1 (en) | Construction method and apparatus for energy data warehouse system | |
| CN111324602A (en) | Method for realizing financial big data oriented analysis visualization | |
| CN105868373B (en) | Method and device for processing key data of power business information system | |
| CN112001586B (en) | Enterprise networking big data audit risk control architecture based on block chain consensus mechanism | |
| CN111539604A (en) | Enterprise rework and production recovery index measuring and monitoring method based on electric power data | |
| CN105405069B (en) | Electricity purchase operation decision analysis and data processing method | |
| CN108846691A (en) | Regional grain and oil market price monitoring analysing and predicting system and monitoring method | |
| CN110851667A (en) | Integrated analysis method and tool for multi-source large data | |
| CN108345670B (en) | Service hotspot discovery method for 95598 power work order | |
| CN109754177A (en) | Pollution sources portrait label system, the building method of pollution sources portrait and its application | |
| CN111752935A (en) | Method and device for checking power transaction user data | |
| CN111143431B (en) | Intelligent charge checking and anomaly identification system | |
| CN114493619A (en) | Enterprise credit investigation label construction method based on electric power data | |
| CN111695979A (en) | Method, device and equipment for analyzing relation between raw material and finished product | |
| CN112926852A (en) | Atmospheric ecological environment analysis method based on data fusion | |
| CN110597796A (en) | Big data real-time modeling method and system based on full life cycle | |
| CN112686491A (en) | Enterprise power data analysis method based on power consumption behavior | |
| CN113836310A (en) | Knowledge graph driven industrial product supply chain management method and system | |
| CN112347163A (en) | High-dispersion SQL dynamic baseline warning method and system | |
| CN112102003A (en) | Big data platform-based electricity customer core resource management system and method | |
| CN114155085A (en) | Method and system for automatically early warning risk index based on expression engine | |
| CN113537758A (en) | Manufacturing industry high-quality development comprehensive evaluation method and system based on big data technology | |
| CN112784129A (en) | Pump station equipment operation and maintenance data supervision platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211102 |