CN113934751B - Index value measuring method, equipment and computer readable storage medium - Google Patents
Index value measuring method, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN113934751B CN113934751B CN202111536949.XA CN202111536949A CN113934751B CN 113934751 B CN113934751 B CN 113934751B CN 202111536949 A CN202111536949 A CN 202111536949A CN 113934751 B CN113934751 B CN 113934751B
- Authority
- CN
- China
- Prior art keywords
- index
- data
- report
- current index
- score
- 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.)
- Active
Links
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/24—Querying
- G06F16/242—Query formulation
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Educational Administration (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Mathematical Physics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an index value measuring method, equipment and a computer readable storage medium, wherein the method comprises the following steps: determining a current index of a value to be measured, and acquiring category data and data set information of the current index; screening out high-level fields using current indexes from the data set information, and marking the high-level fields; acquiring an initial report using the data set information in the system, and screening a screened report using a current index or using a marked advanced field from the initial report; acquiring service condition data of a current index in a screened report and access data of the screened report; and respectively weighting the category data, the service condition data and the access quantity data according to a preset rule, and calculating the value measurement score of the current index. The invention realizes the effect of helping the client to intuitively know the index value in the actual service scene.
Description
Technical Field
The invention relates to the field of big data business intelligence, in particular to an index value measuring method, index value measuring equipment and a computer readable storage medium.
Background
In the big data BI (Business Intelligence) domain, data is often cleaned into data sets. When a data set represents data, different data indexes are generally divided into two categories, namely dimension and numerical value (numerical value indexes, which are not necessarily numbers, for example, the index of a judgment result may be ABC).
A data set may be used by different data analysts or clients in different BI charts, each data set containing many different indicators. In an actual business scenario, the actual values of different indexes to customers need to be known.
Disclosure of Invention
The invention mainly aims to provide an index value measuring method, and aims to solve the technical problem that in an actual service scene, actual values of different indexes on a client need to be known.
In order to achieve the above object, the present invention provides an index value measuring method, which comprises the following steps:
determining a current index of a value to be measured, and acquiring category data and data set information of the current index;
screening out high-level fields using current indexes from the data set information, and marking the high-level fields;
acquiring an initial report using the data set information in the system, and screening a screened report using a current index or using a marked advanced field from the initial report;
acquiring service condition data of a current index in a screened report and access data of the screened report;
and respectively weighting the category data, the service condition data and the access quantity data according to a preset rule, and calculating the value measurement score of the current index.
Optionally, the step of determining a current index of the value to be measured, and acquiring category data and data set information of the current index includes:
determining a current index of a value to be measured, and acquiring index information of the current index;
acquiring current index type data according to the index type in the index information;
and sending a network request to a system according to the data set identification number in the index information to acquire the data set information of the current index.
Optionally, the step of screening out a high-level field using a current index from the data set information, and the step of marking the high-level field includes:
screening all the standby high-level fields from the data set information;
acquiring the information of the high-level field to be used, and screening out the high-level field using the current index according to the index identification number contained in the high-level field expression in the information of the high-level field to be used;
the high-level fields that use the current index are marked.
Optionally, the step of obtaining an initial report using the data set information in the system, and the step of screening a screened report using the current index or using the marked high-level field in the initial report includes:
acquiring all reports to be used in the system;
screening out an initial report using the data set information from the standby report according to the data set information used by the report;
and screening the screened reports using the current indexes or the marked high-level fields in the initial report according to the index information and the high-level field information used by the reports.
Optionally, the step of respectively weighting the category data, the usage data, and the access amount data according to a preset rule, and calculating the value measure score of the current index includes:
in each screened report, calculating partial value measurement scores of the current indexes according to the category data, the use condition data, the access amount data and corresponding weighting rules;
and accumulating partial value measurement scores in all the screened reports to obtain the total value measurement score of the current index, wherein the total value measurement score is used as the value measurement score of the current index of the system.
Optionally, the step of calculating, in each of the filtered reports, a partial value measurement score of a current index according to the category data, the usage data, the visit amount data, and the corresponding weighting rule includes:
in each screened report, respectively obtaining a category score, a use condition score and an access amount score according to the category data, the use condition data, the access amount data and corresponding empowerment rules;
and multiplying the category score, the service condition score and the visit amount score to obtain a partial value measurement score of the current index.
Optionally, the step of obtaining, in each of the filtered reports, a category score, a usage score, and a visit amount score according to the category data, the usage data, the visit amount data, and the corresponding weighting rule includes:
setting the weight of the dimension class index as a1 and the weight of the numerical class index as a 2;
if the category of the current index is determined to be a dimension based on the category data, the category score is a1, and if the category of the current index is determined to be a numerical value based on the category data, the category score is a 2;
the weight of the pointer used in the high-level field is set as b1, and the weight used directly is set as b 2;
if the current index is determined to be used in the high-level field based on the usage data, the usage score is b1, if the current index is determined to be used directly based on the usage data, the usage score is b2, if the current index is determined to be used both in the high-level field and directly based on the usage data, the usage score is b1 plus b 2;
setting the weight of the total access amount to c1 and the weight of the latest access amount to c 2;
and acquiring the total visit amount and the latest visit amount of the screened report based on the visit amount data, wherein the total visit amount is multiplied by c1 plus the latest visit amount multiplied by c2 to obtain a visit amount score.
Optionally, after the step of respectively weighting the category data, the usage data, and the access amount data according to a preset rule and calculating the value measure score of the current index, the method further includes:
and outputting a value measurement score report of the current index, wherein the report comprises the index category data, the use condition data, the visit amount data and the value measurement score of the current index.
In addition, to achieve the above object, the present invention also provides a terminal device, including: a memory, a processor and a computer program stored on the memory and executable on the processor, the computer program configured to implement the steps of the indicator value measurement method as described above.
Further, to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the index value measuring method as described above.
The method comprises the steps of determining a current index of value to be measured, obtaining index information of the current index, obtaining category data and data set information of the current index according to an index type and a data set identification number in the current index information, screening out a high-level field using the current index from the data set information, marking the high-level field, obtaining a report using the data set in a system, screening out a report using the current index or the marked high-level field, obtaining use condition data of the current index in the screened report, total access amount data and latest access amount data of the screened report, respectively weighting the category data, the use condition data and the access amount data, and calculating a value measurement score of the current index. The method realizes objective quantification of index value, and helps customers to intuitively know the value of different indexes in an actual service scene.
Drawings
Fig. 1 is a schematic structural diagram of a terminal device in a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a first embodiment of the index value measurement method according to the present invention;
FIG. 3 is a detailed flowchart of step S100 in FIG. 2;
FIG. 4 is a detailed flowchart of step S200 in FIG. 2;
FIG. 5 is a detailed flowchart of step S300 in FIG. 2;
FIG. 6 is a detailed flowchart of step S500 in FIG. 2;
FIG. 7 is a detailed flowchart of step S501 in FIG. 6;
FIG. 8 is a detailed flowchart of step S503 in FIG. 7;
fig. 9 is a schematic flowchart after step S500 in fig. 2.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
BI is a set of techniques used to help enterprises better utilize data to improve decision quality, and simply it is a process of business, data value applications. The BI report is a report provided by integrating existing data in an enterprise. A BI report is created using a data set that includes a number of different indicators. In an actual business scene, a client needs to know the value of different indexes and help an enterprise operation analysis decision.
Since the BI report can visually display information about the name, value, type, and the like of the used index, the client can subjectively judge the value of the index through the information, or measure the value of the index by combining the access data of the report. Subjective judgment and simple report access data measurement index values are obviously not accurate enough.
The main technical scheme of the invention is as follows: determining a current index of a value to be measured, and acquiring category data and data set information of the current index; screening out high-level fields using current indexes from the data set information, and marking the high-level fields; acquiring an initial report using the data set information in the system, and screening a screened report using a current index or using a marked advanced field from the initial report; acquiring service condition data of a current index in a screened report and access data of the screened report; and respectively weighting the category data, the service condition data and the access quantity data according to a preset rule, and calculating the value measurement score of the current index. The objective quantification of the index value is realized, and the client can be helped to intuitively know the value levels of different indexes in an actual service scene.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a terminal device in a hardware operating environment according to an embodiment of the present invention.
As shown in fig. 1, the terminal device may include: a processor 1001, such as a Central Processing Unit (CPU), a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a WIreless interface (e.g., a WIreless-FIdelity (WI-FI) interface). The Memory 1005 may be a Random Access Memory (RAM) Memory, or may be a Non-Volatile Memory (NVM), such as a disk Memory. The memory 1005 may alternatively be a storage device separate from the processor 1001.
Those skilled in the art will appreciate that the configuration shown in fig. 1 does not constitute a limitation of the terminal device and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of storage medium, may include therein an operating system, a data storage module, a network communication module, a user interface module, and a computer program.
In the terminal device shown in fig. 1, the network interface 1004 is mainly used for data communication with other devices; the user interface 1003 is mainly used for data interaction with a user; the processor 1001 and the memory 1005 in the terminal device of the present invention may be disposed in the terminal device, and the terminal device calls the computer program stored in the memory 1005 through the processor 1001 and executes the index value measurement method provided by the embodiment of the present invention.
An embodiment of the present invention provides an index value measurement method, and referring to fig. 2, fig. 2 is a schematic flow chart of a first embodiment of the index value measurement method of the present invention.
In this embodiment, the index value measurement method includes:
step S100, determining a current index of a value to be measured, and acquiring category data and data set information of the current index;
after the current index of the value to be measured is determined, index information of the current index can be obtained. The contents contained in the index information are: id (index identification number), name (index name), value (index value), type (index type), and datasetid (data set identification number). Wherein, type includes dim (dimension) and num (numerical value). According to the type information, the current index category data can be obtained.
In the field of big data, an ETL (Extract-Transform-Load) tool is often used to perform a cleaning process on source data to obtain a data set. Different metrics are used when the data sets represent data. The indexes come from a data set, the index information comprises a data set id, and a network request can be sent to the system according to the data set id to obtain the data set information of the current index.
S200, screening out advanced fields using current indexes from the data set information, and marking the advanced fields;
the data set information contains the following contents: id (dataset identification number), name (dataset name), quotaField (index field), advanced field (advanced field).
A data set may contain multiple index fields and high level fields. To determine whether the current index is used in the high-level field, all high-level field ids need to be screened from the data set information. And acquiring the information of the high-level field according to the screened high-level field id.
The contents contained in the information of the high-level fields are: id (high level field identification number), name (high level field name), expression (high level field expression). The expression includes index id, value, and operation used by the high-level field
If the index id of the expression in the information of the high-level field contains the current index id, the current index can be judged to be used in the high-level field.
The expression of the high-level field can reflect the use condition of the high-level field to the index, and the mode for marking the high-level field can be the mode for marking the expression of the high-level field.
Step S300, acquiring an initial report using the data set information in the system, and screening a screened report using the current index or using the marked advanced field from the initial report;
because the purpose of making reports is different, one data set may be used by multiple reports, and to know the use condition of the indexes in the data set in the reports, all the reports to be used in the system need to be obtained first, and the reports to be used are screened.
In the previous step, the data set id is obtained according to the current index information, if the data set information used by the standby report contains the data set id of the current index, the standby report can be judged to use the data set of the current index, and the report is defined as an initial report.
Further, in order to know the use condition of the index in the report, the initial report needs to be screened again to obtain a screened report which directly uses the current index or indirectly uses the current index through a high-level field.
If the index information used by the report contains the current index id, the report can be regarded as directly using the current index; if the information of the high-level fields used by the report contains the marked high-level fields, the report can be regarded as indirectly using the current indexes through the high-level fields. The situation that the current index is directly used and the current index is indirectly used through a high-level field can occur in a report.
Step S400, obtaining the service condition data of the current index in the screened report and the access data of the screened report;
the use of the index in the report can be divided into direct use and indirect use through high-level fields. The reported visitation data is mainly total visitation and latest visitation.
The use condition of the index in the report can reflect the relative importance degree of the index in the report. When the index is directly used in the report, the index is important and needs to be directly presented. When an index is used indirectly in a report through a high level field, the relative importance level indicating the index is low and is presented as part of the high level field.
The access data of the report can reflect the attention degree of the report. The BI report has timeliness, so the total visit amount and the latest visit amount data should be comprehensively considered. The total access amount reflects that the report is concerned, and indexes used in the report have value. The recent access amount indicates that the report is concerned, and the importance degree of indexes used in the report is high. The time period of the last access may depend on the specific service, such as a week, a quarter, a year, etc.
And step S500, respectively weighting the category data, the service condition data and the access amount data according to a preset rule, and calculating the value measurement score of the current index.
The index category is divided into dimension and numerical value, the index use condition is divided into direct use and use in a high-level field, and the report access amount is divided into total access amount and recent access amount.
The index class weight of the dimension class index is set as a1, and the index class weight of the numerical class index is set as a 2. The metric use weight of the metric used in the high-level field is set to b1, and the metric use weight of the metric used directly is set to b 2. And setting the access quantity weight of the report total access quantity to c1, and setting the access quantity weight of the report recent access quantity to c 2.
The process of calculating the current index value measurement score may be: and calculating partial value measurement scores in each report, and accumulating the partial value measurement scores of all the screened reports to obtain a total value measurement score serving as the current index value measurement score.
For example, the entitlement rule is set as follows: a1 is 1, a2 is 2, b1 is 1, b2 is 2, c1 is 1, c2 is 3;
and calculating the value measurement score of the index A according to the weighting rule and the data of the index A in the following table 1.
Table 1:
in this embodiment, according to current index information, category and data set information of the current index is acquired, a high-level field using the current index is screened out from the high-level field of the data set and marked, a report using the data set in a system is acquired, a report using the current index or the marked high-level field is screened out, total visit volume and recent visit volume of the screened report are acquired, and according to a preset rule, index category data, index use condition data and report visit volume data are weighted, and a value measurement score of the current index is calculated. And value measurement is performed on the indexes by using various data closely related to the indexes, and the indexes are visually displayed in a scoring mode, so that a client can be helped to quickly know the value of the current indexes in an actual service scene.
Further, in another embodiment of the method for measuring the value of the index of the present invention, referring to fig. 3, step S100 determines a current index of the value to be measured, and obtains category data and data set information of the current index, including:
step S101, determining a current index of a value to be measured, and acquiring index information of the current index;
in actual business scenarios, BI reports are often used to help enterprises make analytical decisions. When the BI report is made, the data set, the index, the high-level field and the like used by the BI report are determined. The general index name can be visually seen in the BI report, and when the current index of the value to be measured is determined, the current index name can be determined firstly. And acquiring the index information of the current index through the name of the current index.
Step S102, obtaining current index type data according to the index type in the current index information;
the contents contained in the index information are: id (index identification number), name (index name), value (index value), type (index type), and datasetid (data set identification number). Wherein, type includes dim (dimension) and num (numerical value). According to the type information, whether the current index category is dimension or numerical value can be acquired.
Step S103, according to the data set identification number in the current index information, sending a network request to the system, and acquiring the data set information of the current index.
The index is a data set representation data mode, the index information comprises a data set id, and according to the data set id, a network request can be sent to the system to obtain the data set information of the current index.
In this embodiment, the category data and the data set information of the current index can be obtained through the index type and the data set id in the index information, and the process of index value measurement is simplified.
Further, in another embodiment of the method for measuring the value of the index according to the present invention, referring to fig. 4, step S200 is to screen out a high-level field using the current index from the data set information, and mark the high-level field, including:
step S201, screening all high-level fields in the data set information;
the data set information contains the following contents: id (dataset identification number), name (dataset name), quotaField (index field), advanced field (advanced field).
When using data in a dataset, often not only dimension and index data is used directly, but some high-level indices may be used. The high-level index is composed of dimension, numerical value and certain limiting rule. Because the BI report forms are made in different demands, the high-level indexes defined in different report forms are different. Among the fields of the data set, the field containing the high-level index is a high-level field. There may be multiple high-level fields in each dataset.
Step S202, obtaining the information of the high-level field to be used, and screening out the high-level field using the current index according to the index identification number contained in the high-level field expression in the information of the high-level field to be used;
the contents contained in the high-level field information are: id (high level field identification number), name (high level field name), expression (high level field expression). The expression includes index id, value (comparison value), and operation used in the high-level field. For each index used in the high-level field, there is a definition in the expression, which is composed of id, value and operation of the index, and these definitions constitute the restriction rule of the high-level field. If the index id used in the high-level field expression contains the current index id, the high-level field uses the current index and accords with the screening standard.
Step S203, marking the high-level field using the current index.
The expression of the high-level field contains the used index id, the index id is the basis for judging whether the high-level index uses the current index, and the high-level field can be marked by adopting a mode of marking the expression.
In the embodiment, the use of the high-level field containing the current index is also a way to use the current index, and when the use condition of the current index is considered, the accuracy of index value measurement can be increased by combining the direct use and the use of the high-level field.
Further, in another embodiment of the method for measuring index value of the present invention, referring to fig. 5, step S300 obtains an initial report using the data set information in the system, and screens a screened report using the current index or using the marked high-level field in the initial report, including:
step S301, acquiring all reports to be used in the system;
the system comprises various reports, data sets and other different types of data, and all reports in the system need to be acquired as standby reports when the reports using the data sets to which the current indexes belong are screened out.
Step S302, according to the data set information used by the report, screening out an initial report using the data set information from the to-be-used report;
each report is often made using a single data set, while different reports may use the same data set. Even reports made using the same data set will vary due to the different purposes for which the reports are made. And if the data set information used by the report to be used is the data set information, the data set information accords with the screening standard, and the screened report is an initial report using the data set.
Step S303, according to the index information and the information of the high-level fields used by the report, the screened report using the current index or the marked high-level fields is screened from the initial report.
If the index information used by the initial report contains the current index information, the initial report uses the current index. If the information of the high-level field used by the initial report contains the expression of the marked high-level field, the initial report uses the marked high-level field, namely the current index is used in the high-level field. In each initial report, the current indicator may be used both directly and in the high-level fields.
In this embodiment, the initial report using the data set is screened from all the reports to be used, and then the screened report directly using the current index or using the current index in the high-level field is screened from the initial report, so that the efficiency of obtaining the screened report is improved.
Further, in another embodiment of the method for measuring the value of the index according to the present invention, referring to fig. 6, step S500 separately weights the category data, the usage data, and the access data according to a preset rule, and calculates a value measurement score of the current index, including:
step S501, calculating partial value measurement scores of current indexes in each screened report according to the category data, the use condition data, the access amount data and corresponding weighting rules;
after the category of the current index is determined according to the index information of the current index, the service condition data and the access amount data are obtained through the screened reports, and the value measurement score of the current index in each screened report can be obtained by matching with the corresponding weighting rule and is used as the partial value measurement score of the current index.
Step S502, accumulating the partial value measurement scores in all the screened reports to obtain the total value measurement score of the current index, which is used as the value measurement score of the current index of the system.
The partial value measurement scores in each screened report are independent from each other, the partial value measurement scores of all the screened reports are connected in an accumulation mode, and the accumulated result is used as the value measurement score of the current index.
In this embodiment, a partial value measurement score of the current index in each screened report is calculated, then all partial value measurement scores are accumulated to obtain a value measurement score of the current index, and the process of calculating the value measurement score of the current index is divided into reports to be executed, so that the whole calculation process is performed orderly.
Further, in another embodiment of the method for measuring the value of the index according to the present invention, referring to fig. 7, step S501 is to calculate a partial value measurement score of the current index in each of the filtered reports according to the category data, the usage data, the visit amount data and the corresponding weighting rule, including:
step S503, in each screened report, obtaining a category score, a use condition score and a visit amount score respectively according to the category data, the use condition data, the visit amount data and corresponding empowerment rules;
the data used for calculating the current index value measurement score is mainly category data, use condition data and visit amount data, and the results obtained by using the three types of data and the corresponding weighting rules can be defined as the category score, the use condition score and the visit amount score.
And step S504, multiplying the category score, the service condition score and the visit amount score to obtain a partial value measurement score of the current index.
The data used by the category score and the use case score does not contain numerical values, can be regarded as a weight part of the partial value measurement score, the visit amount score contains specific numerical values, and can be regarded as a numerical part of the partial value measurement score, and the weight part and the numerical part are multiplied to obtain the partial value measurement score of the current index.
In this embodiment, the category score, the usage score, and the visit amount score are obtained first, and then the three scores are multiplied to obtain the partial value measurement score of the current index. The method embodies the relationship between the category score, the use case score, the visit amount score and the partial value measurement score of the current index, and simplifies the process of calculating the partial value measurement score.
Further, in another embodiment of the method for measuring index value according to the present invention, referring to fig. 8, step S503 is to respectively weight the category data, the usage data, and the access data in each filtered report according to a preset rule, and calculate a value measurement score of a current index, including:
step S505, setting the weight of the dimension index as a1 and the weight of the numerical index as a 2;
the dimension index includes mostly information of a certain category, a certain description information, and the like, such as a division name and a division type. The numerical class index contains information of specific data, such as age and height.
In an actual service scene, the importance degree of the dimension type index is always lower than that of the numerical type index, and when the two types of indexes are weighted, the proportion interval of a1 and a2 is 1:1-1: 4.
Step S506, if the category of the current index is determined to be dimension based on the category data, the category is classified as a1, and if the category of the current index is determined to be numerical value based on the category data, the category is classified as a 2;
for example, if the current index is gender, a1 is set to 1, a2 is set to 2, and in the index information of the index of gender, the index type is dim, then the category of the current index is dimension, and the category score is 1.
Step S507, setting the weight of the index used in the high-level field to b1, and the weight used directly to b 2;
the index is used in the high-level field, which means that the index is a part of the high-level field, and is an indirect use, for example, if the high-level field is defined as a retired female employee, the two indexes of gender and age are indirectly used in the high-level field. The direct use of the index means that the index is highly important and needs to be directly presented.
In an actual service scene, the importance degree of the index when the index is used in the high-level field is always lower than that of the index when the index is directly used, and when the two index use cases are weighted, the proportion interval of b1 and b2 is 1:1-1: 4.
Step S508, if the current index is determined to be used in the high-level field based on the usage data, the usage score is b1, if the current index is determined to be directly used based on the usage data, the usage score is b2, if the current index is determined to be used in the high-level field as well as directly used based on the usage data, the usage score is b1 plus b 2;
for example, if the current index is age, b1 is set to 1, b2 is set to 1.5, and the age is determined based on usage data to be used in the high-level field "adult college student", then the usage score is 1.
Step S509, setting the weight of the total visit amount to c1 and the weight of the latest visit amount to c 2;
the reported visitation data includes the total visitation and the latest visitation. The total access amount indicates that the report is concerned, the used index has value, and the recent access amount indicates that the report is concerned in a preset time period, so that the importance degree is high.
In an actual business scene, the importance degree of the total access amount is always lower than the latest access amount, and when the two access amounts are weighted, the proportion interval of c1 and c2 is 1:1-1: 4.
Step S510, acquiring the total visit amount and the latest visit amount of the screened report based on the visit amount data, and multiplying the total visit amount by c1 and adding the latest visit amount by c2 to obtain a visit amount score.
For example, c1 is set to be 1, c2 is set to be 3, the total access amount is 100 based on the access amount data, and the latest access amount is 70, so that the access amount score is 100 × 1+70 × 3= 310.
In the embodiment, the index type, the index use condition and the report access amount are respectively weighted and then calculated according to the preset rule, and the weighting rule can be adjusted according to the customer requirements to adapt to the condition in the actual service scene.
Further, in another embodiment of the method for measuring index value according to the present invention, referring to fig. 9, after the step S500 respectively weights the index category data, the index usage data, and the report access data according to a preset rule, and calculates the current index value measurement score, the method further includes:
step S600, outputting a value measurement score report of the current index, wherein the report comprises any one or more of an index information part, a data set information part, a high-level field information part and a report data part, and the value measurement score part.
In the index value measurement score report, the index information part may include any one or more of an index identification number, an index name, an index value, an index type, and a data set identification number. The data set information portion may contain any one or more of a data set identification number, a data set name, a pointer field, and a high level field. The high level field information section may contain any one or more of a high level field identification number, a high level field name, and a high level field expression. The report information section may contain any one or more of a report name, a data set name used by the report, a high level field used by the report, and report visit volume data. The value measurement score part comprises a value measurement score calculation result and can also comprise a value measurement score calculation process.
And after the value measurement score of the current index is calculated, importing various information or data of the current index into each part of the report to generate a value measurement score report of the current index. Each value measurement report can contain a plurality of current indexes, and the information or data of the current indexes can be listed in a mutually independent form or presented in a form of parallel comparison. The file format of the output value measurement score report can be Word, Excel, PDF, TXT and the like.
In this embodiment, outputting the value measurement score report may help the client to understand the process of calculating the value measurement score, and increase the reliability of the calculation result. The value measurement scores of the multiple indexes are combined in one report, so that the client can be helped to quickly compare different values of the multiple indexes, and the comparison time is saved.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (9)
1. An index value measuring method is characterized by comprising the following steps:
determining a current index of a value to be measured, and acquiring category data and data set information of the current index;
screening out a high-level field using a current index from the data set information, and marking the high-level field, wherein the high-level field comprises id, name and expression;
acquiring an initial report using the data set information in the system, and screening a screened report using a current index or using a marked advanced field from the initial report;
acquiring service condition data of a current index in a screened report and access data of the screened report;
respectively weighting the category data, the service condition data and the access amount data according to a preset rule, and calculating a value measurement score of the current index, wherein the weight of the dimension index is set as a1, and the weight of the numerical index is set as a 2;
if the category of the current index is determined to be a dimension based on the category data, the category score is a1, and if the category of the current index is determined to be a numerical value based on the category data, the category score is a 2;
the weight of the pointer used in the high-level field is set as b1, and the weight used directly is set as b 2;
if the current index is determined to be used in the high-level field based on the usage data, the usage score is b1, if the current index is determined to be used directly based on the usage data, the usage score is b2, if the current index is determined to be used both in the high-level field and directly based on the usage data, the usage score is b1 plus b 2;
setting the weight of the total access amount to c1 and the weight of the latest access amount to c 2;
and acquiring the total visit amount and the latest visit amount of the screened report based on the visit amount data, wherein the total visit amount is multiplied by c1 plus the latest visit amount multiplied by c2 to obtain a visit amount score.
2. The method for measuring the value of an index according to claim 1, wherein the step of determining the current index of the value to be measured and acquiring the category data and the data set information of the current index comprises:
determining a current index of a value to be measured, and acquiring index information of the current index;
acquiring current index type data according to the index type in the index information;
and sending a network request to a system according to the data set identification number in the index information to acquire the data set information of the current index.
3. The method of metric value measurement of claim 1 wherein said step of screening said dataset information for high level fields using current metrics comprises the step of:
screening all the standby high-level fields from the data set information;
acquiring the information of the high-level field to be used, and screening out the high-level field using the current index according to the index identification number contained in the high-level field expression in the information of the high-level field to be used;
the high-level fields that use the current index are marked.
4. The method of index value measurement according to claim 1, wherein the obtaining system uses an initial report of the dataset information, and the step of screening the screened report using the current index or using the marked high-level field in the initial report comprises:
acquiring all reports to be used in the system;
screening out an initial report using the data set information from the standby report according to the data set information used by the report;
and screening the screened reports using the current indexes or the marked high-level fields in the initial report according to the index information and the high-level field information used by the reports.
5. The method for measuring the value of an index according to claim 1, wherein the step of calculating the value measurement score of the current index by respectively weighting the category data, the usage data and the access amount data according to a preset rule comprises:
in each screened report, calculating partial value measurement scores of the current indexes according to the category data, the use condition data, the access amount data and corresponding weighting rules;
and accumulating partial value measurement scores in all the screened reports to obtain the total value measurement score of the current index, wherein the total value measurement score is used as the value measurement score of the current index of the system.
6. The method of claim 5, wherein the step of calculating the partial value measure score of the current index in each of the filtered reports based on the category data, the usage data, the access data, and the corresponding weighting rules comprises:
in each screened report, respectively obtaining a category score, a use condition score and an access amount score according to the category data, the use condition data, the access amount data and corresponding empowerment rules;
and multiplying the category score, the service condition score and the visit amount score to obtain a partial value measurement score of the current index.
7. The method for measuring the value of an index according to any one of claims 1 to 6, wherein after the step of calculating the value measurement score of the current index by respectively weighting the category data, the usage data and the access data according to a preset rule, the method further comprises:
and outputting a value measurement score report of the current index, wherein the report comprises any one or more of an index information part, a data set information part, a high-level field information part and a report information part, and the value measurement score part.
8. A terminal device, characterized in that the terminal device comprises: memory, processor and computer program stored on the memory and executable on the processor, the computer program being configured to implement the steps of the indicator value measurement method of any of claims 1 to 7.
9. A computer-readable storage medium, having stored thereon a computer program which, when being executed by a processor, carries out the steps of the index value measurement method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111536949.XA CN113934751B (en) | 2021-12-16 | 2021-12-16 | Index value measuring method, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111536949.XA CN113934751B (en) | 2021-12-16 | 2021-12-16 | Index value measuring method, equipment and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113934751A CN113934751A (en) | 2022-01-14 |
| CN113934751B true CN113934751B (en) | 2022-03-01 |
Family
ID=79289106
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111536949.XA Active CN113934751B (en) | 2021-12-16 | 2021-12-16 | Index value measuring method, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113934751B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116187814A (en) * | 2022-12-26 | 2023-05-30 | 广州城市规划技术开发服务部有限公司 | Data value calculation method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108399453A (en) * | 2018-01-24 | 2018-08-14 | 国家电网公司 | A kind of Electric Power Customer Credit Rank Appraisal method and apparatus |
| CN110046984A (en) * | 2019-03-01 | 2019-07-23 | 安徽省优质采科技发展有限责任公司 | Enterprise credit risk system and evaluation method |
| CN110188997A (en) * | 2019-05-13 | 2019-08-30 | 赣州和永软件开发有限责任公司 | A kind of construction quality cruising resource content evaluation method and its system |
| CN110516901A (en) * | 2019-07-06 | 2019-11-29 | 国网浙江省电力有限公司电力科学研究院 | Customer value hierarchical mode building system and client's layered approach based on big data |
| CN113361980A (en) * | 2021-08-10 | 2021-09-07 | 浩鲸云计算科技股份有限公司 | Big data asset value evaluation system and method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9798833B2 (en) * | 2013-12-30 | 2017-10-24 | Sap Ag | Accessing information content in a database platform using metadata |
-
2021
- 2021-12-16 CN CN202111536949.XA patent/CN113934751B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108399453A (en) * | 2018-01-24 | 2018-08-14 | 国家电网公司 | A kind of Electric Power Customer Credit Rank Appraisal method and apparatus |
| CN110046984A (en) * | 2019-03-01 | 2019-07-23 | 安徽省优质采科技发展有限责任公司 | Enterprise credit risk system and evaluation method |
| CN110188997A (en) * | 2019-05-13 | 2019-08-30 | 赣州和永软件开发有限责任公司 | A kind of construction quality cruising resource content evaluation method and its system |
| CN110516901A (en) * | 2019-07-06 | 2019-11-29 | 国网浙江省电力有限公司电力科学研究院 | Customer value hierarchical mode building system and client's layered approach based on big data |
| CN113361980A (en) * | 2021-08-10 | 2021-09-07 | 浩鲸云计算科技股份有限公司 | Big data asset value evaluation system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113934751A (en) | 2022-01-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9230239B2 (en) | Method and system for providing performance metrics | |
| US10728284B2 (en) | Methods and apparatus to assess compliance of a computing resource in a virtual computing environment | |
| US12002063B2 (en) | Method and system for generating ensemble demand forecasts | |
| US11170391B2 (en) | Method and system for validating ensemble demand forecasts | |
| Lui et al. | Qualitative business surveys: signal or noise? | |
| CN112000747B (en) | Data multidimensional analysis method, device and system | |
| WO2016155514A1 (en) | Logistics service scheduling method and device | |
| US11295324B2 (en) | Method and system for generating disaggregated demand forecasts from ensemble demand forecasts | |
| CN109753808B (en) | Privacy leakage risk assessment method and device | |
| CN111177533A (en) | Method and equipment for generating converged media influence analysis report | |
| CN110753920A (en) | System and method for optimizing and simulating web page ranking and traffic | |
| US20190019131A1 (en) | System and method for comparing enterprise performance using industry consumer data in a network of distributed computer systems | |
| CN113934751B (en) | Index value measuring method, equipment and computer readable storage medium | |
| KR102507411B1 (en) | Method of providing report on performance of advertisement campaign | |
| US20140179354A1 (en) | Determining contact opportunities | |
| WO2020086872A1 (en) | Method and system for generating ensemble demand forecasts | |
| JP2015230594A (en) | Opinion utilization support device and opinion utilization support method | |
| CN112287208A (en) | User portrait generation method and device, electronic equipment and storage medium | |
| CN115730019A (en) | Cloud product data processing method and device, electronic equipment and readable storage medium | |
| CN115033456A (en) | Method and device for monitoring performance of front end of intranet, computer equipment and storage medium | |
| KR20160133871A (en) | Method and apparatus of sharing and providing stock information | |
| US11973841B2 (en) | System and method for user model based on app behavior | |
| US9009073B1 (en) | Product availability check using image processing | |
| CN108109002B (en) | Data processing method and device | |
| US20160092999A1 (en) | Methods and systems for information exchange with a social network |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |