CN117035532A - Electric power marketing management system and method based on marketing index multidimensional linkage analysis - Google Patents
Electric power marketing management system and method based on marketing index multidimensional linkage analysis Download PDFInfo
- Publication number
- CN117035532A CN117035532A CN202311044780.5A CN202311044780A CN117035532A CN 117035532 A CN117035532 A CN 117035532A CN 202311044780 A CN202311044780 A CN 202311044780A CN 117035532 A CN117035532 A CN 117035532A
- Authority
- CN
- China
- Prior art keywords
- index
- data
- marketing
- ranking
- power marketing
- 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
- 238000004458 analytical method Methods 0.000 title claims abstract description 92
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000007726 management method Methods 0.000 claims description 52
- 230000002159 abnormal effect Effects 0.000 claims description 22
- 238000005553 drilling Methods 0.000 claims description 19
- 230000008569 process Effects 0.000 claims description 15
- 238000012545 processing Methods 0.000 claims description 11
- 230000005611 electricity Effects 0.000 claims description 9
- 238000004422 calculation algorithm Methods 0.000 claims description 8
- 238000012937 correction Methods 0.000 claims description 7
- 238000012986 modification Methods 0.000 claims description 7
- 230000004048 modification Effects 0.000 claims description 7
- 238000004364 calculation method Methods 0.000 claims description 6
- 238000013480 data collection Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 claims description 5
- 238000007689 inspection Methods 0.000 claims description 4
- 238000012544 monitoring process Methods 0.000 claims description 4
- 238000007619 statistical method Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 230000003993 interaction Effects 0.000 description 4
- 230000035515 penetration Effects 0.000 description 4
- 230000005856 abnormality Effects 0.000 description 2
- 230000001174 ascending effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 230000007774 longterm Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000005065 mining Methods 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 230000008447 perception Effects 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- 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
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Health & Medical Sciences (AREA)
- Educational Administration (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Theoretical Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to the field of data statistics, and provides a power marketing management system and a method based on multi-dimensional linkage analysis of marketing indexes. The index analysis method can realize unified management of each professional electric power marketing of each department through flexible configuration.
Description
Technical Field
The invention belongs to the field of data statistics, and particularly relates to an electric power marketing management system and method based on marketing index multidimensional linkage analysis.
Background
The statements in this section merely provide background information related to the present disclosure and may not necessarily constitute prior art.
Regarding management of power marketing business, the following problems currently exist:
1. the marketing business has the advantages of more data, huge information quantity, difficult extraction of key information and low data utilization value.
2. After marketing problems appear, the digital technology is insufficient in support for current business demands, accurate problem positioning is difficult to develop, and similar problems cannot be corrected in time and accurately prevented.
3. The technical means of business index analysis is insufficient, and the business short board perception of each marketing specialty is not obvious.
4. Marketing indexes focused by different users at different time are different, and each department of each unit only develops a set of statistical analysis system aiming at the individuation indexes of the interests, so that the applicability is not strong.
Disclosure of Invention
In order to solve at least one technical problem in the background technology, the invention provides a power marketing management system and a method based on multi-dimensional linkage analysis of marketing indexes, which firstly collect index data in power marketing business, secondly analyze multi-dimensional statistics of the index data based on the collected data, analyze ranking, duty ratio and time trend of indexes respectively from time, unit and business type, and simultaneously support continuous downward drilling of the index data. After the project is deployed, the user of each marketing department can realize the statistical analysis of the concerned index by using the index configuration function without developing again for each marketing index aiming at the change of the concerned index, and the project does not need to be deployed and updated again. Can quickly position the root cause of the problem, carry out problem correction and further promote problem solving.
In order to achieve the above purpose, the present invention adopts the following technical scheme:
a first aspect of the present invention provides a power marketing management system based on a marketing index multi-dimensional linkage analysis, comprising:
the data acquisition module is used for acquiring electric power marketing business data;
the index configuration module is used for presetting index statistics items and index query logic of the power marketing business configuration to be analyzed according to the index configuration list;
and the index analysis module is used for carrying out unit-category-time multidimensional linkage analysis and data drilling of the power marketing index based on the power marketing service data, the index statistics items of preset power marketing service configuration to be analyzed and index query logic, positioning the generated multidimensional linkage analysis result to a work order, and further positioning the root cause of the problem and carrying out problem correction.
Further, the electric power marketing business data comprises marketing business expansion whole flow, line loss management, inspection work orders, service work orders, metering asset analysis and electric charge and electricity price management information.
Further, the system also comprises a data collection module, wherein the data collection module is used for uniformly processing the acquired power marketing business data into standard data suitable for index application.
Further, the index configuration module comprises an index algorithm configuration module, a management billboard configuration module, an index profile configuration module and an index detail configuration module;
the index algorithm configuration module is used for configuring index calculation basis according to business logic of the electric power marketing business to be analyzed;
the management signboard configuration module is used for configuring data displayed in the management signboard;
the index profile configuration module is used for configuring index ranking, classification duty ratio and detail data of the corresponding indexes;
the index detail configuration module is used for configuring the index work order quantity and the duty ratio of corresponding indexes according to the statistics of units and service types and counting time trend diagrams according to time.
Further, the index analysis module comprises an index profile analysis module and an index detail analysis module;
the index profile analysis module is used for analyzing index ranking, classification duty ratio and detail data of the corresponding indexes;
the index detail analysis module is used for carrying out work order analysis in multiple directions in a data linkage mode according to units, categories and trends.
Further, in the index profile analysis module, the index ranking carries out index ranking according to a city level and a county level multi-unit level, and the city level ranking shows the score ranking and the average value of all local cities in the province in the index; the county level ranking shows the score ranking and the average value of each county in the present index of the present city;
the classification duty ratio adopts a fan-shaped statistical graph to count the duty ratio and the number of each business category in the index;
the detail data are index detail data for displaying units of the city level and the county level according to index ranking.
Further, the system also comprises an index early warning module, wherein the index early warning module is used for checking abnormal data of the index according to the height of the index in the index analysis process, dispatching the abnormal work orders exceeding the threshold in real time, monitoring the dispatching and modifying process, and automatically generating work orders to be dispatched to the lower units for modifying.
The second aspect of the invention provides a power marketing management method based on marketing index multidimensional linkage analysis, comprising the following steps:
acquiring electric power marketing business data;
uniformly processing the acquired electric power marketing business data into standard data suitable for index application;
presetting an index statistical item and an index query logic of the power marketing business configuration to be analyzed according to an index configuration list;
based on the electric power marketing business data, the index statistics items of preset electric power marketing business configuration to be analyzed and the index query logic, unit-category-time multidimensional linkage analysis and data drilling of the electric power marketing indexes are carried out, and the generated multidimensional linkage analysis result is positioned to a work order, so that the root cause of the problem is positioned and the problem is rectified.
Further, the unit-category-time multidimensional linkage analysis of the electric power marketing index specifically comprises the following steps:
analyzing the number proportion and ranking of the work orders of the index in a time range and the number proportion and ranking and trend of each work order category by using unit dimension; analyzing the first class or the second class by class dimension, wherein the number, the duty ratio, the ranking and the trend of the class worksheets and the duty ratio, the ranking and the number of the class worksheets in the total worksheets are in each unit of a period of time; and counting the index trend of the time range of the period, the ranking of the duty ratio number of each unit index and the ranking condition of the duty ratio number of each category of the index by using the time dimension.
Further, in the index analysis process, abnormal data of the index is checked according to the height of the index, abnormal worksheets exceeding a threshold value are dispatched in real time, the dispatching modification process is monitored, and worksheets are automatically generated and dispatched to a lower unit for modification.
Compared with the prior art, the invention has the beneficial effects that:
1. standardizing and unifying marketing index data
According to the method and the system, index basic data in a unified format are extracted from a plurality of marketing business information, the basic data are provided for index analysis of the scheme, the basic data can be provided for marketing information data mining, and the key information extraction efficiency is improved.
2. Providing multidimensional linkage marketing index analysis, achieving management three-dimensional
The invention can more intuitively display the hierarchical distribution, the category occupation ratio and the time trend of the marketing index through multidimensional linkage analysis of the marketing index. The method is more beneficial to users to mine useful information of marketing indexes, quickly adjust and promote work, provide development directions for improving comprehensive business capacity of each unit, and further improve the overall service level.
3. Marketing index analysis linkage problem, realizing rapid positioning
The invention can support downward drilling from the marketing index quality analysis, locate to the problem work order, promote the quick promotion of marketing problems, solve the marketing problems with high efficiency, not only comprehensively improve the marketing business processing efficiency, but also really reduce the burden of a base layer.
4. The management system can be flexibly configured, and has stronger applicability
The management system can be flexibly configured, can be suitable for different departments, different level units and different requirements of marketing indexes focused in different periods of an electric power company, has stronger applicability, is convenient to popularize and apply, and reduces the learning operation cost of different operators in different areas.
Additional aspects of the invention will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention.
FIG. 1 is a diagram of a power marketing management system architecture based on a multidimensional linkage analysis of marketing indicators provided by an embodiment of the present invention;
FIG. 2 is a block diagram of a power marketing management system based on a multidimensional linkage analysis of marketing indicators provided by an embodiment of the invention;
fig. 3 is a flowchart of a power marketing management method based on a marketing index multidimensional linkage analysis according to an embodiment of the present invention.
Detailed Description
The invention will be further described with reference to the drawings and examples.
It should be noted that the following detailed description is illustrative and is intended to provide further explanation of the invention. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs.
It is noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of exemplary embodiments according to the present invention. As used herein, the singular is also intended to include the plural unless the context clearly indicates otherwise, and furthermore, it is to be understood that the terms "comprises" and/or "comprising" when used in this specification are taken to specify the presence of stated features, steps, operations, devices, components, and/or combinations thereof.
Example 1
As shown in fig. 1-2, the present embodiment provides a power marketing management system based on a multi-dimensional linkage analysis of marketing indicators, comprising:
the data access module is used for acquiring electric power marketing business data;
the system supports two types of data access, one type is that data such as marketing 2.0, mining system and the like are accessed directly through a data center; secondly, the RPA flow robot technology is used for calling a data maintenance entry function provided by the system, and 95598 emergency repair work orders, station area line loss data and the like are imported into the system in the form of an Excel template.
The electric power marketing business data comprises information such as marketing business expansion whole flow, line loss management, inspection work orders, service work orders, metered asset analysis, electricity charge and electricity price management and the like.
The data collection module is used for uniformly processing the acquired power marketing business data into standard data suitable for index application;
the standard data packet suitable for index application specifically comprises unified information formats such as index names, units, index values, index dates and the like, relates to units of city, county and third level, and is one-level or multi-level in service type, so that index statistics and data analysis are facilitated.
In the data collection module, the process of uniformly processing the acquired power marketing business data into standard data suitable for index application comprises the following steps:
1) Establishing a standard data statistics table and an abnormal data table, wherein the fields of the standard data table comprise index types, primary units, secondary units, tertiary units, business primary, secondary and tertiary classifications, index data amounts, statistics time and the like; the abnormal data table is consistent with the original data table or key fields are reserved;
2) Processing an original data table by configuring sql sentences or writing a storage process, and storing processed data into a standard data statistics table and an abnormal data table;
3) All index data related to the electric power marketing business are summarized based on the standard data statistics table and the abnormal data table, and can be classified into ranking class and duty ratio class, and further processed into standard data.
The index configuration module is used for presetting index statistics items and index query logic of the marketing business configuration to be analyzed according to the index configuration list;
the index configuration list comprises all the indexes of each specialty in the system, and provides configurable indexes and index algorithms for each specialty index management signboard.
The index configuration module comprises an index algorithm configuration module, a management billboard configuration module, an index profile configuration module and an index detail configuration module;
the index algorithm configuration module is used for configuring index calculation basis according to business logic of the marketing business to be analyzed; the calculation basis comprises a corresponding calculation formula and a data source required by calculation.
The management billboard configuration module is used for configuring data displayed in the management billboard. For example, whether the index value of the index is displayed in the management billboard, the index ranking, the index trend chart of the index displayed for nearly 7 days or nearly 12 months, or the index bar chart of all lower units under the current unit, etc.
The index profile configuration module is used for configuring index ranking (city ranking and county ranking), classification duty ratio and detail data of the corresponding index.
The index detail configuration module is used for configuring the index work order quantity and the duty ratio of corresponding indexes according to the statistics of units and service types and counting time trend diagrams according to time.
In this embodiment, the number of work orders and the duty ratio are displayed in a pie chart, and the number of work orders shows the ranks of the places and counties in a histogram.
And the key index configuration module is used for flexibly configuring indexes displayed in the management panel. The display of maximum 9 indexes of the management panel is currently managed.
The index analysis module is used for carrying out multidimensional linkage analysis and data drilling of marketing indexes based on the collected electric power marketing service data, preset index statistics items of electric power marketing service configuration to be analyzed and index query logic, positioning the generated multidimensional linkage analysis result to a work order, further positioning the problem and promoting the problem to be solved in time.
In the index analysis module, the multidimensional linkage analysis for carrying out the electric power marketing index specifically comprises the following steps: carrying out linkage analysis by using units, analogy and time, and analyzing the number proportion and ranking of the work orders of the index, the number proportion and ranking and trend of the work orders in a certain time range by using unit dimension; analyzing the first class or the second class according to class dimension, wherein the number, the duty ratio, the ranking and the trend of the class work orders and the duty ratio, the ranking and the number of the class work orders in the total work orders are in each unit of a period of time; and counting the index trend of the time range of the period, the ranking of the duty ratio number of each unit index and the ranking condition of the duty ratio number of each category work order of the index according to the time dimension.
In the index analysis module, carry out the data drilling of marketing index, include:
1) The index configuration module, business index name, index data source, statistics item (combination of statistics field and summation/percentage function), inquiry condition, unit field, classification field, time field, ascending/descending order, etc., the detail data also needs to configure header field and header name of detail data item, in addition, the time range can be increased, and the dimension of inquiry display can be increased by whether the same ring ratio is adopted.
2) And the drilling interaction module is used for analyzing fixed parameters of the front-end page by indexes, wherein the fixed parameters comprise index configuration ID, units, types, time periods and keywords, and when the front-end data drilling interaction is performed, the field data are only required to be calculated by combining specific SQL sentences, and statistical data according to the units, the types and the time are returned.
3) Index drilling analysis, namely displaying unit index data of all secondary units of a primary unit lower level according to unit defaults, displaying index data of each category under the primary unit primary category according to category defaults, and displaying index data trend of the last month of the primary unit according to time defaults; meanwhile, the poor index under the same latitude can be obtained, and the lower-level classification index data can be further displayed.
And finally, positioning the generated multidimensional linkage analysis result to the detail of the abnormal work order, and further positioning the root cause of the problem and carrying out manual order dispatching correction.
Taking the electric power marketing index 'Wan family complaint rate' as an example, the data drilling of the index is described.
The index of the 'every complaint rate' is 95598 worksheet data in the electric power business, and the worksheet information mainly comprises a worksheet number, a belonging city, a county, a power supply station, a first service type (complaint/opinion/service application and the like), a second service type (electricity utilization service requirement/power supply service/power supply quality/power grid construction and the like), a third service type (arrearage and repose electricity registration/power supply reliability/electric short message/power supply facility and the like), acceptance content, acceptance time and the like.
When the index of 'Wan family complaint rate' is configured, the index data source is 95598 worksheet data table, and the statistical items are: the work order number/number of units/10000 x 100%, and the query conditions are as follows: service type = complaint or opinion, unit field: belonging to city, county, power supply station, classification field: a first service type, a second service type, a third service type, a time field: the reception time, the configuration descending order is shown as an example;
back-end algorithm logic: according to the index configuration ID, inquiring the configuration item of the index, and according to the statistics item, the data source, the unit field, the type field, the inquiring condition and the like, splicing SQL sentences, calculating the required index of the complaint opinion rate of the individual; and returning to the query condition area after query, and querying indexes according to units, types and time.
According to the index default configuration item, the first level defaults to display the complaint opinion rate of all the households in the whole city, the time dimension displays the complaint opinion rate of all the households in daily, after clicking a certain city unit of a pie chart or a bar chart, the complaint opinion rate of all the households in each county of the lower level unit is displayed by drilling downwards, and the county is clicked to continue drilling downwards to obtain the complaint opinion rate of all the households in each power supply station.
The index analysis module comprises an index management billboard, an index profile analysis module and an index detail analysis module;
the index management billboard is used for displaying key indexes set by a user, and each index displays index values, ranks and a latest seven-day trend chart of the unit.
In this embodiment, the number of indexes supported and displayed by the index management signboard is 9.
The index profile analysis module is used for analyzing index ranks (market ranks and county ranks), classification duty ratios and detail data of the corresponding indexes.
Wherein, the index ranking supports index ranking according to the city level, county level and multi-unit level. The market-level ranking shows the score ranking and the average value of all local cities in the province in the index; the county level rank shows the score rank and the average value of each county in the present index.
Classification duty ratio: and counting the duty ratio and the number of each business category in the index by adopting a fan-shaped statistical graph.
Detail data: and displaying the index detail data of each unit of the city level and the county level according to the index ranking, and supporting the export of the form data to the local.
Specifically, taking the statistical analysis of the index of "the complaint rate of the foreigner's opinion" as an example, the linkage process of index profile statistics is described in detail:
the index profiling module analyzes based on the configuration presentation hierarchy (city/county/institute).
When the configured level is a city level, the bar graph displays the index score value, the average value and the ranking of the complaint rate of the foreigner opinion of each unit of the city level;
the fan-shaped statistical graph displayed in linkage with the fan-shaped statistical graph can display data and the duty ratio of complaints of different categories of all municipal units. Such as what is the supply quality complaint volume/business hall complaint volume/service complaint volume, and the like, and what is the proportion in the market-level total complaint volume.
The detail data shows the number of units, annual complaint amount, the complaint rate and the ranking condition of the complaint rate of each individual unit in the market level. The detail data block area can also be configured with time, and the data of the whole index profile is displayed in a linkage way according to the configured time, so that the index analysis result is displayed from different dimensions.
The index detail analysis is used for carrying out work order analysis in multiple directions in a data linkage mode according to units, categories and trends;
wherein, unit statistics: and counting the number and the ranking of the index worksheets of the whole city and county company by using a sector statistical chart mode and counting the number and the ranking of the index worksheets of the whole city and county company by using a column statistical chart mode. The units support level penetration, the superior units can penetrate through the administered units, the sector graph and the column graph are penetrated in a linkage way, and the city, county and school ratio of each level is promoted to overtake.
Type statistics: and counting the number and the ranking of the index worksheets of the whole city and county company by using a sector statistical chart mode and counting the number and the ranking of the index worksheets of the whole city and county company by using a column statistical chart mode. The category supports the level penetration, the upper level category can penetrate the lower level category, and the sector graph and the bar graph are in linkage penetration.
And (3) time statistics: and the statistical analysis of index trends in three time dimensions of day, week and month is supported.
Specifically, taking a statistical analysis of "the rate of complaints of the foreigners" in a certain province as an example, the detailed analysis of the index details is used for analyzing the multidimensional linkage situation:
the index detail page can select a statistical time range, switch the time range, and link the type and unit statistics.
Firstly, the index detail analysis page is used for counting and displaying the number and the duty ratio of complaint worksheets in a period of time in each city of the province through a fan-shaped statistical chart, and the corresponding histogram is used for displaying the complaint worksheets in each city of the Shandong province.
Correspondingly, on the basis of all the complaint data of the worksheet in the province, the complaint worksheet type statistics also display the quantity and the duty ratio of all the types of the complaint worksheets in the period of the province by using a fan-shaped statistical chart, and display the worksheet data of all the complaint types, such as the power-saving quality/service quality complaint worksheet data, and the like, corresponding to the histogram.
The time trend graph displays a daily trend graph, a weekly trend graph and a monthly trend graph of the complaint rate of the ten minutes user in the period of time, so that the user can intuitively observe the index change trend.
The unit/type histograms of index detail pages all support level penetration, e.g., clicking on a city of the province may drill the data for that city into the city index detail page. Accordingly, both the type analysis and the time trend analysis are based on the market data for statistical analysis. Then clicking on a county in the city, the data of the county can be drilled, and the county index detail page is entered.
The index detail analysis page firstly analyzes the unit or the managed unit of the unit by unit dimension, and the number proportion and ranking of the index worksheets, the number proportion and ranking and trend of the worksheets in a period of time range; analyzing the first class or the second class according to class dimension, wherein the number, the duty ratio, the ranking, the trend of the class work orders in each unit of a time range list and the duty ratio, the ranking and the number of the class work orders in the total work orders; finally, taking time as a dimension, the index trend of the time range of the period, the ranking of the duty ratio number of each unit index and the ranking condition of the duty ratio number of each category of the index can be counted. Based on each dimension, the statistics of multiple angles view the statistics of units, types and time trends of the data.
And the index early warning module is used for checking abnormal data of the index according to the height of the index in the index analysis process, dispatching the abnormal work orders exceeding the threshold in real time, monitoring the dispatching correction process, and automatically generating work orders to be dispatched to the lower units for correction.
In this embodiment, in the indicator early warning module, the setting of the threshold includes: the index super-target value, the ranking reciprocal of the unit index of the same level, the trend/the same ratio/the ring ratio abnormality of the index data, and the like.
For example: setting a line loss professional long-term heavy loss index threshold, wherein the line loss of a platform area exceeding 20 days is more than 7 within 30 days, and the loss electric quantity is more than 50; setting a foreranking 3 and a penultimate subordinate unit by a service professional individual complaint opinion rate index threshold to respectively give different performance assessment coefficients; the threshold setting of the electric charge related index of the electric charge professional electric charge is often required to refer to the same-ratio ring ratio data and the like.
Further, timing screening indexes are configured according to the threshold value, abnormal work order details are located, and a dispatch procedure is automatically initiated according to workflow configuration.
The performance index management and control module is used for managing and controlling the display of the three-level indexes of the city, county and institute, and can visually check the current operation status of the city, county and institute.
The utility company index management and control page performs comparison analysis (namely, comparison with the quaternary ranking index on the unit and comparison with the brother unit index ranking) through two visual angles, and analyzes which index is poor and the reason of the poor.
The county company index management and control/power supply station index management and control page professionally displays the ranking and analysis conditions of the county company and the power supply station index, and assists the county company and the power supply station to analyze the advantage index and the disadvantage index.
Example two
As shown in fig. 3, the embodiment provides a power marketing management method based on a multi-dimensional linkage analysis of marketing indicators, which includes the following steps:
step 1: acquiring electric power marketing business data;
step 2: collecting the acquired marketing business data; uniformly processing the acquired electric power marketing business data into standard data suitable for index application;
step 3: presetting an index statistical item and an index query logic of the marketing business configuration to be analyzed according to an index configuration list;
step 4: based on the collected marketing business data, the index statistics items of the preset marketing business configuration to be analyzed and the index query logic, multidimensional linkage analysis and data drilling of marketing indexes are carried out, and the generated multidimensional linkage analysis result is positioned to a work order, so that the root cause of the problem is positioned and the problem is rectified.
Step 5: and checking abnormal data of the index according to the height of the index, dispatching the abnormal work orders exceeding the threshold in real time, monitoring the dispatching and modifying process, and automatically generating work orders to be dispatched to the lower level units for modifying.
The system supports two types of data access, one type is that data such as marketing 2.0, mining system and the like are accessed directly through a data center; secondly, the RPA flow robot technology is used for calling a data maintenance entry function provided by the system, and 95598 emergency repair work orders, station area line loss data and the like are imported into the system in the form of an Excel template.
In step 1, the marketing business data includes information such as a marketing business expansion whole flow, line loss management, inspection work orders, service work orders, measurement asset analysis, electricity charge and electricity price management and the like.
The standard data suitable for index application specifically comprises an index name, a unit to which the index belongs, an index value and an index date unified information format, and relates to units of city, county and third level, and one-level or multi-level business types of business types.
In step 2, the process of uniformly processing the obtained electric power marketing business data into standard data suitable for index application includes:
1) Establishing a standard data statistics table and an abnormal data table, wherein the fields of the standard data table comprise index types, primary units, secondary units, tertiary units, business primary, secondary and tertiary classifications, index data amounts, statistics time and the like; the exception data table is consistent with the original data table or key fields are reserved.
2) The original data table is processed by configuring sql statement or writing storage procedure, and processed data is stored in standard data statistics table and abnormal data table.
3) All index data related to the electric power marketing business can be summarized in a summary way, and can be divided into two types of ranking type and duty ratio type, and standard data processing is realized.
In step 4, the unit-category-time multidimensional linkage analysis of the electric power marketing index is specifically as follows:
analyzing the number proportion and ranking of the work orders of the index in a time range and the number proportion and ranking and trend of each work order category by using unit dimension; analyzing the first class or the second class by class dimension, wherein the number, the duty ratio, the ranking and the trend of the class worksheets and the duty ratio, the ranking and the number of the class worksheets in the total worksheets are in each unit of a period of time; and counting the index trend of the time range of the period, the ranking of the duty ratio number of each unit index and the ranking condition of the duty ratio number of each category of the index by using the time dimension.
In step 4, the data drilling is performed on the marketing indexes based on the collected marketing service data, the index statistics items of the preset marketing service configuration to be analyzed and the index query logic, and the method comprises the following steps:
1) The index configuration module, business index name, index data source, statistics item (combination of statistics field and summation/percentage function), inquiry condition, unit field, classification field, time field, ascending/descending order, etc., the detail data also needs to configure header field and header name of detail data item, in addition, the time range can be increased, and the dimension of inquiry display can be increased by whether the same ring ratio is adopted.
2) And the drilling interaction module is used for analyzing fixed parameters of the front-end page by indexes, wherein the fixed parameters comprise index configuration ID, units, types, time periods and keywords, and when the front-end data drilling interaction is performed, the field data are only required to be calculated by combining specific SQL sentences, and statistical data according to the units, the types and the time are returned.
3) Index drilling analysis, namely displaying unit index data of all secondary units of a primary unit lower level according to unit defaults, displaying index data of each category under the primary unit primary category according to category defaults, and displaying index data trend of the last month of the primary unit according to time defaults; meanwhile, the poor index under the same latitude can be obtained, and the lower-level classification index data can be further displayed.
And finally, positioning the generated multidimensional linkage analysis result to the detail of the abnormal work order, and further positioning the root cause of the problem and carrying out manual order dispatching correction.
In step 5, the setting of the threshold includes: the index super-target value, the ranking reciprocal of the unit index of the same level, the trend/the same ratio/the ring ratio abnormality of the index data, and the like.
For example: setting a line loss professional long-term heavy loss index threshold, wherein the line loss of a platform area exceeding 20 days is more than 7 within 30 days, and the loss electric quantity is more than 50; setting a foreranking 3 and a penultimate subordinate unit by a service professional individual complaint opinion rate index threshold to respectively give different performance assessment coefficients; the threshold setting of the electric charge related index of the electric charge professional electric charge is often required to refer to the same-ratio ring ratio data and the like.
Further, timing screening indexes are configured according to the threshold value, abnormal work order details are located, and a dispatch procedure is automatically initiated according to workflow configuration.
The above description is only of the preferred embodiments of the present invention and is not intended to limit the present invention, but various modifications and variations can be made to the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. Electric power marketing management system based on marketing index multidimensional linkage analysis, its characterized in that includes:
the data acquisition module is used for acquiring electric power marketing business data;
the index configuration module is used for presetting index statistics items and index query logic of the power marketing business configuration to be analyzed according to the index configuration list;
and the index analysis module is used for carrying out unit-category-time multidimensional linkage analysis and data drilling of the power marketing index based on the power marketing service data, the index statistics items of preset power marketing service configuration to be analyzed and index query logic, positioning the generated multidimensional linkage analysis result to a work order, and further positioning the root cause of the problem and carrying out problem correction.
2. The power marketing management system based on the marketing index multidimensional linkage analysis of claim 1, wherein the power marketing business data comprises marketing business expansion complete flow, line loss management, inspection work orders, service work orders, metered asset analysis, and electricity charge and electricity price management information.
3. The power marketing management system based on the multi-dimensional coordinated analysis of the marketing indicators of claim 1, further comprising a data collection module for uniformly processing the acquired power marketing business data into standard data suitable for the application of the indicators.
4. The power marketing management system based on the marketing indicator multidimensional linkage analysis of claim 1, wherein the indicator configuration module comprises an indicator algorithm configuration module, a management billboard configuration module, an indicator profile configuration module, and an indicator detail configuration module;
the index algorithm configuration module is used for configuring index calculation basis according to business logic of the electric power marketing business to be analyzed;
the management signboard configuration module is used for configuring data displayed in the management signboard;
the index profile configuration module is used for configuring index ranking, classification duty ratio and detail data of the corresponding indexes;
the index detail configuration module is used for configuring the index work order quantity and the duty ratio of corresponding indexes according to the statistics of units and service types and counting time trend diagrams according to time.
5. The power marketing management system based on the marketing indicator multidimensional linkage analysis of claim 1, wherein the indicator analysis module comprises an indicator profile analysis module and an indicator detail analysis module;
the index profile analysis module is used for analyzing index ranking, classification duty ratio and detail data of the corresponding indexes;
the index detail analysis module is used for carrying out work order analysis in multiple directions in a data linkage mode according to units, categories and trends.
6. The power marketing management system based on the multidimensional linkage analysis of marketing indicators according to claim 5, wherein in the indicator profile analysis module, the indicator ranking performs the indicator ranking according to a city level and a county level multi-unit level, and the city level ranking shows the score ranking and the average value of all local cities in the present indicator; the county level ranking shows the score ranking and the average value of each county in the present index of the present city;
the classification duty ratio adopts a fan-shaped statistical graph to count the duty ratio and the number of each business category in the index;
the detail data are index detail data for displaying units of the city level and the county level according to index ranking.
7. The power marketing management system based on the marketing index multidimensional linkage analysis according to claim 1, further comprising an index early warning module, wherein the index early warning module is used for checking abnormal data of the index according to the height of the index in the index analysis process, dispatching abnormal work orders exceeding a threshold value in real time, monitoring the dispatching and modifying process, and automatically generating work orders to be dispatched to lower units for modification.
8. The electric power marketing management method based on marketing index multidimensional linkage analysis is characterized by comprising the following steps of:
acquiring electric power marketing business data;
uniformly processing the acquired electric power marketing business data into standard data suitable for index application;
presetting an index statistical item and an index query logic of the power marketing business configuration to be analyzed according to an index configuration list;
based on the electric power marketing business data, the index statistics items of preset electric power marketing business configuration to be analyzed and the index query logic, unit-category-time multidimensional linkage analysis and data drilling of the electric power marketing indexes are carried out, and the generated multidimensional linkage analysis result is positioned to a work order, so that the root cause of the problem is positioned and the problem is rectified.
9. The power marketing management method based on the marketing index multidimensional linkage analysis of claim 8, wherein the unit-category-time multidimensional linkage analysis of the power marketing index is specifically as follows:
analyzing the number proportion and ranking of the work orders of the index in a time range and the number proportion and ranking and trend of each work order category by using unit dimension; analyzing the first class or the second class by class dimension, wherein the number, the duty ratio, the ranking and the trend of the class worksheets and the duty ratio, the ranking and the number of the class worksheets in the total worksheets are in each unit of a period of time; and counting the index trend of the time range of the period, the ranking of the duty ratio number of each unit index and the ranking condition of the duty ratio number of each category of the index by using the time dimension.
10. The power marketing management method based on the marketing index multidimensional linkage analysis according to claim 8, wherein in the index analysis process, abnormal data of the index is checked according to the height of the index, abnormal work orders exceeding a threshold value are dispatched in real time, the dispatch and modification process is monitored, and the work order dispatch to a lower unit is automatically generated for modification.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311044780.5A CN117035532A (en) | 2023-08-18 | 2023-08-18 | Electric power marketing management system and method based on marketing index multidimensional linkage analysis |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311044780.5A CN117035532A (en) | 2023-08-18 | 2023-08-18 | Electric power marketing management system and method based on marketing index multidimensional linkage analysis |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117035532A true CN117035532A (en) | 2023-11-10 |
Family
ID=88642785
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311044780.5A Pending CN117035532A (en) | 2023-08-18 | 2023-08-18 | Electric power marketing management system and method based on marketing index multidimensional linkage analysis |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117035532A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117291649A (en) * | 2023-11-27 | 2023-12-26 | 云南电网有限责任公司信息中心 | Intensive marketing data processing method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105447632A (en) * | 2015-11-17 | 2016-03-30 | 国网浙江省电力公司 | Electric power marketing inspection lean management and control quality evaluation method |
| CN106096865A (en) * | 2016-06-29 | 2016-11-09 | 国网浙江省电力公司 | A kind of power marketing industry expands whole process information disclosure and implements managing and control system integrated approach |
| CN106251237A (en) * | 2016-07-21 | 2016-12-21 | 国网吉林省电力有限公司 | Various dimensions method for early warning in power marketing process management |
| CN112463760A (en) * | 2020-10-28 | 2021-03-09 | 深圳供电局有限公司 | Information processing method, information processing device, computer equipment and storage medium |
| CN113590607A (en) * | 2021-09-29 | 2021-11-02 | 国网江苏省电力有限公司营销服务中心 | Electric power marketing report realization method and system based on report factor |
| CN115330404A (en) * | 2022-07-04 | 2022-11-11 | 国网河北省电力有限公司营销服务中心 | System and method for electric power marketing inspection |
-
2023
- 2023-08-18 CN CN202311044780.5A patent/CN117035532A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105447632A (en) * | 2015-11-17 | 2016-03-30 | 国网浙江省电力公司 | Electric power marketing inspection lean management and control quality evaluation method |
| CN106096865A (en) * | 2016-06-29 | 2016-11-09 | 国网浙江省电力公司 | A kind of power marketing industry expands whole process information disclosure and implements managing and control system integrated approach |
| CN106251237A (en) * | 2016-07-21 | 2016-12-21 | 国网吉林省电力有限公司 | Various dimensions method for early warning in power marketing process management |
| CN112463760A (en) * | 2020-10-28 | 2021-03-09 | 深圳供电局有限公司 | Information processing method, information processing device, computer equipment and storage medium |
| CN113590607A (en) * | 2021-09-29 | 2021-11-02 | 国网江苏省电力有限公司营销服务中心 | Electric power marketing report realization method and system based on report factor |
| CN115330404A (en) * | 2022-07-04 | 2022-11-11 | 国网河北省电力有限公司营销服务中心 | System and method for electric power marketing inspection |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117291649A (en) * | 2023-11-27 | 2023-12-26 | 云南电网有限责任公司信息中心 | Intensive marketing data processing method and system |
| CN117291649B (en) * | 2023-11-27 | 2024-02-23 | 云南电网有限责任公司信息中心 | Intensive marketing data processing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107609835B (en) | Power grid manpower configuration application system and method | |
| CN105574652B (en) | Intelligent power distribution network planning big data management and control system and method | |
| CN108764683B (en) | Power grid operation data analysis evaluation and report system | |
| CN108846691A (en) | Regional grain and oil market price monitoring analysing and predicting system and monitoring method | |
| CN104915456A (en) | Mass power utilization data mining method on the basis of data analysis system | |
| CN102567412A (en) | Method for processing computer-assisted network load analysis information | |
| CN102208064A (en) | Administrative collaborative approval system and approval method | |
| CN109359900A (en) | A kind of inspection management platform | |
| CN117035532A (en) | Electric power marketing management system and method based on marketing index multidimensional linkage analysis | |
| CN108876154B (en) | Power grid planning big data analysis system | |
| WO2019127823A1 (en) | Insurance premium evaluation method, device, terminal apparatus, and storage medium | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN106845855A (en) | A kind of system on paying taxes service integrated management | |
| CN113255307A (en) | Intelligent reporting method and system for power system | |
| CN104574207A (en) | Regional power grid electric quantity analyzing and counting system | |
| CN115330404A (en) | System and method for electric power marketing inspection | |
| CN107292413A (en) | Electric load analysing and predicting system based on big data and information fusion | |
| CN114092024A (en) | Investment project full-process management method and system | |
| CN107943835A (en) | It is a kind of to report and submit data analysis and taxis system for electric system | |
| CN112232662A (en) | Service monitoring system and method | |
| CN111708814A (en) | Data statistical method, device, equipment and medium | |
| CN106843656A (en) | A kind of data display and the method for interaction | |
| CN111489072A (en) | Big data management and analysis system based on city management | |
| CN111209329A (en) | Dynamic analysis method, device and system based on full-service volume price change path | |
| CN115204832A (en) | Full-flow electrical construction process monitoring method and system |
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 |