System and method for multi-dimensional average-weighted banding status and scoring
First Claim
1. A computer-implemented method for generating summary scores from heterogeneous measures, the method comprising:
- determining a first position of a first value within a first scale, wherein the scale is banded by a lower bound value and an upper bound value and the first value corresponds to a first measure of the heterogeneous measures;
translating the first value to a second normalized value, wherein the second normalized value corresponds to a second position within a second scale such that the second normalized value corresponds to a score for the first value; and
translating the second normalized value to a third weighted value, wherein the third weighted value takes into consideration an assigned weight relative to other measures of the same parent node;
rolling up the third weighted value with additional weighted values corresponding to additional measures of the heterogeneous measures such that the summary score is generated.
3 Assignments
0 Petitions
Accused Products
Abstract
Method and system for generating summary scores from heterogeneous measures retrieved from multi-dimensional data structures for monitoring organizational performance. Scorecards are created for each group of tree-structured measures branching from Parent nodes to child nodes based on Key Performance Indicators (KPI). Scores for each parent node may be obtained by rolling up scores for child nodes reporting to the parent node. KPI'"'"'s at the lowest level are mapped on first scale, then mapped to a normalized scale, and score values determined. KPI scores are weight-averaged for roll-up to a parent node determining the score for that node. Multiple parent nodes may be rolled-up to a higher level node in a similar way. Multiple dimensions of the measure such as geographic and temporal may be scored simultaneously.
-
Citations
20 Claims
-
1. A computer-implemented method for generating summary scores from heterogeneous measures, the method comprising:
-
determining a first position of a first value within a first scale, wherein the scale is banded by a lower bound value and an upper bound value and the first value corresponds to a first measure of the heterogeneous measures;
translating the first value to a second normalized value, wherein the second normalized value corresponds to a second position within a second scale such that the second normalized value corresponds to a score for the first value; and
translating the second normalized value to a third weighted value, wherein the third weighted value takes into consideration an assigned weight relative to other measures of the same parent node;
rolling up the third weighted value with additional weighted values corresponding to additional measures of the heterogeneous measures such that the summary score is generated. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer-readable medium that includes computer-executable instructions for generating summary scores from heterogeneous measures stored in a multi-dimensional hierarchy structure, the instructions comprising:
-
retrieving data associated with at least one measure from a multi-dimensional database;
determining an actual scale between a lower bound value and an upper bound value for the measure that includes a predetermined number of actual bands;
assigning a value within one of the actual bands to the retrieved data based on a comparison of the data with the actual scale;
determining a band percentage value based on dividing a distance between a lower boundary of the actual band, in which the value is assigned and the value by a length of the actual band;
establishing an evenly distributed scale comprising a number of evenly distributed bands, wherein a number of the evenly distributed bands is the same as the number of actual bands, and wherein boundaries of the evenly distributed bands are equidistant;
mapping a new value on the evenly distributed scale to the value on the actual scale;
determining a total band distance by subtracting a lower boundary value of an evenly distributed band, to which the new value is assigned, from an upper boundary of the same band;
determining an in-band distance by multiplying the total band distance with the band percentage value; and
determining a KPI score based on adding the lower boundary value of the evenly distributed band to the in-band distance. - View Dependent Claims (15, 16, 17, 18)
-
-
19. A system for generating summary scores from heterogeneous measures stored in a multi-dimensional hierarchy structure, the system comprising:
-
a first computing device configured to store a multi-dimensional database that includes data associated with the heterogeneous measures;
a second computing device in connection with the first computing device configured to receive user input associated with processing the data associated with the heterogeneous measures;
a third computing device that is configured to execute computer-executable instructions associated with processing the heterogeneous measures, the computer-executable instructions comprising;
retrieving data associated with at least one measure from a multi-dimensional database;
determining an actual scale between a worst case value and a best case value for the measure that includes a predetermined number of actual bands;
assigning a value within one of the actual bands to the retrieved data based on a comparison of the data with the actual scale;
determining a band percentage value based on dividing a distance between a lower boundary of the actual band, in which the value is assigned and the value by a length of the actual band;
establishing an evenly distributed scale comprising a number of evenly distributed bands, wherein a number of the evenly distributed bands is the same as the number of actual bands, and wherein boundaries of the evenly distributed bands are equidistant;
mapping a new value on the evenly distributed scale to the value on the actual scale;
determining a total band distance by subtracting a lower boundary value of an evenly distributed band, to which the new value is assigned, from an upper boundary of the same band;
determining an in-band distance by multiplying the total band distance with the band percentage value; and
determining a KPI score based on adding the lower boundary value of the evenly distributed band to the in-band distance; and
a fourth computing device that is configured to present the summary scores generated by the third computing device to at least one of a user and a network. - View Dependent Claims (20)
-
Specification